connection « Transaction « JPA Q&A





1. Persistence.createEntityManagerFactory() in J2EE ignores jta source    stackoverflow.com

I have a perfectly working application client deployed to a glassfish v2 server inside an ear with some EJBs, Entities, etc. I'm using eclipselink. Currently I have in my persistence.xml:

<persistence-unit name="mysource">
  ...

2. Hibernate :What makes JDBC connections expensive?    stackoverflow.com

I reading a book on Hibernate and I came across the following statement about the Session object.

....But as you know ,holding the JDBC connections across multiple requests ...

3. How many concurrent MySQL connections are allowed with Hibernate/JPA?    stackoverflow.com

How many max users can concurrently use MySQL database? I am using Hibernate Implementation of JPA.

4. Transaction management on multiple DB connections using hibernate    coderanch.com

Hi, If you want to manage transactions on multiple databases connections, can you do that with Hibernate? For instance, I want to update data on both databases, but the first transaction on a DB has to be rollback after second transaction on the other DB fails. How can you handle this kind scenario? Thanks in advance. Brad

6. Pass JDBC connection to hibernate and commit it outside    forum.hibernate.org

Hi Guys I am trying to figure out how can i pass a JDBC connection to hibernate and commit it outside of hibernate scope. Here is the flow: [legacy code] transaction begins [legacy code] update something [hibernate] update something else [legacy code] transaction ends one commit for all changes to DB This need arises as only few models were mapped to ...

7. Question about session.connection().commit();    forum.hibernate.org

So I am working on a project and part of what I want to do is to migrate them to 3. Along the way I am finding and replacing deprecated methods. I am doing ok but I am not sure what to do with session.connection().commit();. It appears people were told to use it by IBM can someone give me the code ...

8. DB Connection and Transaction Approach    forum.hibernate.org

Hi All- Couple of quick questions: 1) If using Hibernate primarily form stateless session beans (and MDB's), is it preferable to use the app server's DB connection pool, or does it make any difference? 2) Is it preferable to explicitly manage Hibernate transactions, or let the container manage them? Some points i'm particularly interested in on these questions is which approach ...

9. Transaction vs. connection.commit()    forum.hibernate.org





10. tx.commit/session.connection.commit() question    forum.hibernate.org

11. session.connection and transactions    forum.hibernate.org

Hello, i am trying to implement an audit log for the business objects in my database. Each business table has its own log table. Now, I've seen the AuditLog / History pattern in the Wiki, yet I got a problem with it when implementing the interceptor pattern: I cannot use the session but I can use a second session that sits ...

12. Application locks on opening JDBC Connection    forum.hibernate.org

13. hibernate.connection.autocommit    forum.hibernate.org

In Hibernate 3, there's a new property: hibernate.connection.autocommit In my mind, it makes sense to have all connections start as auto commit = true and then change as Transactions are started. However, this is not the default behavior. In addition, the documentation states that setting this property to true is "not recommended". Why is the case? Why does it make sense ...

14. Unable to obtain connection after X number of transactions    forum.hibernate.org

Newbie Joined: Thu May 05, 2005 5:57 pm Posts: 7 Location: California, USA Hibernate version: 3.0.5 Hi Hibernate team, I need to seek your expert advice again ;) I am running JBoss 4.0.2. And the connection pool's max size is 20. The database is PostgreSQL 8. I have a simple session bean method, login(): public void login(javax.security.auth.login.LoginContext lc) throws LoginException { ...

15. Session.connection and transactions    forum.hibernate.org

Hibernate version: 2.1 Name and version of the database you are using: Oracle 9i Hello, My question is whether a connection taken directly off of a Session object which is explictly part of a transaction also falls under that same transaction. I open the session and begin the transaction with: Session lSession = HibernateUtil.getSession(); Transaction tx = HibernateUtil.beginTransaction(lSession); Within the code ...

16. Session, Transaction and Custom Connection    forum.hibernate.org

My code obtains Connection c on its own. A Session s is opened with the Connection c. Then, s.save(object1);s.save(object2);....s.close()....c.commit(); Against mysql, it looks like the entire "transaction" got rolled back. The doc says, Transaction tx = s.beginTransaction .... t.commit(); s.close(), so I figure my approach is totally wacked right? But well, what if I wanted to do something custom to the ...





17. session.connection().commit() does not commit ?    forum.hibernate.org

19. Hibernate appears to be locking up when opening a connection    forum.hibernate.org

Hi I am havig some issues with hibernate locking after a few transactions. I am using the hibernate mapping objects to perform updates. The call in the code is as follows getHibernateTemplate().update(msgStatus); Where msgStatus is the mapping object. This works fine for a while, but after a few updates the database locks up. With the showsql turned on I, appears to ...

20. Transaction management on multiple DB connections    forum.hibernate.org

Hi Farzad Thanks for your quick answer and valuable information. I tried to implement it, however I got a error message org.hibernate.TransactionException: could not register synchronization. Would you correct me what I am wrong from the following? Thanks again, Brad ===Oracle JDBC Driver (XA) on Websphere datasource=== oracle.jdbc.xa.client.OracleXADataSource ===hibernate configuration=== org.hibernate.dialect.Oracle9iDialect jdbc/dsXA1 org.hibernate.transaction.CMTTransactionFactory

21. Why Multi JDBC connection in a single transaction?    forum.hibernate.org

Newbie Joined: Tue Feb 19, 2008 4:44 pm Posts: 1 During an hibernate transaction, I'm doing a get() and seeing, in the log, many "opening JDBC connection" and the number of PreparedStatement is never greater than 1. I only read tables, no update or insert. The "hibernate.connection.release_mode" by default is set to after_statement and according to the hibernate doc, it's "highly ...