ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From German Gonzalez <german.gonza...@gmail.com>
Subject Re: Auto-generated keys using Sybase
Date Tue, 12 Jul 2005 15:05:02 GMT
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 <gakins@amervideo.com> 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:dhsilva@gmail.com]
> Sent: Monday, July 11, 2005 10:29 AM
> To: user-java@ibatis.apache.org; 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 <german.gonzalez@gmail.com> 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 <GAEngel@tribune.com> 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....
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>

Mime
View raw message