If u want to increment generator u should use

select gen_id(TIMER_GENERATOR,1) from RDB$DATABASE;

Regard,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of
rambabu.piridi@...
Sent: Thursday, June 15, 2006 10:07 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Generator problem::::::Urgent held need



I am using FireBird Data base. when i use the following query
select gen_id(TIMER_GENERATOR,1) from timer_details;
Here the sequence name is: TIMER_GENERATOR. schema name is:
timer_details

when i execute above query i am getting the
java.sql.SQLException: Error: executeQueryForObject returned too many
results.
when i execute the same query at the command prompt it works fine.

Is problem in Ibatis?.




Thanks n Regards,
===================
Rambabu Piridi.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]