Try this instead: SELECT @@IDENTITY AS value
-Richard -----Original Message----- From: Richard Yee [mailto:[EMAIL PROTECTED] Sent: Monday, May 28, 2007 8:25 AM To: [email protected] Subject: Re: selectkey in sybase Emiliano, I think one of the problems is this: |@@identity I believe it should be @@identity@@ -Richard |Emiliano Armellin wrote: > Hello, > > I'm trying the selectkey statement in sybase, using abator generated > map but I've got this error: > > |org.springframework.jdbc.UncategorizedSQLException: SqlMapClient > operation; uncategorized SQLException for SQL []; SQL state [JZ0TE]; > error code [0]; > --- The error occurred in > com/ateikon/internet/eprogen/dao/ibatis/maps/pgmr/pgmr_atk_request_SqlMa p.xml. > > --- The error occurred while applying a result map. > --- Check the > pgmr_atk_request.abatorgenerated_insert-SelectKey-AutoResultMap. > --- Check the result mapping for the '@@identity' property. > --- Cause: java.sql.SQLException: JZ0TE: Attempted conversion between > an illegal pair of types. Valid database datatypes are: 'tinyint, > smallint, int, bit, float, decimal, numeric, char, unichar, varchar, > univarchar, text, unitext, money, short money, unsigned bigint'; > nested exception is > com.ibatis.common.jdbc.exception.NestedSQLException: | > > > the generated insert: > > | <insert id="abatorgenerated_insert" > parameterClass="com.ateikon.internet.eprogen.domain.pgmr.Atk_request"> > insert into pgmr.atk_request (emaildest, cdazie, cddipa, profil, > dtinse, dtulag) > values (#emaildest:VARCHAR#, #cdazie:VARCHAR#, #cddipa:VARCHAR#, > #profil:VARCHAR#, > #dtinse:TIMESTAMP#, #dtulag:TIMESTAMP#) > <selectKey keyProperty="tkreq" resultClass="java.lang.Long"> > select @@identity > </selectKey> > </insert> > > > | > it seems correct... so why thi error? I can't set selectkey result map... > > thanks > > -- > Emiliano Armellin > > * > W_ > www.ateikon.com <http://www.ateikon.com> > * > @_ > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > * > T_ > *+39 0422 452101* > > Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=15653&t=86> > Get Thunderbird <http://www.mozilla.org/products/thunderbird/>
