3 Replies Latest reply on Feb 10, 2002 12:20 AM by Balamurugan Raman

    URL setting for connection pooling for named instances MSSQL

    Paramjit S. Sarin Newbie

      Hi,

      I have two instances of MSSQL Server on one box.
      Do you know what the URL setting is for this. Is there a parameter like ServerName alongwith the DatabaseName?
      For one instance of MSSQL it works fine.

      For two instances I get the error:

      jboss.jcml ---->

      SQLServerDBPool2
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:microsoft:sqlserver://192.168.122.131:1433;DatabaseName=master;SelectMethod=cursor
      sa
      password

      ----------------------------------------------------

      ERROR .......>

      [SQLServerDBPool2] XA Connection pool SQLServerDBPool2 bound to java:/SQLServerD
      BPool2
      [XADataSourceLoader] Stopped
      java.lang.NullPointerException
      at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
      e.java:178)
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
      a:407)
      at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107
      )
      at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:28)
      at java.lang.reflect.Method.invoke(Method.java:313)
      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:836)
      at $Proxy0.start(Unknown Source)
      at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:42)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:28)
      at java.lang.reflect.Method.invoke(Method.java:313)
      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: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
      -----------------------------------

      Thanks,
      Param