NullPointerException creating datasource with weblogic SQLSe
Hi,
I am having problems trying to set up a connection pool to a SQLServer database using weblogic's sqlserver JDBC driver.
The driver is successfully loaded, but an error occurs on trying to establish a connection.
I get the following output...
...
[SQLServerpool] XA Connection pool SQLServerpool bound to java:/SQLServerpool
[XADataSourceLoader] Stopped
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:178)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(Main.java:221)
at org.jboss.Main$1.run(Main.java:127)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:123)
[Configuration] java.lang.NullPointerException
[Configuration] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:178)
[Configuration] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407)
[Configuration] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
[Configuration] at $Proxy0.start(Unknown Source)
[Configuration] at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Configuration] at org.jboss.Main.(Main.java:221)
[Configuration] at org.jboss.Main$1.run(Main.java:127)
[Configuration] at java.security.AccessController.doPrivileged(Native Method)
[Configuration] at org.jboss.Main.main(Main.java:123)
...
I'm sure its due to my configuration, and I've tried the tweaks that have been suggested in this forum by other people with similar problems, but I just can't get the right combination to solve the problem.
Here's the relevant bit of my jboss.jcml:
...
<!-- ==================================================================== -->
<!-- JDBC -->
<!-- ==================================================================== -->
org.hsqldb.jdbcDriver,com.internetcds.jdbc.tds.Driver,weblogic.jdbc.mssqlserver4.Driver
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
SQLServerpool
jdbc:weblogic:mssqlserver4:databasename@servername
user=username; password=xxxx; ServerName=servername; database=databasename
true
false
false
false
120000
1800000
false
false
1.0
0
Can anyone spot the problem or make any suggestions?
Thanks!