InnoDB « Transaction « JPA Q&A





1. InnoDB deadlock with read-uncommited! - Java - Glassfish - EJB3 (JPA/Hibernate)    stackoverflow.com

I'm new here and need some help :) It's been several days that i got deadlock issues on a Java application with Glassfish - EJB3 with Mysql InnoDB Config: Mysql InnoDB: Ver 14.12 Distrib ...

2. MySql rollback for InnoDB tables doesn't affect any data changed in MyIsam tables by triggers defined in InnoDB tables    stackoverflow.com

So I'm using Hibernate to operate with Mysql from Java and have a fairly simple transaction rollback scenario I'm trying to get to work. I have table DOCUMENT (InnoDB engine) and ...

3. Grails session handling in waiting thread with Hibernate and MySQL InnoDB    stackoverflow.com

In order to realize client-side notifications in an AJAX-driven application that I am developing with Grails (and GWT), I have implemented a service method that will block until it is being ...

4. JPA2 with MySQL backend: MyISAM or InnoDB    stackoverflow.com

Obviously, there is plenty out there about MyISAM vs InnoDB engine selection, but I couldn't find anything specific to JPA2. Is it possible to use a MyISAM engine together with java persistence ...

5. JPA, InnoDB, and locking in multi-threaded app    forums.netbeans.org

6. When does InnoDB usage lock tables ?    forum.hibernate.org

Hello, I'm investigating a recurring problem of dead locks. I *think* the origin is that a process is frequently locking tables instead of individual rows. show open tables where in_use > 0 While the process runs I'm almost always getting something for this query. I'm going to debug manually line-by-line and check for locks at the same time. But it would ...

7. Hibernate Transaction and MySQL myISAM, innoDB    forum.hibernate.org

Hello together, Im working on a developing a webapplication with Spring 3.0.5, Hibernate 3.6. and mySQL Community Server 5.1. I have a question regarding the transaction management. 1) First of all: is it correct, that when you use hibernate you MUST use transactions? there is no way to avoid that transactions must be used? I read that all over the internet, ...

8. Why MySQL InnoDB locking index of FK table on insert?    forum.hibernate.org

Expert Joined: Thu Jan 08, 2004 6:17 pm Posts: 278 First: I *know* this is not a Hibernate issue, per se. However, I also know this forum way better than any other forum, and I have gotten way more help here than anywhere else ever, so I'm taking a chance on posting here. Our enterprise application includes a distributed set of ...

9. JTA Transaction not updating InnoDB tables    forum.hibernate.org

I recenlty switched over from MyISAM to InnoDB tables in my MySQL 5.0.20 database to ensure transactions rolled back if they were not valid. Also, I am using Hibernate 3.1. Performing a simple JDBC transaction, the following code works correctly i.e. my InnoDB table is updated correctly: Code: Customer ctmr = new Customer("John", "Doe"); ctmr.setcid(1); //Set customer ID Fintrans fts ...





10. JTA Transaction with InnoDB Tables    forum.hibernate.org

Is it at all possible to have a JTA Transaction that makes an entry into an InnoDB table? Ive tried just about everything I can think of and I cannot get it to work. My java code: Code: UserTransaction tx = (UserTransaction) new InitialContext().lookup("java:comp/UserTransaction"); try{ Customer ctmr = new Customer("abc", "def"); ...