Large Transacion with EJB 2.1

[jcerdeira]

I have one funtionality to delete a large number of Rows, but of wich row i have to passed it to a history table. So i do a SELECT -> a CREATE -> and a DELETE for each rows.

For 10000 of rows give me a TransactionTimeOut.

Anyone have a solution for this ??


thanks

[jaikiran]

You can specify your own transaction timeout. By default, this is 5 minutes and is specified in jboss-service.xml under server/default/conf

[jcerdeira]

OK.

jaikiran thanks for reply. Nut this do not resolve my problem because big timeout is bad and if i have 5 millions of rows the time out must be enormous :(

any other solution to resolve a bid remove ans insert in a transaction ?

[jcerdeira]

Sorry for wrong typing

jaikiran thanks for reply.

But this do not resolve my problem because big timeout is bad and if i have 5 millions of rows the time out must be enormous :(

any other solution to resolve a big remove ansd insert in a transaction ?

"jcerdeira" wrote:
OK.

jaikiran thanks for reply. Nut this do not resolve my problem because big timeout is bad and if i have 5 millions of rows the time out must be enormous :(

any other solution to resolve a bid remove ans insert in a transaction ?