subject:"SQL Server JDBC drivers"

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

ps something I'm doing wrong defining the table? -Original Message- From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 10:19 PM To: user-java@ibatis.apache.org Subject: FW: SQL Server JDBC drivers And for the archives... -Original Message- From: Niel

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

[EMAIL PROTECTED] > Sent: Wednesday, March 21, 2007 10:19 PM > To: user-java@ibatis.apache.org > Subject: FW: SQL Server JDBC drivers > > And for the archives... > > -Original Message- > From: Niels Beekman > Sent: woensdag 21 maart 2007 20:33 > To: 'Mark

FW: SQL Server JDBC drivers

2007-03-21 Thread Niels Beekman

And for the archives... -Original Message- From: Niels 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

RE: SQL Server JDBC drivers

2007-03-21 Thread Rose, Greg

TECTED] Sent: Wednesday, March 21, 2007 12:28 PM To: user-java@ibatis.apache.org Subject: SQL Server JDBC drivers If you have successfully used iBATIS with SQL Server, can you tell me what JDBC driver(s) have worked for you? This electronic message transmission contains information from the C

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 -