ArjunaTS and MySQL (Phorum)
marklittle Mar 14, 2006 7:53 AMAuthor: Anton
Date: 09-21-04 10:36
I want to use Arjuna with a MySQL database (Version 4.0.20a).
As a first step, I tried to make the sample banking application persistent. Therefore I changed the JNDI-Properties in com.arjuna.demo.jta.jdbcbank.BankClient and left com.arjuna.demo.jta.jdbcbank.Bank unchanged.
I already tried different drivers, but I can't get a connection with any of them. With mm.mysql-2.0.13-bin.jar I get the following error:
java.lang.ClassCastException: javax.naming.Reference
at com.arjuna.ats.internal.jdbc.IndirectRecoverableConnection.createDataSource(IndirectRecoverableConnection.java:417)
at com.arjuna.ats.internal.jdbc.IndirectRecoverableConnection.(IndirectRecoverableConnection.java:116)
at com.arjuna.ats.internal.jdbc.ConnectionImple.(ConnectionImple.java:80)
at com.arjuna.ats.internal.jdbc.ConnectionManager.create(ConnectionManager.java:90)
at com.arjuna.ats.jdbc.TransactionalDriver.connect(TransactionalDriver.java:73)
at com.arjuna.demo.jta.jdbcbank.Bank.create_table(Unknown Source)
at com.arjuna.demo.jta.jdbcbank.Bank.(Unknown Source)
at com.arjuna.demo.jta.jdbcbank.BankClient.main(Unknown Source)
java.sql.SQLException: java.lang.ClassCastException: javax.naming.Reference
at com.arjuna.ats.internal.jdbc.IndirectRecoverableConnection.createDataSource(IndirectRecoverableConnection.java:434)
at com.arjuna.ats.internal.jdbc.IndirectRecoverableConnection.(IndirectRecoverableConnection.java:116)
at com.arjuna.ats.internal.jdbc.ConnectionImple.(ConnectionImple.java:80)
at com.arjuna.ats.internal.jdbc.ConnectionManager.create(ConnectionManager.java:90)
at com.arjuna.ats.jdbc.TransactionalDriver.connect(TransactionalDriver.java:73)
at com.arjuna.demo.jta.jdbcbank.Bank.create_table(Unknown Source)
at com.arjuna.demo.jta.jdbcbank.Bank.(Unknown Source)
at com.arjuna.demo.jta.jdbcbank.BankClient.main(Unknown Source)
With xapool-1.4.jar (xapool.expertlog.com) it looks like this:
java.sql.SQLException: Error trying to load driver: :
at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:184)
at org.enhydra.jdbc.standard.StandardPooledConnection.(StandardPooledConnection.java:65)
at org.enhydra.jdbc.standard.StandardXAConnection.(StandardXAConnection.java:81)
at org.enhydra.jdbc.standard.StandardXADataSource.getXAConnection(StandardXADataSource.java:109)
at com.arjuna.ats.internal.jdbc.IndirectRecoverableConnection.createConnection(IndirectRecoverableConnection.java:448)
at com.arjuna.ats.internal.jdbc.IndirectRecoverableConnection.getConnection(IndirectRecoverableConnection.java:305)
at com.arjuna.ats.internal.jdbc.ConnectionImple.getConnection(ConnectionImple.java:557)
at com.arjuna.ats.internal.jdbc.ConnectionImple.registerDatabase(ConnectionImple.java:641)
at com.arjuna.ats.internal.jdbc.ConnectionImple.createStatement(ConnectionImple.java:141)
at com.arjuna.demo.jta.jdbcbank.Bank.create_table(Unknown Source)
at com.arjuna.demo.jta.jdbcbank.Bank.(Unknown Source)
at com.arjuna.demo.jta.jdbcbank.BankClient.main(Unknown Source)
java.sql.SQLException: java.sql.SQLException: Error trying to load driver: :
at com.arjuna.ats.internal.jdbc.IndirectRecoverableConnection.getConnection(IndirectRecoverableConnection.java:327)
at com.arjuna.ats.internal.jdbc.ConnectionImple.getConnection(ConnectionImple.java:557)
at com.arjuna.ats.internal.jdbc.ConnectionImple.registerDatabase(ConnectionImple.java:641)
at com.arjuna.ats.internal.jdbc.ConnectionImple.createStatement(ConnectionImple.java:141)
at com.arjuna.demo.jta.jdbcbank.Bank.create_table(Unknown Source)
at com.arjuna.demo.jta.jdbcbank.Bank.(Unknown Source)
at com.arjuna.demo.jta.jdbcbank.BankClient.main(Unknown Source)
I also tried gweMysql.jar (http://www.javareading.com/jdbc/) without success.
Does anyone know, which driver works with MySQL and ArjunaTS? If it is not the driver, what else could I have made wrong?
Thanks,
Anton