Hi, I would like to readdress my question and make it much clearer. I
searched both on the Forums and mailing list, as if I did everything
right. But I still get error, when I tried to use MySQL. I do appreciate
any suggestion!
According to the JBoss manual - Configuring JDBC, I downloaded MySQL
JDBC driver both version 2.0.6.1. (i didn't find version 2.0.6 suggested
by the manual, i tried version 2.0.11 as well) and copy it to
Jboss\lib\ext\. And I did changes on
Jboss2.4.4_Tomcat4.0.1\conf\catalina\jboss.jcml:
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.hsqldb.jdbcDriver,
org.gjt.mm.mysql.Driver
</attribute>
</mbean>
Add one more mbean:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=MySQLDS">
<attribute name="PoolName">MySQLDS</attribute>
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="URL">jdbc:mysql://localhost:3306/test</attribute>
<attribute name="JDBCUser">root</attribute>
<attribute name="MaxSize">5</attribute>
<attribute name="Password" />
<attribute name="MinSize">0</attribute>
</mbean>
The error I am getting is : (the DefaultDS is Hypersonic)
[INFO,DefaultDS] Starting
[INFO,DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[INFO,DefaultDS] 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.<init>(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)
--
Jia (Christine) Li
524N ICT Building
Department of Computer Science
University of Calgary
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
