RE: [JBoss-user] JBoss CMP with MySQL?

[Joost v.d. Wijgerd]

Title: JBoss CMP with MySQL?

Look at you URL attribute, you are missing a 'c'

 

NullPointer on getConnection is always a config problem

 

Joost.

-----Original Message-----
From: JD Brennan [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 1:55 AM
To: JBoss Users (E-mail)
Subject: [JBoss-user] JBoss CMP with MySQL?

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