Hi,

Can anyone give me idea why I am getting this problem

Application is written in java,driver used is JayBird.
There is no problem with the driver(I have already posted this
problem in Firebird-Java and the reply is some problem with the
server)

System specification's
-----------------------
Client and Server are on the same machine
Version of Firebird database Firebird-1.0.3.972-Win32.exe
Operating System is Windows 2000 Professional,261 MB RAM

Test Case Description
---------------------
The scenario involve's the application to read each line of text from
a text file process it and insert data into the database by calling a
stored procedure.

Test Condition
---------------
Created database with five table's.
Inserted some static data into two table's.
Created generator's on two table's in which data is inserted at
runtime.
Run a .sql file for creation of stored procedure which consist's of
eight database insert statement's.
I am making connection.autoCommit(false) before calling the stored
procedure and committing the transaction once it is succesfully
executed else rolling back the transaction.
Run the java program from command prompt

Expected Result
---------------
Suceesful execution of the application and populating data in
respective table's after processing of the entire text file(the text
file may contain between 200,000 to 300,000 lines or more).
Total data inserted,if the application is sucessfully executed(approx
between 220 to 300 MB)

Actual result
--------------
After processing 14000 line's(this varies between 14000 to 17000) of
text file the application raises the exception.

Log file messages
-----------------
1)Message's in database server's log file()

<
(Client) Thu Aug 21 13:17:17 2003
Guardian starting: C:\Firebird\bin\ibserver.exe


(Server) Thu Aug 21 16:52:44 2003
gds__free: attempt to release bad block


(Server) Thu Aug 21 16:52:44 2003
gds__free: attempt to release bad block


(Server) Thu Aug 21 16:52:44 2003
gds__free: attempt to release bad block


(Server) Thu Aug 21 16:52:44 2003
gds__free: attempt to release bad block

(Server) Thu Aug 21 16:52:45 2003
gds__alloc: memory pool corrupted


(Server) Thu Aug 21 16:52:45 2003
gds__alloc: memory pool corrupted


(Server) Thu Aug 21 16:52:45 2003
gds__alloc: memory pool corrupted


(Server) Thu Aug 21 16:52:45 2003
gds__alloc: memory pool corrupted


(Server) Thu Aug 21 16:52:45 2003
gds__alloc: memory pool corrupted


(Server) Thu Aug 21 16:52:45 2003
gds__alloc: memory pool corrupted


(Client) Thu Aug 21 16:52:46 2003
C:\Firebird\bin\ibserver.exe: terminated abnormally (-1)

>

2)Exception's raised during the execution of application.

<
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
java.sql.SQLException: ResourceException:
org.firebirdsql.jca.FBResourceException: local transaction active:
can't begin another

>

Thanks in advance.
Regards,
Ragavendra.