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