You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-cs@ibatis.apache.org by Jakub Scheibe <ja...@gmail.com> on 2007/07/11 17:28:09 UTC

Generators&FB

Hi,

I want to get gen_id from my database (firebird), but when I'm trying to
execute this sql query by iBatis

SELECT GEN_ID(my_generator_name, 1) from RDB$DATABASE

I'm getting error like this:

Unterminated dynamic element in sql (SELECT GEN_ID(my_generator_name, 1)
from RDB$DATABASE)..

Looks like there is a problem with $ in RDB$DATABASE.

Any idea how should I do it in iBatis?

Regards,
Jakub.