Where do I get the MySQL Driver for JBoss?

[sammy]

Hi folks

I want to connect my JBoss 2.4.4 Server to a MySQL Database. I looked in the online manual and in the forums, but I just found explanations how to get along with JBoss 3 in this case. Based on some code examples in other topics, I modified my jboss.jmcl like that:


org.gjt.mm.mysql.Driver



org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
mysqldb
jdbc:mysql://localhost/jboss_db
jboss
jboss


Now when I start JBoss, i get an error message:

...
[INFO,JdbcProvider] Starting
[INFO,JdbcProvider] Started
[INFO,mysqldb] Starting
[INFO,mysqldb] XA Connection pool mysqldb bound to java:/mysqldb
[ERROR,mysqldb] Stopped
java.lang.NullPointerException
at org.jboss.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)

I don't know why this error occurs. Do I have to download the jdbc driver and install it somewhere in the file system? Or is there another problem?

[davidjencks]

Yes, jboss only comes with Hypersonic. For any other db you need to get the appropriate driver and put it in <jboss directory>/lib/ext

[jbossobj]

You can find the drivers here:
http://www.mysql.com/downloads/api-jdbc.html

[sammy]

heyyy thank you very much! it works! :)