Hi there,

I have to make a test how Hibernate works on different databases. I started with Oracle and the next 2 competitors are MSSQLServer and DB2. With Oracle I worked before so was no problem with the JDBC drivers. With SQLServer I did not work before so now I do not know which driver should I use. Can anyone point me to the best JDBC driver(performance/price) for MSSQLServer?

Thank you,

Florin

Hi,

I also have to make my application work with different RBMS. Thus, I am interested in this issue.

If you, or anybody else, has any relevent information ... please post it !

sylvain_2020

Hi!

I have used hibernate with the Mysql connector jdbc driver and MS SQL with the microsoft JDBC server driver pr in production apps and both have worked perfectly with JBoss managed datasources and dbcp connection pools.

there is a glitch to the MS SQL Microsoft JDBC driver: if you have a column PK of type date the driver seems to round up the date or something, thus giving you potentially inacurrate results.

Otherwise, performance/price I find it hard to beat (specially with todays budgets) ;-)

hi sylvain,

for MSSQL I have downloaded the JDBC driver from MSDN site and it works fine. I had the surprise to see that MS SQL Server is faster than Oracle in some issues, paging for example.

florin

PS: are you testing also OJB?

Actually no ... because Hibernate seems to match my requirements and is said to be much easier and more stable than OJB.

hi all,
Do you know some good JDBC driver for Sybase???

barbar

PS: at this moment I testing JCONNECT5.5 from sybase, but it`s always
return sqlException: native error 2601(duplicate key)
after call session.getBatcher().addToBatch(1);