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
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
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
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
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
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]
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 -
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