ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abdullah Kauchali" <abdullah.kauch...@isanusi.com>
Subject RE: SQL Server JDBC drivers
Date Thu, 22 Mar 2007 06:40:23 GMT
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 MSDN for details.

Regards,

A


> -----Original Message-----
> From: Niels Beekman [mailto:n.beekman@wis.nl]
> 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 Volkmann'
> Subject: RE: SQL Server JDBC drivers
> 
> Sure:
> 
> <insert id="Example_insert" parameterClass="Example">
>   INSERT INTO example (example_column)
>   VALUES (#exampleColumn#)
>   <selectKey keyProperty="exampleId" resultClass="int">
>     SELECT @@IDENTITY AS ID
>   </selectKey>
> </insert>
> 
> iBATIS will then populate the property "exampleId" with the value of
> the
> auto-incremented column.
> 
> HTH,
> 
> Niels
> 
> -----Original Message-----
> From: Mark Volkmann [mailto:mark@ociweb.com]
> Sent: woensdag 21 maart 2007 20:28
> To: Niels Beekman; Graeme J Sweeney; Rose, Greg
> Cc: Dan Berghoff
> Subject: Re: SQL Server JDBC drivers
> 
> Thanks to the three of you for replying!
> 
> We're having trouble getting iBATIS to work with tables that have an
> integer primary key that is auto-incremented. If you have done that,
> can you send me the relevant snippet of XML from one of your {name}
> _SqlMap.xml files?
> 
> Thanks!
> 
> On Mar 21, 2007, at 11:36 AM, Niels Beekman wrote:
> 
> > 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:mark@ociweb.com]
> > Sent: woensdag 21 maart 2007 17:28
> > 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?


Mime
View raw message