Atomikos Forum

Are there limits to the amount of writes to a db under one trx?

I am reading one large XML file from a message queue and writing all of the elements to records in a database.  Are there limits to the amount of records I can write to the database under one transaction?  I am getting around 320 or so records and then crashing with the following error:
"SQL state [null]; error code [0]; connection is closed; nested exception is com.atomikos.jdbc.AtomikosSQLException: connection is closed"
Garth
Garth Schneider Send private email
Friday, August 29, 2008
 
 
Hi,

There are no limits.

Did you consider buying dev support through our main site?

Thanks
Guy Pardon Send private email
Monday, September 01, 2008
 
 
Hi,
  I am having to much fun.  Fixed problem by setting reapTimeout to 0.
Garth
Garth Schneider Send private email
Wednesday, September 03, 2008
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics