DB2 « Transaction « JPA Q&A





1. Hibernate / DB2 -913 deadlock    stackoverflow.com

An application deployed on several machines - accesses the same DB Table. It reads the MIN row and then deletes that row. When this happens concurrently, we get a -913 error from DB2 ...

2. JPA transaction error ( Note at the database side , values are persisted )    stackoverflow.com

I'm facing the below error :

Attempt to assign id "com.abc.java" to new instance "com.abc.java" failed; there is already an object in the L1 cache with this id. You ...

3. How to handle implicit commit of DB2 using Hibernate Transaction?    stackoverflow.com

I am currently using spring 3.0 & hibernate 3 and db2 as database in my application. i have sp in db2 in which there is a statement to refersh MQT and this ...

4. Deadlock issue using Hibernate 3.2.4 and DB2    forum.hibernate.org

Hi, During normal load we have not face any deadlock issue but with heavy load like above 50 users in HP Performance center or Test class using Thread having deadlock issue. This is very urgent, so let me know if you have any better solution using Hibernate and DB2 to avoid deadlock? We are trying to AddOrder and using the order ...

5. DB2 locked after a HSQL's Insert    forum.hibernate.org

From the look of this, it seems you are trying to manually set the primary key? This may be related to the fact that the transaction has not committed yet and/or the session has not flushed. Are you selecting from the same table you are inserting to? If you are using this to create your primary key, perhaps check what ...

6. Hibernate - DB2/400 - Journalling and commit    forum.hibernate.org

Folks I have an hibernate application up and running in development against a DB2/400. At this stage I point out that I am no iSeries(AS400) expert. The app runs fine when the DB2/400 files are journaled, but when they are not journaled(as is the intended case for production- don't ask me why?) I get the following [03/10/03 11:28:03:881 BST] 170a4eee JDBCException ...

7. DB2 and Deadlock    forum.hibernate.org

I am currently developing a product using Hibernate, DB2 and JBoss and I am experiancing deadlock The difficult part of the problem is that it locks on a various tables at different times. I am using TRANSACTION_REPEATABLE_READ as my transaction isolation level, and Spring Framework utilities to fit into our DAO pattern. Our datamodel is fairly complex and our transactions are ...

8. Hibernate, DB2, WebSphere 5.x and transactions    forum.hibernate.org

Hi, I have been studying this link for a day or so and I think there's a pretty good chance that I'm having the problem addressed within. I have searched high and low, but I'm not able to find a solution to the problem I'm having with the solution :). The article describes creating a custom connection provider instance which I ...

9. LockMode.UPGRADE not working on a DB2/OS390 Version 7    forum.hibernate.org

Newbie Joined: Fri Feb 25, 2005 7:39 am Posts: 2 Hallo, I am trying to use a pessimistic lock on a DB2/OS390 Version 7 Database. Code: HistoryItem hi1 = (HistoryItem)session1.load(HistoryItem.class,identifier,LockMode.UPGRADE); It's not working. I trace the DB2 input with the DB operator. We found that after each LockMode.UPGRADE send by hibernate (translated to: 'select ..... ...





10. Prolem DB2 dialect and LockMode.UPGRADE in Hibernate 3.1    forum.hibernate.org

Hi, I have a configuration with hibernate running in Websphere 5.1 and jdk 1.4 for mapping a db2 database. I'm using a load with LockMode.UPGRADE to lock the line. I'm doing this to get a key from a database without a sequence. It works with Hibernate 3.0 and generate a request SQL like "select ... for update with rr" I upgrade ...

11. JBoss / Hibernate / BMP (CMT) / DB2 / JDBC - DB locks are no    forum.hibernate.org

I am using >>>JBoss-3.2.5 >>>Hibernate-2.0.3 >>>BMP with CMT EJB's - Using requires transaction attribute. EJB's use Hibernate >>>DB2-8.1.7 I have a situation where Hibernate is used to create insert there records into DB and creating three entity beans for each record. Once the above process is complete i am invoking a JDBC call to get some information from the same table ...

12. Application must execute a rollback... WAS 5.1 / DB2 8.1    forum.hibernate.org

We are seeing the message "Application must execute a rollback. The unit of work has already been rolled back in the database but other resource managers involved in this unit of work might not. To ensure integrity of this application, all SQL requests will be rejected until the application issues a rollback." quite regularly in our application logs. The application is ...