Try setting your minimum pool size to 1. Had this same problem, only with oracle drivers.
In the xadatasourceloader mbean:
<attribute name="MinSize">1</attribute>
j\s
-----Original Message-----
From: Keith Elliott [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 8:38 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] MySQL Pool Error: XA Connection...
NullPointerException
Hi Folks,
We're using RHL 7.1, MySQL, Jboss 2.2.2/Tomcat 3.2.2 combo. We get the
following error when starting jboss:
...
[JAAS Security Manager] Started
[JDBC provider] Starting
[JDBC provider] Started
[mysqlPool] Starting
[mysqlPool] XA Connection pool mysqlPool bound to java:/mysqlPool
[mysqlPool] Stopped
[mysqlPool] java.lang.NullPointerException
[mysqlPool] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:165)
[mysqlPool] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)
[mysqlPool] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[mysqlPool] at java.lang.reflect.Method.invoke(Native Method)
[mysqlPool] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[mysqlPool] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[mysqlPool] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[mysqlPool] at java.lang.reflect.Method.invoke(Native Method)
[mysqlPool] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[mysqlPool] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[mysqlPool] at org.jboss.Main.<init>(Main.java:217)
[mysqlPool] at org.jboss.Main$1.run(Main.java:121)
[mysqlPool] at java.security.AccessController.doPrivileged(Native
Method)
[mysqlPool] at org.jboss.Main.main(Main.java:117)
[Service Control] Could not start
DefaultDomain:service=XADataSource,name=mysqlDB
[Service Control] java.lang.NullPointerException
[Service Control] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:165)
[Service Control] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)
[Service Control] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Service Control] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Service Control] at org.jboss.Main.<init>(Main.java:217)
[Service Control] at org.jboss.Main$1.run(Main.java:121)
[Service Control] at java.security.AccessController.doPrivileged(Native
Method)
[Service Control] at org.jboss.Main.main(Main.java:117)
[Container factory] Starting
[Container factory] Started
[EmbeddedTomcatSX] Starting
...
Here's the relevant part of the jboss.jcml file...
<!-- JDBC -->
<!--
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver</attribute>
</mbean>
-->
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.gjt.mm.mysql.Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=mysqlDB">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">mysqlPool</attribute>
<attribute name="URL">jdbc:mysql://localhost/application</attribute>
<attribute name="JDBCUser">username</attribute>
<attribute name="Password">password</attribute>
</mbean>
Strangely enough, if we change localhost to another machine name in our
internal network that is setup with MySQL in a similar fashion, it
works. We've tried changing the URL line to..
<attribute name="URL">jdbc:mysql:/localhost/application</attribute>
and also,
<attribute name="URL">jdbc:mysql:@localhost/application</attribute>
but that does not work. MySQL is running and setup fine. We've setup
prior versions, and have not had this problem.
I've seen one other message on this list with a similar problem, but no
resolution.
Any ideas?
Muchas Gracias Amigos,
Keith Elliott
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
