Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

which is more faster for sql2k server?

 
nan li
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sun.jdbc.odbc.JdbcOdbcDriver and com.microsoft.jdbc.sqlserver.SQLServerDrive
which is more faster for sql2k server?
 
eammon bannon
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thx for all.
I downloaded jtds-0.8-rc1.jar jtds-0.8-rc1-src.zip .
NOw I'm testing it...
thx again.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic