RE: SQL Server JDBC drivers

2007-03-27 Thread Niels Beekman
o: user-java@ibatis.apache.org Subject: Re: SQL Server JDBC drivers On Mar 22, 2007, at 1:40 AM, Abdullah Kauchali wrote: Avoid using @@Identity and instead use Scope_Identity(). Here is a blogg that summarises the point: http://cf-bill.blogspot.com/2005/08/identity-scopeidentity-id

Re: SQL Server JDBC drivers

2007-03-27 Thread Mark Volkmann
s Beekman Sent: woensdag 21 maart 2007 20:33 To: 'Mark Volkmann' Subject: RE: SQL Server JDBC drivers Sure: INSERT INTO example (example_column) VALUES (#exampleColumn#) SELECT @@IDENTITY AS ID iBATIS will then populate the property "exampleId" with the value of

Re: SQL Server JDBC drivers

2007-03-22 Thread Ted Schrader
concurrency issue so you'll be fine if you don't use triggers. Thanks for the heads up, Niels -Original Message- From: Abdullah Kauchali [mailto:[EMAIL PROTECTED] Sent: donderdag 22 maart 2007 7:40 To: user-java@ibatis.apache.org Subject: RE: SQL Server JDBC drivers Avoid u

RE: SQL Server JDBC drivers

2007-03-21 Thread Niels Beekman
t: donderdag 22 maart 2007 7:40 To: user-java@ibatis.apache.org Subject: RE: SQL Server JDBC drivers Avoid using @@Identity and instead use Scope_Identity(). Here is a blogg that summarises the point: http://cf-bill.blogspot.com/2005/08/identity-scopeidentity-identcurrent. html Has links to M

RE: SQL Server JDBC drivers

2007-03-21 Thread Abdullah Kauchali
of > the > auto-incremented column. > > HTH, > > Niels > > -Original Message- > From: Mark Volkmann [mailto:[EMAIL PROTECTED] > Sent: woensdag 21 maart 2007 20:28 > To: Niels Beekman; Graeme J Sweeney; Rose, Greg > Cc: Dan Berghoff > Subject: Re: S

RE: SQL Server JDBC drivers

2007-03-21 Thread Rose, Greg
I have been using jTDS for the past 2 years with SQL Server 2005. Greg Rose Sr. Java Developer/Team Lead| ICE Project 9002 San Marco Ct. Orlando, FL 32819 Office > 407.903.4757 | Fax > 407.903.4856 [EMAIL PROTECTED] -Original Message- From: Mark Volkmann [mailto:[EMAIL PROTECTED]

RE: SQL Server JDBC drivers

2007-03-21 Thread Graeme J Sweeney
On Wed, 21 Mar 2007, Niels Beekman wrote: We use jTDS (http://jtds.sf.net) for several years now, it has excellent performance and any bugs (which are very rare) are dealt with promptly. +1 -- Graeme -

RE: SQL Server JDBC drivers

2007-03-21 Thread Niels Beekman
Hi, We use jTDS (http://jtds.sf.net) for several years now, it has excellent performance and any bugs (which are very rare) are dealt with promptly. Niels -Original Message- From: Mark Volkmann [mailto:[EMAIL PROTECTED] Sent: woensdag 21 maart 2007 17:28 To: user-java@ibatis.apache.org