You should escape the $, when using $$ iBATIS should skip it. -----Original Message----- From: German Gonzalez [mailto:[EMAIL PROTECTED] Sent: maandag 11 juli 2005 16:25 To: [email protected] Subject: Re: Auto-generated keys using Sybase
I have a similar problem, but with firebird db. I use the following query to get a key from a trigger. SELECT gen_id(GEN_SOLICITUDCERTIFICADO, 1) FROM rdb$database but I get: com.ibatis.common.beans.BeanException: There is no READABLE property named 'database ' in class that it seems ibatis parses "$database" as a property, and the problem is that query is the only way to call that generator. regards, German Gonzalez On 6/14/05, Engel, Gregory A <[EMAIL PROTECTED]> wrote: > I'm using Sybase here and it is the same as MS SQL Server > I do this inside the insert. > > <selectKey resultClass="long" keyProperty="id"> > SELECT @@identity as id > </selectKey> > > Straight from the help files.... > > > > > > > >
