Mysql 5.1 datasource problems
captrespect Apr 6, 2004 10:49 AMWe are trying to migrate our sql server database to mysql 5. I can't seem to get a datasource from the mysql 5 connection in my servlets. I can connect to the database by not using dbcp and using the connection string and I can get a datasource from MS Sql Server. Has anyone been about to do this or is it a problem with mysql 5 alpha?
using Jboss 3.2.3, suse 9, mysql 5.0.0
tried with connect/j 3.0.11 and connect/j 3.1.1-alpha
Here's what I got:
web.xml:
<resource-ref> <res-ref-name>MySqlTest</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
jboss-web.xml:
<jboss-web> <resource-ref> <res-ref-name>MySqlTest</res-ref-name> <jndi-name>java:/MySqlTest</jndi-name> </resource-ref> </jboss-web>
-ds.xml:
<datasources> <local-tx-datasource> <jndi-name>MySqlTest</jndi-name> <connection-url>jdbc:mysql://localhost:3306/TestDB</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>test</user-name> <password>test</password> <min-pool-size>20</min-pool-size> <max-pool-size>300</max-pool-size> <idle-timeout-millis>10000</idle-timeout-millis> </local-tx-datasource> </datasources>
failing servlet code:
Context init = new InitialContext(); Context ctx = (Context) init.lookup("java:comp/env"); ds = (DataSource) ctx.lookup("MySqlTest"); con = ds.getConnection(); //throws exception here
and finally the exception:
11:26:08,315 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:213) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102) at test.DBConnection_Beta.setConnection(DBConnection_Beta.java:77)
Thanks,