great, thanks to all for your help. it worked with double $ !!! SELECT gen_id(GEN_SOLICITUDCERTIFICADO, 1) FROM rdb$$database
cheers, German On 7/11/05, Akins, Greg <[EMAIL PROTECTED]> wrote: > Looks like Ibatis missed the trailing '$' on the property as well. > Should it through an error when parsing the sql.xml file if the '$' is > unmatched? > > -----Original Message----- > From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED] > Sent: Monday, July 11, 2005 10:29 AM > To: [email protected]; German Gonzalez > Subject: Re: Auto-generated keys using Sybase > > > Hi German, > > The $ character is a special character to iBATIS. > I guess you have to escape it, using $$. > That should work. > > Cheers, > Daniel Silva. > > On 7/11/05, German Gonzalez <[EMAIL PROTECTED]> wrote: > > 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.... > > > > > > > > > > > > > > > > > > > > > > > > > > >
