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.
