Hi everybody,
i have a problem about deadlock on a table.
I have twomethod inside a Session EJB.
The first does a run a SELECT statament on the table TEST to get some data and put them insiede an ArrayList, then i use this ArrayList to display data on a report.
The second method does and insert statement into the table TEST.
Well, the table TEST contains about 500.000 records and the database is IBM DB2.
When I launch the first method to create the report and, while it is running, I call the second method i get a DEADLOCK error because it seems that the first method LOCKS the entire table TEST.
I know that calling a method inside a Session EJB i start a transaction, so could be right put the first method outside the Session EJB to avoid the start of the transaction ?
Any suggestion ?
I have a doubt, everytime i open a connection (outsidea Session EJB) to a database do i start a trnsaction anyway ?
Any suggestion ?
Cheers.
Stefano