table « Transaction « JPA Q&A





1. hibernate locked table    stackoverflow.com

Why is this giving me a lock timeout:

for(int i = 0; i < playersCount ; i++) {
            StatUser stats = ...

2. Hibernate and transactions and table locking    stackoverflow.com

If I have code that looks like the following:

beginTransaction();
// lots of stuff happens, can take anywhere from a minute to several minutes.
// it will read from several tables via calling getter ...

3. applying optimistic locking/ Versioning on database table    stackoverflow.com

I am trying to perform optimistic locking on database table . I have implemented versioning for each record in the table which works good and it perfectly throws exception when the ...

4. JPA Lock Table    coderanch.com

I need to lock table. If I am correct JPA suppose to have a lock only for a single record. So the only approach I have to create another table with the record indicating the table is locked. Is it right? Table A { } // this entire table I need to lock Table B { table_A_locked INT } // get ...

5. Hibernate - PreUpdateEventListener - Locks Table    coderanch.com

Hi Guys This code works perfect for one appliction where JTA is used. The second applictian I am attempting to get this code working in, freezes on the last line. The underlying DB in both cases is SQL Server 2008 What happens is that Hibernates locks the table on the database. I have to release the lock in the DB. public ...

6. Tables remain locked after unsucessfull commit    forum.hibernate.org

Author Message braiam Post subject: Tables remain locked after unsucessfull commit Posted: Tue Nov 17, 2009 6:40 pm Newbie Joined: Tue Nov 17, 2009 6:16 pm Posts: 2 Hello guys. Well, Im currently facing this problem. I want to persist two instances of the same class. The table related to the class has a Unique Key Constraint. When the ...

7. How to lock table for particular session    forum.hibernate.org

8. Locking a table    forum.hibernate.org

Hi all, I'm experimenting a problem of unique contraint violation when trying to insert in a table. I need at an application level to make sure that an instance of a table called X here won't be modified by both client at the same time, so I have implemented kind of a lock process. So before a client try to modify ...

9. lock table in the database    forum.hibernate.org

OK, this is a very good and simple idea. But I have one more doubt. When two users try to register the same login, one of them will get a success page and the other will get a fail (horrible) page. This fail page will have an HibernateException with a SQL unique constraint violation error. I can not show this to ...





10. how to lock tables using hibernate    forum.hibernate.org

can anyone pls tell me how to lock tables in the database using hibernate? my scenario is as follow: Command1 will load objects from the database and update them. Command2 is executed while Command1 has not yet finished executing, n Command2 updates the same objects used in Command1. the problem is i want to block Command2 from executing if Command1 hasn't ...

11. Locking tables    forum.hibernate.org

Hi everyone! Im trying to do the following using Hibernate and Mysql 4: LOCK TABLES tb_tb1 WRITE; SELECT * FROM tb_tb1; UNLOCK TABLES; I wanna to completly lock the table, I mean, anyone from anywhere may not do a SELECT in that table. I tried using the LockMode class but I didn't get the wanted result. Thanks in advance. --- Rodrigo ...

12. Locking table    forum.hibernate.org

Hi Is it possible to lock a table with Hibernate? The scenario is that when I delete a record in the table, I need to update some fields of all the records in the same table. During the deleting/updating process, I don't want anyone to insert/update/delete data from this table but allow users to view data in the original state. How ...

13. Blocking all tables in Hibernate transaction?    forum.hibernate.org

Newbie Joined: Wed Oct 05, 2005 1:20 pm Posts: 15 Location: Russia Izhevsk Hello I am using Spring 1.2.6, Hibernate 3.1rc3, Struts. I have a task to drop and create all database tables and load data into database from file in other words restore data from backup archive at runtime. Code:

14. Transaction locking up tables    forum.hibernate.org

Hi, I'm having a problem with Hibernate where it basically locks the table that has been updated within a transaction, such that you can't query from the table anymore (even from a query tool). I tried setting the isolation level to as low as possible ("read uncommitted"): hibernate.connection.isolation=1 However, it's still locking the table. Basically my code is doing batch processing. ...

15. How to preserve static cache tables after transaction ends?    forum.hibernate.org

Dear members, I have the typical country table with information about the countries. It is a static table that doesn't change during our batch process. I am using transaction for saving amount of big objects every time. What we have detected is that when the transaction ends, the session is closed and the country cache information is lost. Is there any ...

16. locking a table    forum.hibernate.org





17. Modify object does not update table after commit    forum.hibernate.org

When I update a property of my domain class, it does not update the respective database table after committing the transaction. No SQL Update command get executed, even invoking Session.flush() manually. Session.isDirty() returns false. However, the property of object in the persistent context is changed. This occurs when I implements the long-conversation approach using ThreadLocal pattern. If (for testing-sake) I use ...

18. Lock table    forum.hibernate.org

Yes, you're right, that hibernate takes care that my primary keys are generated unique but I think that there will be some situations where I'll have to lock a whole table. Especially when I have to make sure that nobody writes data during some select statements. I know that locking a table isn't good for the performance but in the moment ...

20. why are locked table stats a problem for schema update?    forum.hibernate.org

Author Message rwellis Post subject: why are locked table stats a problem for schema update? Posted: Thu Jun 04, 2009 5:47 pm Newbie Joined: Thu Jun 04, 2009 5:18 pm Posts: 1 I'm hoping you can help me understand what's happening behind the scenes. On Tomcat startup when Hibernate is updating the schema if Oracle table statistics are locked ...