0 Replies Latest reply on Oct 26, 2001 5:35 AM by Heather Liew

    NullPointerException creating datasource with weblogic SQLSe

    Heather Liew Newbie


      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!