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.
Add the following onto your URL: "selectMethod=cursor" so the full attribute XML tag looks like:
P.S. Anyone know how to specify default database?
Does this work for JDBC driver from MicroSoft?
To specify the default datasource, change standardjaws.xml file.
>Add the following onto your URL: "selectMethod=cursor"
>P.S. Anyone know how to specify default database?
Of course. Add "database=yourdb" to URL :)