MS SQL Server JDBC type 4 driver

[zx44093]

Have anyone used MS SQLserver type 4 JDBC driver from Microsoft in JBoss 2.4? I am getting a class type cast error when launching JBoss with this driver.

[alex_koshterek]

Hi. I tryed this driver with MSDE.
I look into topic "Using MS SQL Server with JBoss" in manual, and configure JBoss. MS driver is licensed MERANT driver.
Jboss can connect to database.
But when I try deploy jar with 2 CMP beans. First bean deployed successefuly, but with second i got message "Can`t clone connection while in manual transaction mode". Full stacktrace I can provide tomorrow.
All beans previosly worked fine on Interbase.

[cyates]

Add the following onto your URL: "selectMethod=cursor" so the full attribute XML tag looks like:

jdbc:microsoft:sqlserver://:;user=;password=;selectMethod=cursor

Cheers

P.S. Anyone know how to specify default database?

[zx44093]

Does this work for JDBC driver from MicroSoft?
To specify the default datasource, change standardjaws.xml file.

[alex_koshterek]

>Add the following onto your URL: "selectMethod=cursor"

Thanks

>P.S. Anyone know how to specify default database?

Of course. Add "database=yourdb" to URL :)