I was having the same problem and also switched to jtds, but the problem remains.
My connection is failing randomly with "Apparently wrong driver class specified for
URL" error.
The connection will fail this way over and over again, then will randomly begin to work.
It's maddening! Is anyone else experiencing this?
I am running JBoss on Java 1.506, conncting to MSSQL with jtds 1.2 with the folloding
datasource specifier:
<local-tx-datasource>
<jndi-name>MSSQLDS</jndi-name>
<connection-url>jdbc:jtds:sqlserver://192.168.100.100:1433/CADB;tds=8.0;lastupdatecount=true</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<user-name>username</user-name>
pwd
<!--
sql to call on an existing pooled connection when it is obtained from pool
-->
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
</local-tx-datasource>
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3975917#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...