Hi

I changed entries in bpmsds-mysql5-db-plan.xml to,

rg
rg
jdbc:mysql://localhost:3307/process

and deployed using:

C:\IntalioServer\intalio-bpms-5.0.0.064\bin>deploy.bat --offline redeploy ..\rep
ository\tranql\tranql-connector\1.2\tranql-connector-1.2.rar ..\databases\MySQL-
5\bpmsds-mysql5-db-plan.xml

When I start the server I get this error message,

Starting Geronimo Application Server v1.1.1
[*******************> ] 67% 21s Starting ode/ode-war/5.0.6...13:23:16,2
44 ERROR [BpelDAOConnectionFactoryImpl] Unable to detect Hibernate dialect!
[*******************> ] 67% 23s Starting ode/ode-war/5.0.6...13:23:17,9
47 WARN [SettingsFactory] Could not obtain connection metadata
java.sql.SQLException: Access denied for user 'rg'@'localhost' (using password:
YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
at com.mysql.jdbc.Connection.(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:266)
at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDri
verMCF.java:96)
at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCD
riverMCF.java:73)
at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getCo
nnection(MCFConnectionInterceptor.java:41)
at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterc
eptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
at org.apache.geronimo.connector.outbound.SinglePoolConnectionIntercepto

thanks
Karthik

Hi Karthik,

make sure that you have a user in your Mysql DB with those credentials, as the error points that out:

Code: :

java.sql.SQLException: Access denied for user 'rg'@'localhost' (using password: YES)

Hi there,

I'm having a similar problem (see full stacktrace in attached file). Seems like it is complaining about the character encoding. Any idea how this can be fixed? Am I having the wrong encoding in the database or is it a configuration problem of geronimo?

Cheers
Lars

08:48:15,437 DEBUG [org.apache.geronimo.gbean.runtime.GBeanSingleReference] [main] Waiting to start ode/ode-war/5.0.67/war?J2EEApplication=null,WebModule=ode/ode-war/5.0.67/war,j2eeType=Servlet,name=AxisRESTServlet because no targets are running for reference Previous matching the patterns ode/ode-war/5.0.67/war?J2EEApplication=null,WebModule=ode/ode-war/5.0.67/war,j2eeType=Servlet,name=AxisAdminServlet
08:48:16,421 ERROR [org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl] [main] Unable to detect Hibernate dialect!
08:48:17,343 WARN [org.hibernate.cfg.SettingsFactory] [main] Could not obtain connection metadata
java.sql.SQLException: Unknown initial character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)

...
08:48:17,390 ERROR [org.apache.ode.axis2.ODEServer] [main] Error instantiating DAO Connection Factory class org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl.
org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)

Hi,

it appears to be a different problem.

Can you tell us where you installed the server ? What is your OS ? Is it a clean install ?

Thanks,

Antoine

Hi Antoine,

It's a clean install on both, Windows XP SP2 and Ubuntu 7.10 Gutsy. Both installation result in the same error.

thx
lars

P.S: I don't think it has somethind to do with it, but I changed the db parameters in
bpmsds-mysql5-db-plan.xml to use 'intalio' as db name, username and password.

Hi Lars,

you changed your installation to use Mysql then, so this is not a clean install. Please try with the embedded Derby database.

You might have corrupted the persistence layer when changing the connection to the DB.

Thanks,

Antoine