Hi all, I am very newbie to Hibernate. Earlier I was using the simple JDBC and SQL Server 2000. I just installed the Hibernate on my computer and now I am configuring it. Now it says to "copy to JDBC driver to the to global classpath". I just want to know where that Driver is located. Earlier i was using simple string to connect to SQL Server 2000. Its on single machine i am talking about.
I will appreciate if someone can help me in this regard.
The SQLServer driver you used comes in a jar file. It's that jar file that you need to include in your classpath when using Hibernate.
Joined: Jun 07, 2005
Thanks for the reply I really appreciate it. Can you please give me the exact name of thar jar file.
Thanks Manish Jain
Joined: Mar 22, 2005
I have no idea what the file is called (and I haven't used SQLServer in years). But you said that it has worked for you before, so you must have had it somewhere in your classpath. Search through the jar files on your hard disk.
Originally posted by Manish Jain: Hi all, Thanks for help but these jar files are not in my my machine. I checked it although I have SQL Server 2000 installed. Do I have to Install these files from somewhere.
Thanks Manish Jain
Far better would be to use jTDS, since Microsoft's own driver is not supported by Hibernate and has some issues which make it a poor choice.
Originally posted by Ulf Dittmer: Paul Sturrock says:
Could you elaborate a little bit on those issues? I haven't used the MS driver, but a couple years back the jTDS driver was substantially slower than commercial drivers like Weblogic and iNet.
I don't have recent experience with commercial drivers, so I can't say how jTDS compares with any of them. The MS driver is just an old version of a Data Direct driver (its seven versions behind Data Direct's current offering). We found memory leaks in the driver when running stress tests using it. Its licensing also meant you can't package it with your product. Support for it was also very poor, which is perhaps understandable since its not actually a Microsoft product, and Data Direct licensed it to MS as a static product. There are also little configuration gotchas which make it less easy for a novice user to work with than other drivers.
Support for SQL Server 2000 and SQL Server 2005 � Support for JDBC 3.0 � Improved performance � Improved XA transaction support � BLOB and CLOB support � Integrated authentication support � Updateable result sets