I am changing from the weblogic driver for MS Sql server 7.0 to the Microsoft driver for MS Sql 2000. I have checked the usual cause of a "no suitable driver" exception, the class path, and verified that it is finding msbase.jar, mssqlserver.jar, and msutil.jar.
I have tried every thing posted so far, but I am still getting the following problem:
[INFO,MSSqlDS] Starting
[INFO,MSSqlDS] java.sql.SQLException: No suitable driver
[INFO,MSSqlDS] at java.sql.DriverManager.getConnection(Unknown Source)
[INFO,MSSqlDS] at java.sql.DriverManager.getConnection(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown Sourc
e)
[INFO,MSSqlDS] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown Sourc
e)
[INFO,MSSqlDS] at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.ObjectPool.createNewObject(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.ObjectPool.initialize(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.jdbc.xa.XAPoolDataSource.initialize(Unknown Source)
[INFO,MSSqlDS] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:403)
[INFO,MSSqlDS] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
[INFO,MSSqlDS] at java.lang.reflect.Method.invoke(Native Method)
[INFO,MSSqlDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[INFO,MSSqlDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[INFO,MSSqlDS] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Configuratio
nService.java:967)
[INFO,MSSqlDS] at $Proxy0.start(Unknown Source)
[INFO,MSSqlDS] at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
[INFO,MSSqlDS] at java.lang.reflect.Method.invoke(Native Method)
[INFO,MSSqlDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[INFO,MSSqlDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[INFO,MSSqlDS] at org.jboss.Main.(Main.java:208)
[INFO,MSSqlDS] at org.jboss.Main$1.run(Main.java:110)
[INFO,MSSqlDS] at java.security.AccessController.doPrivileged(Native Method)
[INFO,MSSqlDS] at org.jboss.Main.main(Main.java:106)
[INFO,MSSqlDS] XA Connection pool MSSqlDS bound to java:/MSSqlDS
[INFO,MSSqlDS] java.sql.SQLException: No suitable driver
[INFO,MSSqlDS] at java.sql.DriverManager.getConnection(Unknown Source)
[INFO,MSSqlDS] at java.sql.DriverManager.getConnection(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown Sourc
e)
[INFO,MSSqlDS] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown Sourc
e)
[INFO,MSSqlDS] at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.ObjectPool.createNewObject(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.ObjectPool.getObject(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.ObjectPool.getObject(Unknown Source)
[INFO,MSSqlDS] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
[INFO,MSSqlDS] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
[INFO,MSSqlDS] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
[INFO,MSSqlDS] at java.lang.reflect.Method.invoke(Native Method)
[INFO,MSSqlDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[INFO,MSSqlDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[INFO,MSSqlDS] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Configuratio
nService.java:967)
[INFO,MSSqlDS] at $Proxy0.start(Unknown Source)
[INFO,MSSqlDS] at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
[INFO,MSSqlDS] at java.lang.reflect.Method.invoke(Native Method)
[INFO,MSSqlDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[INFO,MSSqlDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[INFO,MSSqlDS] at org.jboss.Main.(Main.java:208)
[INFO,MSSqlDS] at org.jboss.Main$1.run(Main.java:110)
[INFO,MSSqlDS] at java.security.AccessController.doPrivileged(Native Method)
[INFO,MSSqlDS] at org.jboss.Main.main(Main.java:106)
[ERROR,MSSqlDS] Stopped
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java: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:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService
.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:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(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)
[ERROR,ConfigurationService] Unexpected error
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java: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:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService
.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:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(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)
Here is my config:
MSSqlDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:microsoft:sqlserver//:192.168.0.2:1433;SelectMethod=cursor;DatabaseName=xxx
xx
xx
true
1
2