statement « Transaction « JPA Q&A





1. "Cached Item Was Locked" causing Select Statement in Hibernate    stackoverflow.com

I am having trouble with getting some caching to work with hibernate exactly the way I would like. I created some example code to replicate this problem I am having. ...

2. Hibernate session.flush() in multi statement transaction    stackoverflow.com

Hi I am facing strange behavior in hibernate.
I am doing ht.saveOrUpdate(myObj) on an object.
In the same method i am next loading a view from database ...

3. Putting Select Statement on Hibernate Transaction    stackoverflow.com

I have been reading the net for a while regarding Hibernate but I can seem to understand one concept regarding Transaction. On some site that I have visit, Select statements are in ...

4. Visibilty of statements in a view related to transaction?    stackoverflow.com

i have a question about data visibility in database views. I use Oracle. I have a table myscheme.users and a table global.users (myscheme and global are schemes) There is a view "globalusers" in the ...

5. Safely handle Hibernate "SET TRANSACTION must be first statement of transaction" error    stackoverflow.com

I'm not sure if I'm asking the correct question to begin with, apologies in advanced.

Question

I am wondering if it is possible to have some type of handler to rollback an erroneous ...

6. "Cached Item Was Locked" causing Select Statement using Hibernate and EHCache    coderanch.com

I am having trouble with getting some caching to work with hibernate exactly the way I would like. I created some example code to replicate this problem I am having. I have one object that contains instances of itself. For instance, a Part that is made up of more Parts. I really need to minimize the select statements that Hibernate is ...

7. "Cached Item Was Locked" causing Select Statement: EHCache + Hibernate + GF    java.net

INFO: CALLED PERSIST FINEST: Cache lookup: com.cache.dataobject.Part#1 FINE: key: com.cache.dataobject.Part#1 FINE: Element for com.cache.dataobject.Part#1 is null FINEST: Cache miss: com.cache.dataobject.Part#1 FINEST: Cache lookup: com.cache.dataobject.Part#2 FINE: key: com.cache.dataobject.Part#2 FINE: Element for com.cache.dataobject.Part#2 is null FINEST: Cache miss: com.cache.dataobject.Part#2 FINEST: Cache lookup: com.cache.dataobject.Part#3 FINE: key: com.cache.dataobject.Part#3 FINE: Element for com.cache.dataobject.Part#3 is null FINEST: Cache miss: com.cache.dataobject.Part#3 FINEST: Invalidating: com.cache.dataobject.Part.parts#1 FINE: key: com.cache.dataobject.Part.parts#1 FINE: ...

8. JTA and after_statement    forum.hibernate.org

9. Using JPQL, including Sysdate in INSERT Statement, Opt Lock    forum.hibernate.org

Here's what we want to do: Using JPQL (avoiding native SQL), we want to include inside the generated SQL INSERT statement the Oracle SYSDATE function. So when Oracle sees the INSERT statement with the SYSDATE it will convert it to current time before it does the insert. Here's where it gets complex: the field that uses the SYSDATE function that we ...





10. Command not allowed within multi-statement transaction    forum.hibernate.org

session = sessionFactory.openSession(); connection = session.connection(); statement = connection.prepareStatement(sql); if(args != null) { for(int argument = 1; argument <= args.length; argument++) ...

11. Transaction API with prepared statements    forum.hibernate.org

12. Empty transaction generates SQL Statements    forum.hibernate.org

While debugging my application I made the following excpetionell discovery An empty transaction (no code between session.beginTransaction() and transaction.commit()) generates a delete statment on my oracle database. in my opinion that doesnt make any sense independent of the state of the actual session, any other session or transactions or the state of other database transactions. am i wrong? Here is the ...

13. DeadLock occurs in a Select statement    forum.hibernate.org

This problem only occurs on a MSSQL database. When I am doing a Select query, the table which that is done on is being locked. So when another process tries to query it, a deadlock occurs after a time giving this error : java.sql.SQLException: Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as ...

14. sorting out insert statements to avoid deadlock    forum.hibernate.org

Newbie Joined: Thu May 19, 2005 11:19 am Posts: 12 Hi, I am running in a deadlock when 2 transactions are concurrently inserting several objects that involve 2 tables (abstract superclass & concrete subclass): class ActionHistoryEntry extends CaseHistoryEntry. CaseHistoryEntry maps to CASE_LOG, ActionHistoryEntry maps to CASE_LOG_ACTION. I suspect the problem comes from the successive insert into CASE_LOG,CASE_LOG_ACTION,CASE_LOG,CASE_LOG_ACTION,... in both transactions. The ...

15. Hib generating invalid insert statement on .commit    forum.hibernate.org

Author Message arnieOag Post subject: Hib generating invalid insert statement on .commit Posted: Thu Jul 27, 2006 3:52 pm Beginner Joined: Tue Jul 25, 2006 12:34 pm Posts: 25 Overview: I populate the various HbmXXX record objects and then call .save() as appropriate. Eventally, if all is well, I call .commit which then gets an error that two fields ...

16. Session.lock generates update statement    forum.hibernate.org

Hibernate decides when to flush updates - I assume these are updates that have been made programmatically but have not yet been sent to the DB? Not sure why the lock() call would do this, but it may be that Hibernate needs to flush all updates so that when it queries the version number to avoid optimistic lock failure it gets ...





17. "Cached Item Was Locked" causing Select Statement    forum.hibernate.org

Newbie Joined: Tue Jul 22, 2008 5:11 pm Posts: 16 I am having trouble with getting some caching to work with hibernate exactly the way I would like. I created some example code to replicate this problem I am having. I have one object that contains instances of itself. For instance, a Part that is made up of more Parts. I ...

18. c3p0 'apparent deadlock' with c3p0.max_statements = 0    forum.hibernate.org

View unanswered posts | View active topics Board index Hibernate & Java Persistence Hibernate Users All times are UTC - 5 hours [ DST ] c3p0 'apparent deadlock' with c3p0.max_statements = 0 Page 1 of 1 [ 8 posts ] Previous topic | Next topic Author Message Arnuz Post subject: ...