Interesting.. Does this cause an error like "can reread from column 3 in row.."? I may have just stumbled across that.. So outer joins are out for MSSQL?
I will try and catalog all these gotchas, and maybe add unit tests to prove them... Eric Pugh -----Original Message----- From: Morten Wilken [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 1:37 AM To: [EMAIL PROTECTED] Subject: Re: [Hibernate] Recommended JDBC drivers for MS SQL? Hi eric, The MSSQLServer driver has a bug where you cannot select the same field twice in one select statement ie you cant do this: select a,a from table you will then get an error on accessing the 2nd a. this causes problems for hibernate when you do joins (but you can disable outer joins to get it working) this is the only problem i have seen with the driver, and i am using it for a pet project with hibernate. As my project is only for fun, i haven't done extensive testing. sincerely morten wilken ----- Original Message ----- From: "Eric Pugh" <[EMAIL PROTECTED]> To: "'Timothy Kettering'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 07, 2003 4:04 PM Subject: RE: [Hibernate] Recommended JDBC drivers for MS SQL? > I'm curious what errors people have had with MS SQL... I briefly ran the > unit tests against SQL server, sure a bunch failed, but despite that, I have > been able to use MS SQL Server JDBC Driver very successfully on a couple of > projects.... > > I was thinking of digging into the unit tests to see what issues there are, > but it would help if I could hear from other people what issues the've > had... > > Eric Pugh > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Timothy > Kettering > Sent: Thursday, August 07, 2003 3:13 PM > To: [EMAIL PROTECTED] > Subject: [Hibernate] Recommended JDBC drivers for MS SQL? > > > > Hi everyone, > > I've always done development with Hibernate w/ MySQL, but this new > contract I just received, they're requesting to have the database on a > MS SQL server. I checked the hibernate site, and the only thing it > says is NOT to use the Microsoft provided JDBC driver. > > So I'm asking for a bit more information.. is the afforementioned still > true? Do any of you have positive experiences with a specific > commercial JDBC driver that would be recommended for use with MS SQL? > The client is willing to pay, but I don't want to make them pay any > more money than they have to. Thanks. > > -tim > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 > _______________________________________________ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 > _______________________________________________ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
