File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes which is more faster for sql2k server? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "which is more faster for sql2k server?" Watch "which is more faster for sql2k server?" New topic
Author

which is more faster for sql2k server?

nan li
Greenhorn

Joined: Nov 11, 2003
Posts: 16
sun.jdbc.odbc.JdbcOdbcDriver and com.microsoft.jdbc.sqlserver.SQLServerDrive
which is more faster for sql2k server?


SCJP1.4 scwcd1.3
eammon bannon
Ranch Hand

Joined: Mar 16, 2004
Posts: 140
com.microsoft.jdbc.sqlserver.SQLServerDrive seems to suffer from memory leaks, I would not use it for a production system. Sun recommend you use a pure Java driver rather than a bridge - there's a chance the VM will be messed up by the native code brought in by the driver. Again, because of this I would not use it in a production system. You might want try jTDS (seach sourceforge), which is free and despite only being at version 0.7.1 is much better than the MS driver. If you need a proper production ready driver for MSSQL Server though, I'm afraid you'll probably have to buy something.
Rudy Dakota
Ranch Hand

Joined: Jul 27, 2002
Posts: 54
Hi Nan,
Stands to reason the specialized SQL Server driver will be faster. After all there is only one translation step: JDBC <--> TDS protocol, whereas the JDBC-ODBC bridge entail two steps: JDBC <--> ODBC <--> TDS. I never tried though.
I agree with Aemmon for the rest: better not use either driver for serious work. I personally have good experiences with Inet software's Opta2000 driver for SQL Server.
Good riding,
Rudy.
nan li
Greenhorn

Joined: Nov 11, 2003
Posts: 16
thx for all.
I downloaded jtds-0.8-rc1.jar jtds-0.8-rc1-src.zip .
NOw I'm testing it...
thx again.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: which is more faster for sql2k server?