I'm trying to get JBoss 2.4.4 working with MySQL 3.23
with the mm.mysql-2.0.11 driver:
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=PostgresPool">
<attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">MySQLPool</attribute>
<attribute name="URL">jdb:mysql://mysql1/test</attribute>
<attribute name="JDBCUser">foo</attribute>
<attribute name="Password">bar</attribute>
</mbean>
I get this error:
[ERROR,MySQLPool] Stopped
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at java.lang.reflect.Method.invoke(Native Method)
...
I checked out jboss-all from CVS (branch Rel_2_4_4_15), but can't find
XAPoolDataSource.java so I decompiled it (with jad) and noticed that
it has some log.trace() calls, so I modified the log4j.properties file
and tried to turn on tracing by adding:
log4j.category.org.jboss.pool=TRACE
But that didn't work. So that leaves me with 3 questions:
1) Did anyone get MySQL to work with JBoss CMP?
2) Where do I get the source for XAPoolDataSource
3) How do I turn on tracing?
Thanks very much!
JD