-
1. Re: MS SQL Server JDBC type 4 driver
alex_koshterek Dec 3, 2001 3:43 AM (in response to zx44093)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. -
2. Re: MS SQL Server JDBC type 4 driver
cyates Dec 3, 2001 5:01 AM (in response to zx44093)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? -
3. Re: MS SQL Server JDBC type 4 driver
zx44093 Dec 3, 2001 3:06 PM (in response to zx44093)Does this work for JDBC driver from MicroSoft?
To specify the default datasource, change standardjaws.xml file. -
4. Re: MS SQL Server JDBC type 4 driver
alex_koshterek Dec 4, 2001 5:41 AM (in response to zx44093)>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 :)