Setting up (OFBiz + MySQL) with utf8 encoding to support arabic

[Ahmed Talaat]

Hi,
Can anyone tell me how to set ofbiz with mysql set with utf8 encoding?
I followed the instructions from "
opentaps-0.9-configuring-for-mysql-screenshots.zip"
I created a database with utf8 encoding and edited entityengine.xml to work
with it.
When running: *ant run-install*. I get the following error:

 java.sql.SQLException
     [java] MESSAGE: Unknown initial character set index '192' received from
server. Initial client character set can be forced via the
'characterEncoding' property.

I'm using Ubuntu Linux Feisty + MySQL 5.0.38

Regards,
Ahmed

[Vikrant.Rathore]

Hi Ahmed,

Ofbiz out of the box support utf-8 since it’s a built in support in Java language. We use it for Chinese characters here without any problems so far.

But be specific with the details of the error and can help you.

By the way have you checked your OS settings also mysql db you create should use UTF encoding.

Regards,
Vikrant

-----Original Message-----
From: Ahmed Talaat [mailto:[hidden email]]
Sent: Friday, June 01, 2007 2:56 PM
To: [hidden email]
Subject: Setting up (OFBiz + MySQL) with utf8 encoding to support arabic

Hi,
Can anyone tell me how to set ofbiz with mysql set with utf8 encoding?
I followed the instructions from "
opentaps-0.9-configuring-for-mysql-screenshots.zip"
I created a database with utf8 encoding and edited entityengine.xml to work
with it.
When running: *ant run-install*. I get the following error:

 java.sql.SQLException
     [java] MESSAGE: Unknown initial character set index '192' received from
server. Initial client character set can be forced via the
'characterEncoding' property.

I'm using Ubuntu Linux Feisty + MySQL 5.0.38

Regards,
Ahmed

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.5/826 - Release Date: 5/31/2007 4:51 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.5/826 - Release Date: 5/31/2007 4:51 PM
 

[Ahmed Talaat]

Thanks for replying Vikrant.

I'm not a linux expert so please tell me what to check in the OS.
As for mysql server and mysql db both set to utf8 and collation
utf8_unicode_ci
here's the output of status; at mysql console:

mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2

Connection id:          268
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 12 hours 6 min 43 sec

As for the output of building ofbiz tables (ant run-install) it's too big so
i pasted below what seems relevant.
Finally i'm using opentaps-0-9-4.

Regards,
Ahmed




    [java] 2007-06-01 12:43:43,933 (main) [   GenericDelegator.java:159:INFO
] Doing entity definition check...
     [java] 2007-06-01 12:43:43,951 (main) [ ModelEntityChecker.java:514:INFO
] [initReservedWords] array length=1023
     [java] 2007-06-01 12:43:43,993 (main) [            UtilXml.java:242:DEBUG]
XML Read 0.0080s: entityengine.xml
     [java] 2007-06-01 12:43:44,141 (main) [            UtilXml.java:242:DEBUG]
XML Read 0.018s: entityengine.xml
     [java] 2007-06-01 12:43:44,285 (main) [   GenericDelegator.java:176:INFO
] Delegator "default" initializing helper "localmysql" for entity group "
org.ofbiz".
     [java] 2007-06-01 12:43:44,294 (main) [   GenericDelegator.java:193:INFO
] Doing database check as requested in entityengine.xml with addMissing=true
     [java] 2007-06-01 12:43:44,402 (main) [            UtilXml.java:242:DEBUG]
XML Read 0.0050s:
file:/home/ahmed/yasenko/ofbizarabic/base/config/jndiservers.xml
     [java] 2007-06-01 12:44:12,969 (main) [XAConnectionFactory.java:371:ERROR]
Can't get an XAConnection
     [java] java.sql.SQLException: Server connection failure during
transaction. Due to underlying exception: 'java.sql.SQLException: Unknown
initial character set index '192' received from server. Initial client
character set can be forced via the 'characterEncoding' property.'.

     [java] ** BEGIN NESTED EXCEPTION **

     [java] java.sql.SQLException
     [java] MESSAGE: Unknown initial character set index '192' received from
server. Initial client character set can be forced via the
'characterEncoding' property.

     [java] STACKTRACE:

     [java] java.sql.SQLException: Unknown initial character set index '192'
received from server. Initial client character set can be forced via the
'characterEncoding' property.
     [java]     at com.mysql.jdbc.Connection.configureClientCharacterSet(
Connection.java:2667)
     [java]     at com.mysql.jdbc.Connection.initializePropsFromServer(
Connection.java:3304)
     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
:1946)
     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:411)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:185)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
XADataSourceImpl.java:223)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
XAConnectionFactory.java:367)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:942)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.fillToMin(
ObjectPool.java:961)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.initialize(
ObjectPool.java:533)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.initialize(
XAPoolDataSource.java:313)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:349)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:122)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
DatabaseUtil.java:105)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
DatabaseUtil.java:832)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:141)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:130)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
GenericDAO.java:1108)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
GenericHelperDAO.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:195)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)


     [java] ** END NESTED EXCEPTION **


     [java] Attempted reconnect 3 times. Giving up.
     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
:1994)
     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:411)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:185)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
XADataSourceImpl.java:223)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
XAConnectionFactory.java:367)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:942)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.fillToMin(
ObjectPool.java:961)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.initialize(
ObjectPool.java:533)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.initialize(
XAPoolDataSource.java:313)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:349)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:122)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
DatabaseUtil.java:105)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
DatabaseUtil.java:832)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:141)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:130)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
GenericDAO.java:1108)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
GenericHelperDAO.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:195)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
     [java] 2007-06-01 12:44:12,972 (main) [         ObjectPool.java:632:ERROR]
Exception in creating new object for pool
     [java] java.lang.RuntimeException: Could not create connection
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:944)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.fillToMin(
ObjectPool.java:961)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.initialize(
ObjectPool.java:533)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.initialize(
XAPoolDataSource.java:313)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:349)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:122)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
DatabaseUtil.java:105)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
DatabaseUtil.java:832)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:141)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:130)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
GenericDAO.java:1108)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
GenericHelperDAO.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:195)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
     [java] 2007-06-01 12:44:41,144 (main) [XAConnectionFactory.java:371:ERROR]
Can't get an XAConnection
     [java] java.sql.SQLException: Server connection failure during
transaction. Due to underlying exception: 'java.sql.SQLException: Unknown
initial character set index '192' received from server. Initial client
character set can be forced via the 'characterEncoding' property.'.

     [java] ** BEGIN NESTED EXCEPTION **

     [java] java.sql.SQLException
     [java] MESSAGE: Unknown initial character set index '192' received from
server. Initial client character set can be forced via the
'characterEncoding' property.

     [java] STACKTRACE:

     [java] java.sql.SQLException: Unknown initial character set index '192'
received from server. Initial client character set can be forced via the
'characterEncoding' property.
     [java]     at com.mysql.jdbc.Connection.configureClientCharacterSet(
Connection.java:2667)
     [java]     at com.mysql.jdbc.Connection.initializePropsFromServer(
Connection.java:3304)
     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
:1946)
     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:411)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:185)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
XADataSourceImpl.java:223)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
XAConnectionFactory.java:365)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:942)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:355)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:122)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
DatabaseUtil.java:105)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
DatabaseUtil.java:832)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:141)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:130)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
GenericDAO.java:1108)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
GenericHelperDAO.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:195)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)


     [java] ** END NESTED EXCEPTION **


     [java] Attempted reconnect 3 times. Giving up.
     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
:1994)
     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:411)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:185)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
XADataSourceImpl.java:223)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
XAConnectionFactory.java:365)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:942)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:355)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:122)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
DatabaseUtil.java:105)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
DatabaseUtil.java:832)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:141)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:130)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
GenericDAO.java:1108)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
GenericHelperDAO.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:195)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
     [java] 2007-06-01 12:44:41,148 (main) [         ObjectPool.java:632:ERROR]
Exception in creating new object for pool
     [java] java.lang.RuntimeException: Could not create connection
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:944)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:355)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:122)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
DatabaseUtil.java:105)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
DatabaseUtil.java:832)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:141)
     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
DatabaseUtil.java:130)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
GenericDAO.java:1108)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
GenericHelperDAO.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:195)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
     [java] 2007-06-01 12:44:41,156 (main) [  ConnectionFactory.java:95
:ERROR]
     [java] ---- runtime exception report
--------------------------------------------------
     [java] There was an error getting a Minerva datasource.
     [java] Exception: java.lang.RuntimeException
     [java] Message: Could not create connection
     [java] ---- stack trace
---------------------------------------------------------------
     [java] java.lang.RuntimeException: Could not create connection
     [java] org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:944)
     [java] org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630)
     [java] org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:355)
     [java]
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:122)
     [java]
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java] org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java] org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java] org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java] org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
DatabaseUtil.java:105)
     [java] org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
DatabaseUtil.java:832)
     [java] org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java
:141)
     [java] org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java
:130)
     [java] org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java
:1108)
     [java] org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
GenericHelperDAO.java:208)
     [java] org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java
:195)
     [java] org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java] org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
     [java] org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java] org.ofbiz.base.start.Start.start(Start.java:327)
     [java] org.ofbiz.base.start.Start.main(Start.java:413)
     [java]
--------------------------------------------------------------------------------

     [java] 2007-06-01 12:44:41,157 (main) [  ConnectionFactory.java:84
:ERROR] ******* ERROR: No database connection found for helperName
"localmysql"
     [java] 2007-06-01 12:44:41,159 (main) [       DatabaseUtil.java:840:ERROR]
Unable to esablish a connection with the database... Error was:
org.ofbiz.entity.GenericEntityException: No connection available for helper
named [localmysql]
     [java] 2007-06-01 12:44:41,160 (main) [       DatabaseUtil.java:148:ERROR]
Could not get table name information from the database, aborting.
     [java] 2007-06-01 12:44:41,160 (main) [   GenericDelegator.java:176:INFO
] Delegator "default" initializing helper "localderbyodbc" for entity group
"org.ofbiz.odbc".
     [java] 2007-06-01 12:44:41,161 (main) [   GenericDelegator.java:193:INFO
] Doing database check as requested in entityengine.xml with addMissing=true
     [java] 2007-06-01 12:44:42,142 (main) [       DatabaseUtil.java:765:INFO
] Database Product Name is Apache Derby
     [java] 2007-06-01 12:44:42,142 (main) [       DatabaseUtil.java:766:INFO
] Database Product Version is 10.1.2.1
     [java] 2007-06-01 12:44:42,143 (main) [       DatabaseUtil.java:774:INFO
] Database Driver Name is Apache Derby Embedded JDBC Driver
     [java] 2007-06-01 12:44:42,144 (main) [       DatabaseUtil.java:775:INFO
] Database Driver Version is 10.1.2.1
     [java] 2007-06-01 12:44:42,144 (main) [       DatabaseUtil.java:776:INFO
] Database Driver JDBC Version is 3.0
     [java] 2007-06-01 12:44:42,145 (main) [       DatabaseUtil.java:786:INFO
] Database Setting/Support Information (those with a * should be true):
     [java] 2007-06-01 12:44:42,145 (main) [       DatabaseUtil.java:787:INFO
] - supports transactions    [true]*
     [java] 2007-06-01 12:44:42,145 (main) [       DatabaseUtil.java:788:INFO
] - isolation None           [false]
     [java] 2007-06-01 12:44:42,150 (main) [       DatabaseUtil.java:789:INFO
] - isolation ReadCommitted  [true]
     [java] 2007-06-01 12:44:42,150 (main) [       DatabaseUtil.java:790:INFO
] - isolation ReadUncommitted[true]
     [java] 2007-06-01 12:44:42,150 (main) [       DatabaseUtil.java:791:INFO
] - isolation RepeatableRead [true]
     [java] 2007-06-01 12:44:42,151 (main) [       DatabaseUtil.java:792:INFO
] - isolation Serializable   [true]
     [java] 2007-06-01 12:44:42,159 (main) [       DatabaseUtil.java:793:INFO
] - default fetchsize        [1]
     [java] 2007-06-01 12:44:42,160 (main) [       DatabaseUtil.java:794:INFO
] - forward only type        [true]
     [java] 2007-06-01 12:44:42,160 (main) [       DatabaseUtil.java:795:INFO
] - scroll sensitive type    [false]
     [java] 2007-06-01 12:44:42,161 (main) [       DatabaseUtil.java:796:INFO
] - scroll insensitive type  [true]
     [java] 2007-06-01 12:44:42,161 (main) [       DatabaseUtil.java:797:INFO
] - is case sensitive        [false]
     [java] 2007-06-01 12:44:42,162 (main) [       DatabaseUtil.java:798:INFO
] - stores LowerCase         [false]
     [java] 2007-06-01 12:44:42,162 (main) [       DatabaseUtil.java:799:INFO
] - stores MixedCase         [false]
     [java] 2007-06-01 12:44:42,163 (main) [       DatabaseUtil.java:800:INFO
] - stores UpperCase         [true]
     [java] 2007-06-01 12:44:42,163 (main) [       DatabaseUtil.java:801:INFO
] - max table name length    [128]
     [java] 2007-06-01 12:44:42,164 (main) [       DatabaseUtil.java:802:INFO
] - max column name length   [128]
     [java] 2007-06-01 12:44:42,164 (main) [       DatabaseUtil.java:803:INFO
] - max schema name length   [128]
     [java] 2007-06-01 12:44:42,165 (main) [       DatabaseUtil.java:804:INFO
] - concurrent connections   [0]
     [java] 2007-06-01 12:44:42,165 (main) [       DatabaseUtil.java:805:INFO
] - concurrent statements    [0]
     [java] 2007-06-01 12:44:42,165 (main) [       DatabaseUtil.java:806:INFO
] - ANSI SQL92 Entry         [false]
     [java] 2007-06-01 12:44:42,166 (main) [       DatabaseUtil.java:807:INFO
] - ANSI SQL92 Itermediate   [false]
     [java] 2007-06-01 12:44:42,166 (main) [       DatabaseUtil.java:808:INFO
] - ANSI SQL92 Full          [false]
     [java] 2007-06-01 12:44:42,167 (main) [       DatabaseUtil.java:809:INFO
] - ODBC SQL Grammar Core    [false]
     [java] 2007-06-01 12:44:42,168 (main) [       DatabaseUtil.java:810:INFO
] - ODBC SQL Grammar Extended[false]
     [java] 2007-06-01 12:44:42,168 (main) [       DatabaseUtil.java:811:INFO
] - ODBC SQL Grammar Minimum [true]
     [java] 2007-06-01 12:44:42,169 (main) [       DatabaseUtil.java:812:INFO
] - outer joins              [true]*
     [java] 2007-06-01 12:44:42,174 (main) [       DatabaseUtil.java:813:INFO
] - limited outer joins      [true]
     [java] 2007-06-01 12:44:42,175 (main) [       DatabaseUtil.java:814:INFO
] - full outer joins         [false]
     [java] 2007-06-01 12:44:42,175 (main) [       DatabaseUtil.java:815:INFO
] - group by                 [true]*
     [java] 2007-06-01 12:44:42,176 (main) [       DatabaseUtil.java:816:INFO
] - group by not in select   [true]
     [java] 2007-06-01 12:44:42,178 (main) [       DatabaseUtil.java:817:INFO
] - column aliasing          [true]
     [java] 2007-06-01 12:44:42,179 (main) [       DatabaseUtil.java:818:INFO
] - order by not in select   [false]
     [java] 2007-06-01 12:44:42,180 (main) [       DatabaseUtil.java:820:INFO
] - alter table add column   [true]*
     [java] 2007-06-01 12:44:42,181 (main) [       DatabaseUtil.java:821:INFO
] - non-nullable column      [true]*
     [java] 2007-06-01 12:44:42,183 (main) [       DatabaseUtil.java:858:INFO
] Getting Table Info From Database
     [java] 2007-06-01 12:44:42,943 (main) [       DatabaseUtil.java:993:INFO
] Getting Column Info From Database
     [java] 2007-06-01 12:45:11,369 (main) [XAConnectionFactory.java:371:ERROR]
Can't get an XAConnection
     [java] java.sql.SQLException: Server connection failure during
transaction. Due to underlying exception: 'java.sql.SQLException: Unknown
initial character set index '192' received from server. Initial client
character set can be forced via the 'characterEncoding' property.'.

     [java] ** BEGIN NESTED EXCEPTION **

     [java] java.sql.SQLException
     [java] MESSAGE: Unknown initial character set index '192' received from
server. Initial client character set can be forced via the
'characterEncoding' property.

     [java] STACKTRACE:

     [java] java.sql.SQLException: Unknown initial character set index '192'
received from server. Initial client character set can be forced via the
'characterEncoding' property.
     [java]     at com.mysql.jdbc.Connection.configureClientCharacterSet(
Connection.java:2667)
     [java]     at com.mysql.jdbc.Connection.initializePropsFromServer(
Connection.java:3304)
     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
:1946)
     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:411)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:185)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
XADataSourceImpl.java:223)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
XAConnectionFactory.java:365)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:942)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:355)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:56)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(
SQLProcessor.java:268)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
SQLProcessor.java:374)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
SQLProcessor.java:358)
     [java]     at
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(
GenericDAO.java:992)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(
GenericHelperDAO.java:162)
     [java]     at org.ofbiz.entity.GenericDelegator.findCountByCondition(
GenericDelegator.java:1877)
     [java]     at org.ofbiz.entity.GenericDelegator.findCountByAnd(
GenericDelegator.java:1849)
     [java]     at org.ofbiz.entity.util.EntityCrypto.<init>(
EntityCrypto.java:72)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)


     [java] ** END NESTED EXCEPTION **


     [java] Attempted reconnect 3 times. Giving up.
     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
:1994)
     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:411)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
:185)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
XADataSourceImpl.java:223)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
XAConnectionFactory.java:365)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:942)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:355)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:56)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(
SQLProcessor.java:268)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
SQLProcessor.java:374)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
SQLProcessor.java:358)
     [java]     at
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(
GenericDAO.java:992)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(
GenericHelperDAO.java:162)
     [java]     at org.ofbiz.entity.GenericDelegator.findCountByCondition(
GenericDelegator.java:1877)
     [java]     at org.ofbiz.entity.GenericDelegator.findCountByAnd(
GenericDelegator.java:1849)
     [java]     at org.ofbiz.entity.util.EntityCrypto.<init>(
EntityCrypto.java:72)
     [java] Exception in thread "main" java.lang.NoSuchMethodError:
sun.rmi.transport.ObjectTable.getStub
(Ljava/rmi/Remote;)Ljava/rmi/server/RemoteStub;
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:208)
     [java]     at
org.objectweb.carol.rmi.jrmp.server.JUnicastRemoteObject.unexportObject(
JUnicastRemoteObject.java:138)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at
org.objectweb.carol.rmi.multi.JrmpPRODelegate.unexportObject(
JrmpPRODelegate.java:94)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at
org.objectweb.carol.rmi.multi.MultiPRODelegate.unexportObject(
MultiPRODelegate.java:132)
     [java]     at javax.rmi.PortableRemoteObject.unexportObject(
PortableRemoteObject.java:119)
     [java]     at org.objectweb.jotm.SubCoordinator.doAfterCompletion(
SubCoordinator.java:1548)
     [java]     at org.objectweb.jotm.SubCoordinator.doRollback(
SubCoordinator.java:1324)
     [java]     at org.objectweb.jotm.SubCoordinator.rollback(
SubCoordinator.java:321)
     [java]     at org.objectweb.jotm.TransactionImpl.rollback(
TransactionImpl.java:643)
     [java]     at org.objectweb.jotm.Current.rollback(Current.java:529)
     [java]     at org.ofbiz.entity.transaction.TransactionUtil.rollback(
TransactionUtil.java:263)
     [java]     at org.ofbiz.entity.transaction.TransactionUtil.rollback(
TransactionUtil.java:235)
     [java]     at org.ofbiz.entity.GenericDelegator.findCountByCondition(
GenericDelegator.java:1886)
     [java]     at org.ofbiz.entity.GenericDelegator.findCountByAnd(
GenericDelegator.java:1849)
     [java]     at org.ofbiz.entity.util.EntityCrypto.<init>(
EntityCrypto.java:72)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
     [java] 2007-06-01 12:45:11,370 (main) [         ObjectPool.java:632:ERROR]
Exception in creating new object for pool
     [java] java.lang.RuntimeException: Could not create connection
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:944)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
ObjectPool.java:630)
     [java]     at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:355)
     [java]     at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:56)
     [java]     at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java]     at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(
SQLProcessor.java:268)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
SQLProcessor.java:374)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
SQLProcessor.java:358)
     [java]     at
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(
GenericDAO.java:992)
     [java]     at
org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(
GenericHelperDAO.java:162)
     [java]     at org.ofbiz.entity.GenericDelegator.findCountByCondition(
GenericDelegator.java:1877)
     [java]     at org.ofbiz.entity.GenericDelegator.findCountByAnd(
GenericDelegator.java:1849)
     [java]     at org.ofbiz.entity.util.EntityCrypto.<init>(
EntityCrypto.java:72)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
GenericDelegator.java:208)
     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
:272)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
     [java] 2007-06-01 12:45:11,376 (main) [  ConnectionFactory.java:95
:ERROR]
     [java] ---- runtime exception report
--------------------------------------------------
     [java] There was an error getting a Minerva datasource.
     [java] Exception: java.lang.RuntimeException
     [java] Message: Could not create connection
     [java] ---- stack trace
---------------------------------------------------------------
     [java] java.lang.RuntimeException: Could not create connection
     [java] org.ofbiz.minerva.pool.ObjectPool.createNewObject(
ObjectPool.java:944)
     [java] org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630)
     [java] org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
XAPoolDataSource.java:355)
     [java]
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
MinervaConnectionFactory.java:56)
     [java]
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
ConnectionFactory.java:92)
     [java] org.ofbiz.entity.transaction.JNDIFactory.getConnection(
JNDIFactory.java:158)
     [java] org.ofbiz.entity.transaction.TransactionFactory.getConnection(
TransactionFactory.java:104)
     [java] org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
ConnectionFactory.java:82)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.getConnection(
SQLProcessor.java:268)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
SQLProcessor.java:374)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
SQLProcessor.java:358)
     [java] org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(
GenericDAO.java:992)
     [java]
org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(
GenericHelperDAO.java:162)
     [java] org.ofbiz.entity.GenericDelegator.findCountByCondition(
GenericDelegator.java:1877)
     [java] org.ofbiz.entity.GenericDelegator.findCountByAnd(
GenericDelegator.java:1849)
     [java] org.ofbiz.entity.util.EntityCrypto.<init>(EntityCrypto.java:72)
     [java] org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java
:208)
     [java] org.ofbiz.entity.GenericDelegator.getGenericDelegator(
GenericDelegator.java:127)
     [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(
EntityDataLoadContainer.java:184)
     [java] org.ofbiz.base.container.ContainerLoader.start(
ContainerLoader.java:89)
     [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
     [java] org.ofbiz.base.start.Start.startServer(Start.java:323)
     [java] org.ofbiz.base.start.Start.start(Start.java:327)
     [java] org.ofbiz.base.start.Start.main(Start.java:413)
     [java]
--------------------------------------------------------------------------------

     [java] 2007-06-01 12:45:11,377 (main) [  ConnectionFactory.java:84
:ERROR] ******* ERROR: No database connection found for helperName
"localmysql"
     [java] 2007-06-01 12:45:11,378 (main) [
GenericDelegator.java:1883:ERROR]

     [java] ---- exception report
----------------------------------------------------------
     [java] Failure in findListIteratorByCondition operation for entity
[DynamicView]: org.ofbiz.entity.GenericDataSourceException: Unable to
esablish a connection with the database. Connection was null!. Rolling back
transaction.

On 6/1/07, [hidden email] <
[hidden email]> wrote:

>
> Hi Ahmed,
>
> Ofbiz out of the box support utf-8 since it's a built in support in Java
> language. We use it for Chinese characters here without any problems so far.
>
> But be specific with the details of the error and can help you.
>
> By the way have you checked your OS settings also mysql db you create
> should use UTF encoding.
>
> Regards,
> Vikrant
>
> -----Original Message-----
> From: Ahmed Talaat [mailto:[hidden email]]
> Sent: Friday, June 01, 2007 2:56 PM
> To: [hidden email]
> Subject: Setting up (OFBiz + MySQL) with utf8 encoding to support arabic
>
> Hi,
> Can anyone tell me how to set ofbiz with mysql set with utf8 encoding?
> I followed the instructions from "
> opentaps-0.9-configuring-for-mysql-screenshots.zip"
> I created a database with utf8 encoding and edited entityengine.xml to
> work
> with it.
> When running: *ant run-install*. I get the following error:
>
> java.sql.SQLException
>      [java] MESSAGE: Unknown initial character set index '192' received
> from
> server. Initial client character set can be forced via the
> 'characterEncoding' property.
>
> I'm using Ubuntu Linux Feisty + MySQL 5.0.38
>
> Regards,
> Ahmed
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.5/826 - Release Date: 5/31/2007
> 4:51 PM
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.5/826 - Release Date: 5/31/2007
> 4:51 PM
>
>

[Oleg Andreyev]

Hi Ahmed,

 > Server characterset:    utf8
 > Db     characterset:    utf8
 > Client characterset:    latin1
 > Conn.  characterset:    latin1

You have to set both client and connection charactersets  to utf8.  It
can be done in my.ini file.
But first, try to add  default-character-set=utf8 to [client] section of
the my.ini.

Regards,
   Oleg Andreyev

Ahmed Talaat пишет:

> Thanks for replying Vikrant.
>
> I'm not a linux expert so please tell me what to check in the OS.
> As for mysql server and mysql db both set to utf8 and collation
> utf8_unicode_ci
> here's the output of status; at mysql console:
>
> mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using
> readline 5.2
>
> Connection id:          268
> Current database:
> Current user:           root@localhost
> SSL:                    Not in use
> Current pager:          stdout
> Using outfile:          ''
> Using delimiter:        ;
> Server version:         5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04
> distribution
> Protocol version:       10
> Connection:             Localhost via UNIX socket
> Server characterset:    utf8
> Db     characterset:    utf8
> Client characterset:    latin1
> Conn.  characterset:    latin1
> UNIX socket:            /var/run/mysqld/mysqld.sock
> Uptime:                 12 hours 6 min 43 sec
>
> As for the output of building ofbiz tables (ant run-install) it's too
> big so
> i pasted below what seems relevant.
> Finally i'm using opentaps-0-9-4.
>
> Regards,
> Ahmed
>
>
>
>
>    [java] 2007-06-01 12:43:43,933 (main) [  
> GenericDelegator.java:159:INFO
> ] Doing entity definition check...
>     [java] 2007-06-01 12:43:43,951 (main) [
> ModelEntityChecker.java:514:INFO
> ] [initReservedWords] array length=1023
>     [java] 2007-06-01 12:43:43,993 (main) [            
> UtilXml.java:242:DEBUG]
> XML Read 0.0080s: entityengine.xml
>     [java] 2007-06-01 12:43:44,141 (main) [            
> UtilXml.java:242:DEBUG]
> XML Read 0.018s: entityengine.xml
>     [java] 2007-06-01 12:43:44,285 (main) [  
> GenericDelegator.java:176:INFO
> ] Delegator "default" initializing helper "localmysql" for entity group "
> org.ofbiz".
>     [java] 2007-06-01 12:43:44,294 (main) [  
> GenericDelegator.java:193:INFO
> ] Doing database check as requested in entityengine.xml with
> addMissing=true
>     [java] 2007-06-01 12:43:44,402 (main) [            
> UtilXml.java:242:DEBUG]
> XML Read 0.0050s:
> file:/home/ahmed/yasenko/ofbizarabic/base/config/jndiservers.xml
>     [java] 2007-06-01 12:44:12,969 (main)
> [XAConnectionFactory.java:371:ERROR]
> Can't get an XAConnection
>     [java] java.sql.SQLException: Server connection failure during
> transaction. Due to underlying exception: 'java.sql.SQLException: Unknown
> initial character set index '192' received from server. Initial client
> character set can be forced via the 'characterEncoding' property.'.
>
>     [java] ** BEGIN NESTED EXCEPTION **
>
>     [java] java.sql.SQLException
>     [java] MESSAGE: Unknown initial character set index '192' received
> from
> server. Initial client character set can be forced via the
> 'characterEncoding' property.
>
>     [java] STACKTRACE:
>
>     [java] java.sql.SQLException: Unknown initial character set index
> '192'
> received from server. Initial client character set can be forced via the
> 'characterEncoding' property.
>     [java]     at com.mysql.jdbc.Connection.configureClientCharacterSet(
> Connection.java:2667)
>     [java]     at com.mysql.jdbc.Connection.initializePropsFromServer(
> Connection.java:3304)
>     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
> :1946)
>     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
>     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
> NonRegisteringDriver.java:411)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :582)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :185)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
> XADataSourceImpl.java:223)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
> XAConnectionFactory.java:367)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:942)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.fillToMin(
> ObjectPool.java:961)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.initialize(
> ObjectPool.java:533)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.initialize(
> XAPoolDataSource.java:313)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:349)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:122)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
> DatabaseUtil.java:105)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
> DatabaseUtil.java:832)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:141)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:130)
>     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
> GenericDAO.java:1108)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
> GenericHelperDAO.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:195)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>
>
>     [java] ** END NESTED EXCEPTION **
>
>
>     [java] Attempted reconnect 3 times. Giving up.
>     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
> :1994)
>     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
>     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
> NonRegisteringDriver.java:411)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :582)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :185)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
> XADataSourceImpl.java:223)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
> XAConnectionFactory.java:367)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:942)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.fillToMin(
> ObjectPool.java:961)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.initialize(
> ObjectPool.java:533)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.initialize(
> XAPoolDataSource.java:313)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:349)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:122)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
> DatabaseUtil.java:105)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
> DatabaseUtil.java:832)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:141)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:130)
>     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
> GenericDAO.java:1108)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
> GenericHelperDAO.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:195)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>     [java] 2007-06-01 12:44:12,972 (main) [        
> ObjectPool.java:632:ERROR]
> Exception in creating new object for pool
>     [java] java.lang.RuntimeException: Could not create connection
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:944)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.fillToMin(
> ObjectPool.java:961)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.initialize(
> ObjectPool.java:533)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.initialize(
> XAPoolDataSource.java:313)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:349)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:122)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
> DatabaseUtil.java:105)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
> DatabaseUtil.java:832)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:141)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:130)
>     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
> GenericDAO.java:1108)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
> GenericHelperDAO.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:195)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>     [java] 2007-06-01 12:44:41,144 (main)
> [XAConnectionFactory.java:371:ERROR]
> Can't get an XAConnection
>     [java] java.sql.SQLException: Server connection failure during
> transaction. Due to underlying exception: 'java.sql.SQLException: Unknown
> initial character set index '192' received from server. Initial client
> character set can be forced via the 'characterEncoding' property.'.
>
>     [java] ** BEGIN NESTED EXCEPTION **
>
>     [java] java.sql.SQLException
>     [java] MESSAGE: Unknown initial character set index '192' received
> from
> server. Initial client character set can be forced via the
> 'characterEncoding' property.
>
>     [java] STACKTRACE:
>
>     [java] java.sql.SQLException: Unknown initial character set index
> '192'
> received from server. Initial client character set can be forced via the
> 'characterEncoding' property.
>     [java]     at com.mysql.jdbc.Connection.configureClientCharacterSet(
> Connection.java:2667)
>     [java]     at com.mysql.jdbc.Connection.initializePropsFromServer(
> Connection.java:3304)
>     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
> :1946)
>     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
>     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
> NonRegisteringDriver.java:411)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :582)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :185)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
> XADataSourceImpl.java:223)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
> XAConnectionFactory.java:365)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:942)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:122)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
> DatabaseUtil.java:105)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
> DatabaseUtil.java:832)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:141)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:130)
>     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
> GenericDAO.java:1108)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
> GenericHelperDAO.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:195)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>
>
>     [java] ** END NESTED EXCEPTION **
>
>
>     [java] Attempted reconnect 3 times. Giving up.
>     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
> :1994)
>     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
>     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
> NonRegisteringDriver.java:411)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :582)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :185)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
> XADataSourceImpl.java:223)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
> XAConnectionFactory.java:365)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:942)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:122)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
> DatabaseUtil.java:105)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
> DatabaseUtil.java:832)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:141)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:130)
>     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
> GenericDAO.java:1108)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
> GenericHelperDAO.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:195)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>     [java] 2007-06-01 12:44:41,148 (main) [        
> ObjectPool.java:632:ERROR]
> Exception in creating new object for pool
>     [java] java.lang.RuntimeException: Could not create connection
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:944)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:122)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
> DatabaseUtil.java:105)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
> DatabaseUtil.java:832)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:141)
>     [java]     at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(
> DatabaseUtil.java:130)
>     [java]     at org.ofbiz.entity.datasource.GenericDAO.checkDb(
> GenericDAO.java:1108)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
> GenericHelperDAO.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:195)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>     [java] 2007-06-01 12:44:41,156 (main) [  ConnectionFactory.java:95
> :ERROR]
>     [java] ---- runtime exception report
> --------------------------------------------------
>     [java] There was an error getting a Minerva datasource.
>     [java] Exception: java.lang.RuntimeException
>     [java] Message: Could not create connection
>     [java] ---- stack trace
> ---------------------------------------------------------------
>     [java] java.lang.RuntimeException: Could not create connection
>     [java] org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:944)
>     [java]
> org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630)
>     [java] org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
>     [java]
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:122)
>     [java]
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java] org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java] org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java] org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java] org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(
> DatabaseUtil.java:105)
>     [java] org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(
> DatabaseUtil.java:832)
>     [java] org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java
> :141)
>     [java] org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java
> :130)
>     [java] org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java
> :1108)
>     [java] org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
> GenericHelperDAO.java:208)
>     [java] org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java
> :195)
>     [java] org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java] org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
>     [java] org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java] org.ofbiz.base.start.Start.start(Start.java:327)
>     [java] org.ofbiz.base.start.Start.main(Start.java:413)
>     [java]
> --------------------------------------------------------------------------------
>
>
>     [java] 2007-06-01 12:44:41,157 (main) [  ConnectionFactory.java:84
> :ERROR] ******* ERROR: No database connection found for helperName
> "localmysql"
>     [java] 2007-06-01 12:44:41,159 (main) [      
> DatabaseUtil.java:840:ERROR]
> Unable to esablish a connection with the database... Error was:
> org.ofbiz.entity.GenericEntityException: No connection available for
> helper
> named [localmysql]
>     [java] 2007-06-01 12:44:41,160 (main) [      
> DatabaseUtil.java:148:ERROR]
> Could not get table name information from the database, aborting.
>     [java] 2007-06-01 12:44:41,160 (main) [  
> GenericDelegator.java:176:INFO
> ] Delegator "default" initializing helper "localderbyodbc" for entity
> group
> "org.ofbiz.odbc".
>     [java] 2007-06-01 12:44:41,161 (main) [  
> GenericDelegator.java:193:INFO
> ] Doing database check as requested in entityengine.xml with
> addMissing=true
>     [java] 2007-06-01 12:44:42,142 (main) [      
> DatabaseUtil.java:765:INFO
> ] Database Product Name is Apache Derby
>     [java] 2007-06-01 12:44:42,142 (main) [      
> DatabaseUtil.java:766:INFO
> ] Database Product Version is 10.1.2.1
>     [java] 2007-06-01 12:44:42,143 (main) [      
> DatabaseUtil.java:774:INFO
> ] Database Driver Name is Apache Derby Embedded JDBC Driver
>     [java] 2007-06-01 12:44:42,144 (main) [      
> DatabaseUtil.java:775:INFO
> ] Database Driver Version is 10.1.2.1
>     [java] 2007-06-01 12:44:42,144 (main) [      
> DatabaseUtil.java:776:INFO
> ] Database Driver JDBC Version is 3.0
>     [java] 2007-06-01 12:44:42,145 (main) [      
> DatabaseUtil.java:786:INFO
> ] Database Setting/Support Information (those with a * should be true):
>     [java] 2007-06-01 12:44:42,145 (main) [      
> DatabaseUtil.java:787:INFO
> ] - supports transactions    [true]*
>     [java] 2007-06-01 12:44:42,145 (main) [      
> DatabaseUtil.java:788:INFO
> ] - isolation None           [false]
>     [java] 2007-06-01 12:44:42,150 (main) [      
> DatabaseUtil.java:789:INFO
> ] - isolation ReadCommitted  [true]
>     [java] 2007-06-01 12:44:42,150 (main) [      
> DatabaseUtil.java:790:INFO
> ] - isolation ReadUncommitted[true]
>     [java] 2007-06-01 12:44:42,150 (main) [      
> DatabaseUtil.java:791:INFO
> ] - isolation RepeatableRead [true]
>     [java] 2007-06-01 12:44:42,151 (main) [      
> DatabaseUtil.java:792:INFO
> ] - isolation Serializable   [true]
>     [java] 2007-06-01 12:44:42,159 (main) [      
> DatabaseUtil.java:793:INFO
> ] - default fetchsize        [1]
>     [java] 2007-06-01 12:44:42,160 (main) [      
> DatabaseUtil.java:794:INFO
> ] - forward only type        [true]
>     [java] 2007-06-01 12:44:42,160 (main) [      
> DatabaseUtil.java:795:INFO
> ] - scroll sensitive type    [false]
>     [java] 2007-06-01 12:44:42,161 (main) [      
> DatabaseUtil.java:796:INFO
> ] - scroll insensitive type  [true]
>     [java] 2007-06-01 12:44:42,161 (main) [      
> DatabaseUtil.java:797:INFO
> ] - is case sensitive        [false]
>     [java] 2007-06-01 12:44:42,162 (main) [      
> DatabaseUtil.java:798:INFO
> ] - stores LowerCase         [false]
>     [java] 2007-06-01 12:44:42,162 (main) [      
> DatabaseUtil.java:799:INFO
> ] - stores MixedCase         [false]
>     [java] 2007-06-01 12:44:42,163 (main) [      
> DatabaseUtil.java:800:INFO
> ] - stores UpperCase         [true]
>     [java] 2007-06-01 12:44:42,163 (main) [      
> DatabaseUtil.java:801:INFO
> ] - max table name length    [128]
>     [java] 2007-06-01 12:44:42,164 (main) [      
> DatabaseUtil.java:802:INFO
> ] - max column name length   [128]
>     [java] 2007-06-01 12:44:42,164 (main) [      
> DatabaseUtil.java:803:INFO
> ] - max schema name length   [128]
>     [java] 2007-06-01 12:44:42,165 (main) [      
> DatabaseUtil.java:804:INFO
> ] - concurrent connections   [0]
>     [java] 2007-06-01 12:44:42,165 (main) [      
> DatabaseUtil.java:805:INFO
> ] - concurrent statements    [0]
>     [java] 2007-06-01 12:44:42,165 (main) [      
> DatabaseUtil.java:806:INFO
> ] - ANSI SQL92 Entry         [false]
>     [java] 2007-06-01 12:44:42,166 (main) [      
> DatabaseUtil.java:807:INFO
> ] - ANSI SQL92 Itermediate   [false]
>     [java] 2007-06-01 12:44:42,166 (main) [      
> DatabaseUtil.java:808:INFO
> ] - ANSI SQL92 Full          [false]
>     [java] 2007-06-01 12:44:42,167 (main) [      
> DatabaseUtil.java:809:INFO
> ] - ODBC SQL Grammar Core    [false]
>     [java] 2007-06-01 12:44:42,168 (main) [      
> DatabaseUtil.java:810:INFO
> ] - ODBC SQL Grammar Extended[false]
>     [java] 2007-06-01 12:44:42,168 (main) [      
> DatabaseUtil.java:811:INFO
> ] - ODBC SQL Grammar Minimum [true]
>     [java] 2007-06-01 12:44:42,169 (main) [      
> DatabaseUtil.java:812:INFO
> ] - outer joins              [true]*
>     [java] 2007-06-01 12:44:42,174 (main) [      
> DatabaseUtil.java:813:INFO
> ] - limited outer joins      [true]
>     [java] 2007-06-01 12:44:42,175 (main) [      
> DatabaseUtil.java:814:INFO
> ] - full outer joins         [false]
>     [java] 2007-06-01 12:44:42,175 (main) [      
> DatabaseUtil.java:815:INFO
> ] - group by                 [true]*
>     [java] 2007-06-01 12:44:42,176 (main) [      
> DatabaseUtil.java:816:INFO
> ] - group by not in select   [true]
>     [java] 2007-06-01 12:44:42,178 (main) [      
> DatabaseUtil.java:817:INFO
> ] - column aliasing          [true]
>     [java] 2007-06-01 12:44:42,179 (main) [      
> DatabaseUtil.java:818:INFO
> ] - order by not in select   [false]
>     [java] 2007-06-01 12:44:42,180 (main) [      
> DatabaseUtil.java:820:INFO
> ] - alter table add column   [true]*
>     [java] 2007-06-01 12:44:42,181 (main) [      
> DatabaseUtil.java:821:INFO
> ] - non-nullable column      [true]*
>     [java] 2007-06-01 12:44:42,183 (main) [      
> DatabaseUtil.java:858:INFO
> ] Getting Table Info From Database
>     [java] 2007-06-01 12:44:42,943 (main) [      
> DatabaseUtil.java:993:INFO
> ] Getting Column Info From Database
>     [java] 2007-06-01 12:45:11,369 (main)
> [XAConnectionFactory.java:371:ERROR]
> Can't get an XAConnection
>     [java] java.sql.SQLException: Server connection failure during
> transaction. Due to underlying exception: 'java.sql.SQLException: Unknown
> initial character set index '192' received from server. Initial client
> character set can be forced via the 'characterEncoding' property.'.
>
>     [java] ** BEGIN NESTED EXCEPTION **
>
>     [java] java.sql.SQLException
>     [java] MESSAGE: Unknown initial character set index '192' received
> from
> server. Initial client character set can be forced via the
> 'characterEncoding' property.
>
>     [java] STACKTRACE:
>
>     [java] java.sql.SQLException: Unknown initial character set index
> '192'
> received from server. Initial client character set can be forced via the
> 'characterEncoding' property.
>     [java]     at com.mysql.jdbc.Connection.configureClientCharacterSet(
> Connection.java:2667)
>     [java]     at com.mysql.jdbc.Connection.initializePropsFromServer(
> Connection.java:3304)
>     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
> :1946)
>     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
>     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
> NonRegisteringDriver.java:411)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :582)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :185)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
> XADataSourceImpl.java:223)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
> XAConnectionFactory.java:365)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:942)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:56)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(
> SQLProcessor.java:268)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
> SQLProcessor.java:374)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
> SQLProcessor.java:358)
>     [java]     at
> org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(
> GenericDAO.java:992)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(
> GenericHelperDAO.java:162)
>     [java]     at org.ofbiz.entity.GenericDelegator.findCountByCondition(
> GenericDelegator.java:1877)
>     [java]     at org.ofbiz.entity.GenericDelegator.findCountByAnd(
> GenericDelegator.java:1849)
>     [java]     at org.ofbiz.entity.util.EntityCrypto.<init>(
> EntityCrypto.java:72)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>
>
>     [java] ** END NESTED EXCEPTION **
>
>
>     [java] Attempted reconnect 3 times. Giving up.
>     [java]     at com.mysql.jdbc.Connection.createNewIO(Connection.java
> :1994)
>     [java]     at com.mysql.jdbc.Connection.<init>(Connection.java:452)
>     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(
> NonRegisteringDriver.java:411)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :582)
>     [java]     at java.sql.DriverManager.getConnection(DriverManager.java
> :185)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(
> XADataSourceImpl.java:223)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(
> XAConnectionFactory.java:365)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:942)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:56)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(
> SQLProcessor.java:268)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
> SQLProcessor.java:374)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
> SQLProcessor.java:358)
>     [java]     at
> org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(
> GenericDAO.java:992)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(
> GenericHelperDAO.java:162)
>     [java]     at org.ofbiz.entity.GenericDelegator.findCountByCondition(
> GenericDelegator.java:1877)
>     [java]     at org.ofbiz.entity.GenericDelegator.findCountByAnd(
> GenericDelegator.java:1849)
>     [java]     at org.ofbiz.entity.util.EntityCrypto.<init>(
> EntityCrypto.java:72)
>     [java] Exception in thread "main" java.lang.NoSuchMethodError:
> sun.rmi.transport.ObjectTable.getStub
> (Ljava/rmi/Remote;)Ljava/rmi/server/RemoteStub;
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:208)
>     [java]     at
> org.objectweb.carol.rmi.jrmp.server.JUnicastRemoteObject.unexportObject(
> JUnicastRemoteObject.java:138)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at
> org.objectweb.carol.rmi.multi.JrmpPRODelegate.unexportObject(
> JrmpPRODelegate.java:94)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at
> org.objectweb.carol.rmi.multi.MultiPRODelegate.unexportObject(
> MultiPRODelegate.java:132)
>     [java]     at javax.rmi.PortableRemoteObject.unexportObject(
> PortableRemoteObject.java:119)
>     [java]     at org.objectweb.jotm.SubCoordinator.doAfterCompletion(
> SubCoordinator.java:1548)
>     [java]     at org.objectweb.jotm.SubCoordinator.doRollback(
> SubCoordinator.java:1324)
>     [java]     at org.objectweb.jotm.SubCoordinator.rollback(
> SubCoordinator.java:321)
>     [java]     at org.objectweb.jotm.TransactionImpl.rollback(
> TransactionImpl.java:643)
>     [java]     at org.objectweb.jotm.Current.rollback(Current.java:529)
>     [java]     at org.ofbiz.entity.transaction.TransactionUtil.rollback(
> TransactionUtil.java:263)
>     [java]     at org.ofbiz.entity.transaction.TransactionUtil.rollback(
> TransactionUtil.java:235)
>     [java]     at org.ofbiz.entity.GenericDelegator.findCountByCondition(
> GenericDelegator.java:1886)
>     [java]     at org.ofbiz.entity.GenericDelegator.findCountByAnd(
> GenericDelegator.java:1849)
>     [java]     at org.ofbiz.entity.util.EntityCrypto.<init>(
> EntityCrypto.java:72)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>     [java] 2007-06-01 12:45:11,370 (main) [        
> ObjectPool.java:632:ERROR]
> Exception in creating new object for pool
>     [java] java.lang.RuntimeException: Could not create connection
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:944)
>     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(
> ObjectPool.java:630)
>     [java]     at
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
>     [java]     at
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:56)
>     [java]     at
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java]     at org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java]     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(
> SQLProcessor.java:268)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
> SQLProcessor.java:374)
>     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
> SQLProcessor.java:358)
>     [java]     at
> org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(
> GenericDAO.java:992)
>     [java]     at
> org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(
> GenericHelperDAO.java:162)
>     [java]     at org.ofbiz.entity.GenericDelegator.findCountByCondition(
> GenericDelegator.java:1877)
>     [java]     at org.ofbiz.entity.GenericDelegator.findCountByAnd(
> GenericDelegator.java:1849)
>     [java]     at org.ofbiz.entity.util.EntityCrypto.<init>(
> EntityCrypto.java:72)
>     [java]     at org.ofbiz.entity.GenericDelegator.<init>(
> GenericDelegator.java:208)
>     [java]     at org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java]     at org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java
> :272)
>     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java]     at org.ofbiz.base.start.Start.start(Start.java:327)
>     [java]     at org.ofbiz.base.start.Start.main(Start.java:413)
>     [java] 2007-06-01 12:45:11,376 (main) [  ConnectionFactory.java:95
> :ERROR]
>     [java] ---- runtime exception report
> --------------------------------------------------
>     [java] There was an error getting a Minerva datasource.
>     [java] Exception: java.lang.RuntimeException
>     [java] Message: Could not create connection
>     [java] ---- stack trace
> ---------------------------------------------------------------
>     [java] java.lang.RuntimeException: Could not create connection
>     [java] org.ofbiz.minerva.pool.ObjectPool.createNewObject(
> ObjectPool.java:944)
>     [java]
> org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630)
>     [java] org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
>     [java]
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(
> MinervaConnectionFactory.java:56)
>     [java]
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:92)
>     [java] org.ofbiz.entity.transaction.JNDIFactory.getConnection(
> JNDIFactory.java:158)
>     [java] org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:104)
>     [java] org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:82)
>     [java] org.ofbiz.entity.jdbc.SQLProcessor.getConnection(
> SQLProcessor.java:268)
>     [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
> SQLProcessor.java:374)
>     [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(
> SQLProcessor.java:358)
>     [java] org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(
> GenericDAO.java:992)
>     [java]
> org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(
> GenericHelperDAO.java:162)
>     [java] org.ofbiz.entity.GenericDelegator.findCountByCondition(
> GenericDelegator.java:1877)
>     [java] org.ofbiz.entity.GenericDelegator.findCountByAnd(
> GenericDelegator.java:1849)
>     [java]
> org.ofbiz.entity.util.EntityCrypto.<init>(EntityCrypto.java:72)
>     [java] org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java
> :208)
>     [java] org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:127)
>     [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(
> EntityDataLoadContainer.java:184)
>     [java] org.ofbiz.base.container.ContainerLoader.start(
> ContainerLoader.java:89)
>     [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
>     [java] org.ofbiz.base.start.Start.startServer(Start.java:323)
>     [java] org.ofbiz.base.start.Start.start(Start.java:327)
>     [java] org.ofbiz.base.start.Start.main(Start.java:413)
>     [java]
> --------------------------------------------------------------------------------
>
>
>     [java] 2007-06-01 12:45:11,377 (main) [  ConnectionFactory.java:84
> :ERROR] ******* ERROR: No database connection found for helperName
> "localmysql"
>     [java] 2007-06-01 12:45:11,378 (main) [
> GenericDelegator.java:1883:ERROR]
>
>     [java] ---- exception report
> ----------------------------------------------------------
>     [java] Failure in findListIteratorByCondition operation for entity
> [DynamicView]: org.ofbiz.entity.GenericDataSourceException: Unable to
> esablish a connection with the database. Connection was null!. Rolling
> back
> transaction.
>
> On 6/1/07, [hidden email] <
> [hidden email]> wrote:
>>
>> Hi Ahmed,
>>
>> Ofbiz out of the box support utf-8 since it's a built in support in Java
>> language. We use it for Chinese characters here without any problems
>> so far.
>>
>> But be specific with the details of the error and can help you.
>>
>> By the way have you checked your OS settings also mysql db you create
>> should use UTF encoding.
>>
>> Regards,
>> Vikrant
>>
>> -----Original Message-----
>> From: Ahmed Talaat [mailto:[hidden email]]
>> Sent: Friday, June 01, 2007 2:56 PM
>> To: [hidden email]
>> Subject: Setting up (OFBiz + MySQL) with utf8 encoding to support arabic
>>
>> Hi,
>> Can anyone tell me how to set ofbiz with mysql set with utf8 encoding?
>> I followed the instructions from "
>> opentaps-0.9-configuring-for-mysql-screenshots.zip"
>> I created a database with utf8 encoding and edited entityengine.xml to
>> work
>> with it.
>> When running: *ant run-install*. I get the following error:
>>
>> java.sql.SQLException
>>      [java] MESSAGE: Unknown initial character set index '192' received
>> from
>> server. Initial client character set can be forced via the
>> 'characterEncoding' property.
>>
>> I'm using Ubuntu Linux Feisty + MySQL 5.0.38
>>
>> Regards,
>> Ahmed
>>
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.5.472 / Virus Database: 269.8.5/826 - Release Date: 5/31/2007
>> 4:51 PM
>>
>>
>> No virus found in this outgoing message.
>> Checked by AVG Free Edition.
>> Version: 7.5.472 / Virus Database: 269.8.5/826 - Release Date: 5/31/2007
>> 4:51 PM
>>
>>
>

[Krzysztof Podejma]

Hey, this is my configuration for MySQL. It works fine.
You have to set character-set,collate and characterEncoding=UTF-8 in
jdbc-uri
AFAIK changing my.ini is not needed.

    <datasource name="localmysql"
            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
            field-type-name="mysql"
            check-on-start="true"
            add-missing-on-start="true"
            check-pks-on-start="false"
            use-foreign-keys="true"
            join-style="ansi-no-parenthesis"
            alias-view-columns="false"
            drop-fk-use-foreign-key-keyword="true"
            table-type="InnoDB"
            character-set="utf8"
            collate="utf8_general_ci">
        <read-data reader-name="seed"/>
        <read-data reader-name="demo"/>
        <read-data reader-name="ext"/>
        <inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://127.0.0.1/ofbizcp?autoReconnect=true&amp;characterEncoding=UTF-8"
                jdbc-username="ofbiz"
                jdbc-password="password"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi"
jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </datasource>

[Ahmed Talaat]

Hey,
It finally worked.
I changed the collation to utf8_general_ci. And added
default-character-set=utf8 to [client] section of the my.ini
Actually the configuration file was my.cnf not my.ini
Probably the encoding setting in the jdbc uri would have done the same job
Thanks folks for the help
Regards,
Ahmed

Krzysztof Podejma wrote:

> Hey, this is my configuration for MySQL. It works fine.
> You have to set character-set,collate and characterEncoding=UTF-8 in
> jdbc-uri
> AFAIK changing my.ini is not needed.
>
>    <datasource name="localmysql"
>            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>            field-type-name="mysql"
>            check-on-start="true"
>            add-missing-on-start="true"
>            check-pks-on-start="false"
>            use-foreign-keys="true"
>            join-style="ansi-no-parenthesis"
>            alias-view-columns="false"
>            drop-fk-use-foreign-key-keyword="true"
>            table-type="InnoDB"
>            character-set="utf8"
>            collate="utf8_general_ci">
>        <read-data reader-name="seed"/>
>        <read-data reader-name="demo"/>
>        <read-data reader-name="ext"/>
>        <inline-jdbc
>                jdbc-driver="com.mysql.jdbc.Driver"
>
> jdbc-uri="jdbc:mysql://127.0.0.1/ofbizcp?autoReconnect=true&amp;characterEncoding=UTF-8"
>
>                jdbc-username="ofbiz"
>                jdbc-password="password"
>                isolation-level="ReadCommitted"
>                pool-minsize="2"
>                pool-maxsize="250"/>
>        <!-- <jndi-jdbc jndi-server-name="localjndi"
> jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
>    </datasource>
>