MySql for 3.0

[garbuzov]

In 2.x I connected MySQL default datasource modyfying jboss.jcml. How to do it in 3.0 (that file is not there)?

[foglesa]

posted here:

http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/

[jbsabmello]

Hi,
I tried this link, but does not work. Do you know about another one.
Thanks,
John Mello
http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/

[davidjencks]

Read ch 3 of the online manual.

[pokey]

Chapter 3 seems to be aimed at people already familiar with JBoss 3.0 config. It gives links to the latest config stuff that's in CVS, but it doesn't say where to put it.

[davidjencks]

put the *-service.xml config files in deploy.

[yanor]

hi,

i've been using 3.0 with cloudscape and just installed
mysql for evaluation. i was able to deploy the mysql
driver but when i tried to deploy the beans, i got the
following error:

21:11:37,458 ERROR [testDB] Unable to create ManagedConnection:
javax.resource.ResourceException: Unable to create DB connection for url: jdbc:m
ysql://localhost:3306/topo, user: , exception: java.sql.SQLException: Cannot dis
able AUTO_COMMIT
at org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectionFactory.cr
eateManagedConnection(JDBCManagedConnectionFactory.java:392)
at org.jboss.resource.connectionmanager.ManagedConnectionPoolFactory.cre
ateObject(ManagedConnectionPoolFactory.java:97)
at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1013)
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:672)
at org.jboss.resource.connectionmanager.SharedLocalConnectionManager.all
ocateConnection(SharedLocalConnectionManager.java:124)
at org.jboss.resource.adapter.jdbc.JDBCDataSource.getConnection(JDBCData
Source.java:110)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.tableExists(JDBCStart
Command.java:188)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStart
Command.java:133)

[yanor]

sorry... bad driver. it works now.