ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Henrique Ferreira e Silva <dhsi...@gmail.com>
Subject Re: Auto-generated keys using Sybase
Date Mon, 11 Jul 2005 14:28:39 GMT
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