Hi,
I am using Firebird-1.0.3.972-Win32.exe version on windows 2000
professional,and the driver used is JayBird JCA/JDBC.I am having a
problem while inserting bulk amount of data into database through
stored procedure.
The stored procedure has few insert statement's

Java code calling the store procedure
-------------------------------------

try
{
dbConnection.setAutoCommit(false);
call=dbConnection.prepareCall("execute procedure insert_data
('"+agrexCode+"','"+postalCode+"','"+todofukenKanji+"','"+todofukenKan
a+"','"+shikugunKanji+"','"+shikugunKana+"','"+chosonKanji+"','"+choso
nKana+"','"+tsushoKanji+"','"+tsushoKana+"')");
call.execute();
dbConnection.commit();

}
catch(Exception e)
{
try{
dbConnection.rollback();

}
catch(java.sql.SQLException sqle2)
{
returnString=sqle2+"Unable to rollback";
}
}

The program work's properly after inserting certain amount of data
and later it's unable to rollback the transaction and stop's here.
The exception's are
org.firebirdsql.jdbc.FBSQLException: GDS Exception. invalid request
handle
org.firebirdsql.jdbc.FBSQLException: GDS Exception. invalid statement
handle
org.firebirdsql.jdbc.FBSQLException: GDS Exception. invalid request
handle
-
-
-
org.firebirdsql.jdbc.FBSQLException: GDS Exception. Error reading
data from the connection.Unable to rollback

java.sql.SQLException: ResourceException:
org.firebirdsql.jca.FBResourceException: Unable to complete network
request to host "".

java.sql.SQLException: ResourceException:
org.firebirdsql.jca.FBResourceException: local transaction active:
can't begin another

Can anyone throw some ideas why the tranasction is not getting rolled
back,and what's the root problem.

Txs in advance.
Regards,
Ragavendra.