Subject Re: [firebird-support] Generator problem::::::Urgent held need
Author Dimitry Sibiryakov
On 15 Jun 2006 at 12:37, rambabu.piridi@... wrote:

>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:
>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
>Is problem in Ibatis?.

The problem seems in logic. It looks like table timer_details
contain more than one record while your query component expect only

SY, Dimitry Sibiryakov.