Hi,
my webapplication provides a way to import data from a CSV file. If there are too many
records so, then the following exception is thrown:
org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.jboss.util.NestedSQLException: Transaction is not active:
tx=TransactionImpl:XidImpl
Because I only get this exception, when there are lots of records to import into the
application, I assume that at one point the transaction times out and becomes invalid. The
batch insert simply takes to long.
Where can I change/increase the timeout for a batch insert?
Even nicer would be to have a transaction for each record to insert, because the actualy
form one unit of work. So having the batch insert within one transaction is actually
wrong.
But I'm not sure, how I would do this? Should I use the @Transactional annotation? And
which attribute would I have to set on which function?
Any help is being appreciated...
toni
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4041122#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...