aspose file tools
The moose likes JDBC and Relational Databases and the fly likes JDBC drivers for MS SQL 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC drivers for MS SQL 2000" Watch "JDBC drivers for MS SQL 2000" New topic
Author

JDBC drivers for MS SQL 2000

Kalpesh Soni
Ranch Hand

Joined: Jan 02, 2001
Posts: 312
any one tried any drivers for ms sql 2k ?
currently i am using one by microsoft
it is not too slow but has some problems
e.g. from a same connection object if i try to create multiple statements, and use transactions I get an error while connection.setAutocommit(false)
I also want to see whether other drivers are fast/better
the sun jdbc site has listed 40 drivers for ms sql
some of them are j2ee 1.2/1/3 certified
I want to know if someone has had any experience about any particular of them
Kalps
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302
    
    6

You probably get that error because that feature is not allowed in MS's version of the Driver.
Originally posted by Kalpesh Soni:
the sun jdbc site has listed 40 drivers for ms sql
some of them are j2ee 1.2/1/3 certified
Kalps

Where did you find that list? Can you give me a link.


GenRocket - Experts at Building Test Data
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
I too got the same error
precisely:
[java] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
Had anyone able to solve this problem ??


Spritle Software Blogs
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
I just solved the problem by adding selectmethod as suffix, please see here for more info http://www.websina.com/bugzero/faq/exception-sql2000.html
Now i can make connection pooling with sqlserver 2000 with Microsoft jdbc driver.
Originally posted by Kalpesh Soni:
any one tried any drivers for ms sql 2k ?
currently i am using one by microsoft
it is not too slow but has some problems
e.g. from a same connection object if i try to create multiple statements, and use transactions I get an error while connection.setAutocommit(false)
I also want to see whether other drivers are fast/better
the sun jdbc site has listed 40 drivers for ms sql
some of them are j2ee 1.2/1/3 certified
I want to know if someone has had any experience about any particular of them
Kalps
Kalpesh Soni
Ranch Hand

Joined: Jan 02, 2001
Posts: 312
I just solved the problem by adding selectmethod as suffix, please see here for more info http://www.websina.com/bugzero/faq/exception-sql2000.html
Now i can make connection pooling with sqlserver 2000 with Microsoft jdbc driver.

SelectMethod=cursor is very expensive
what it does is, it dumps all inserts/updates within a transaction in tempdb and then updates your db when transaction is committed at one go
our application is big and our tempdb grows to 1-2 GB!
so in short , do not use it !
work around ?! use different connections
Gregg the link is
http://industry.java.sun.com/products/jdbc/drivers
using it u can search for drivers
No one answered my first question though
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302
    
    6

Thanks for the link. That is a good resource.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC drivers for MS SQL 2000