Oracle « Transaction « JPA Q&A

1. How to disable Bitronix JTA recovery    stackoverflow.com

I'm facing the following exception when a connection is acquired from Oracle:

javax.transaction.xa.XAException
    at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:705)
    at bitronix.tm.recovery.RecoveryHelper.recover(RecoveryHelper.java:103)
    at bitronix.tm.recovery.RecoveryHelper.recover(RecoveryHelper.java:61)
    at ...

2. Oracle FGA (audit) and JTA    stackoverflow.com

I'm developing web application (jpa + ejb inside war, hibernate, glassfish 3.1.1 AS), and I have a task to implement audit for data manipulation using Oracle FGA. I've found there's so called ...

3. Hibernate does not commit data    stackoverflow.com

I'm trying to write a web service to store some data using jBoss 4.2.3 and Oracle.
I suppose to use Hibernate with CMT and seems to me it doesn't commit ...

4. Oracle Session is Blocking transactions    forum.hibernate.org

I am getting the generic exception: org.hibernate.exception.GenericJDBCException: Cannot open connection Typically when this happens, I go to the database guys and they tell me that there is an Oracle session that is open and hasn't completed and that there are other sessions under it that cannot complete their transactions because it is blocking them. Any thoughts as to why I keep ...

5. Transaction workind in Oracle and different in Mysql    forum.hibernate.org

Author Message caetano Post subject: Transaction workind in Oracle and different in Mysql Posted: Fri Oct 01, 2004 1:48 pm Newbie Joined: Fri Oct 01, 2004 1:29 pm Posts: 5 Location: Brasil Hi all, I'm using Hibernate 2.1.6 with Spring 1.1 and I'm with the following problem: When executing a UnitTest with datasource Oracle, the session does not persist ...

6. Transaction Manager with Oracle IAS 10.1.2    forum.hibernate.org

Hibernate version: 2.1.6 I've succefuly used Hibernate with Oracle Application Server Containers for J2EE 10g (9.0.4.0.0) and also old version 9.0.3.0.0. Now I'd like to use it with 10g (10.1.2.0.0). I get this error at startup of Hibernate session: net.sf.hibernate.HibernateException: Could not locate TransactionManager at net.sf.hibernate.transaction.JNDITransactionManagerLookup.getTransactionManager(JNDITransactionManagerLookup.java:26) at net.sf.hibernate.transaction.JTATransactionFactory.configure(JTATransactionFactory.java:48) at net.sf.hibernate.transaction.TransactionFactoryFactory.buildTransactionFactory(TransactionFactoryFactory.java:48) at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:66) at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1155) at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:789) These are my configuration property: ...

7. Hibernate 3.0 not doing pessimistic locking with Oracle 8i    forum.hibernate.org

Hello all, I'm using Hibernate 3.0 and have run into an issue. My application uses Oracle 8i on the backend. There is a part of my application that must use pessimistic locking. I've tried the following code: SessionFactory sessionFactory = HibernateUtil.getSessionFactory(); Session session = sessionFactory.getCurrentSession(); Transaction tx = session.beginTransaction(); Manager manager = (Manager)session.get( Manager.class, new Long(33), LockMode.UPGRADE); LockMode lockMode = session.getCurrentLockMode(manager); ...

8. DB Lock Issue with Oracle 8    forum.hibernate.org

Hi We are using Hibernate in our project to talk to oracle 8 server. IN our application we are facing the problem of DB locks. By looking the db statistic if looks like a session is trying to have the row exclusive lock on the table with SELECT sql statement and at the same time other session is trying to obtain ...

9. DB Lock Issue with Oracle 8    forum.hibernate.org

Hi We are using Hibernate in our project to talk to oracle 8 server. IN our application we are facing the problem of DB locks. By looking the db statistic if looks like a session is trying to have the row exclusive lock on the table with SELECT sql statement and at the same time other session is trying to obtain ...

10. Hibernate 3.2: Oracle Clob management and deadlock    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: 3.2 Mapping documents: ...

11. How to prevent oracle deadlock?    forum.hibernate.org

Hi I have a Java Application with oracle 9i as the backend,this app is gonna be used over the internet .We are using Hibernate to access the database layer. As this application is used via internet there could be a problem of oracle deadlock as a number of people could be updating the data at the same time. I am aware ...