Hibernate and Sql Server

liushuai · **Joined:** Wed May 12, 2004 2:57 pm **Posts:** 17

Hi all,

I am about to start a new project and am considering using Hibernate with Sql Server 2000. Can someone who has used that combination tell me if it's a good choice?

I know there are glitches with Sql Server and certain JDBC drivers, but I am not sure how well Hibernate performs with Sql Server. Anything I should know?

Thank you all in advance
LS

christian · **Posted:** Wed May 12, 2004 3:11 pm

It's a good combination, use the jTDS driver.

liushuai · **Joined:** Wed May 12, 2004 2:57 pm **Posts:** 17

Thank you.

Just out of curiosity. For best performance on a large scale application, which DB server would you recommend? Say, would Oracle or DB2 work faster/smoother than Sql Server, when being used with Hibernate?

christian · **Posted:** Wed May 12, 2004 3:22 pm

There are too many variables to answer that question. "It depends" is the correct answer :) You will have different problems with all of them, but they are equally well supported by Hibernate.

liushuai · **Joined:** Wed May 12, 2004 2:57 pm **Posts:** 17

christian wrote:

There are too many variables to answer that question. "It depends" is the correct answer :) You will have different problems with all of them, but they are equally well supported by Hibernate.

That's all I wanted to know. :) Thanks again.

liushuai · **Joined:** Wed May 12, 2004 2:57 pm **Posts:** 17

christian wrote:

It's a good combination, use the jTDS driver.

Hi,

I just found this in hibernate.properties file
## jTDS (not supported!)
#hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver
#hibernate.connection.url jdbc:jtds:sqlserver://1E1/test;SelectMethod=cursor
#hibernate.jdbc.use_scrollable_resultset false

Doesn't it mean that Hibernate does not work with jTDS driver? (Unless it's just added to Hibernate 2.1.3? The version I have is 2.1.2. )

christian · **Posted:** Wed May 12, 2004 3:42 pm

This might not be accurate anymore. There was a time when jTDS was in its early stages and had several missing features. I think we may now remove that warning. I don't have MS SQL server (Gavin is the DB2/MS SQL guy), so I can't verify the current state. However, we had only good reports about it on the forum. If anyone can run the unit tests with it, I'll remove the warning.

liushuai · **Joined:** Wed May 12, 2004 2:57 pm **Posts:** 17

OK, and thanks again.

FYI, here is a statement I quoted from jTDS's homepage:

"jTDS is also becoming a common choice for enterprise-level applications: starting with release 0.8-rc1 jTDS passes the Hibernate test suite, making it the driver of choice for SQL Server."

michael · **Posted:** Wed May 12, 2004 4:43 pm

I'd really recommend the jDTS driver, the developers are also quite interested in Hibernate compatibility, so you can be quite sure that all possible incompatibilities from the driver side are fixed quickly.

decairn · **Joined:** Tue Feb 10, 2004 2:30 pm **Posts:** 25

JNetDirect driver works well too, is not free though.

http://www.jnetdirect.com

david · **Posted:** Thu May 13, 2004 9:09 pm

I have been using the jTDS driver for MIddlegen and HIbernate usage and I am currently happy with it.