Help: JBoss 2.4.4 and MySQL

[pyung]

I am new to JBoss and trying to get JBoss 2.4.2 and MySql working together. Following is what I did:

1) modify jboss.jcml


org.gjt.mm.mysql.Driver



org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
mySQLDS
jdbc:mysql://localhost/BFG
1200000
bfguser



2) modify standardjaws.xml

java:/mySQLDS
<type-mapping>mySQL</type-mapping>
false

When I run JBoss, I got the following msgs:

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

at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
a:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103
)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
igurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.Main.(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[ERROR,ConfigurationService] Unexpected error
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)

at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
a:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103
)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
igurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.Main.(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)

Does anyone know what the problem is? I would appreciate your help.

-Pyung

[jgremmen]

Take a look at the following thread:

http://main.jboss.org/forums/thread.jsp?forum=46&thread=7827&message=1846984&q=#1846984

Especially the part granting access to localhost connections.