C3p0 « JDBC « JPA Q&A

1. Network latency under Hibernate/c3p0/MySQL stackoverflow.com

I'm connecting to a MySQL (InnoDB) database over a connection with fairly high latency (~80ms) but relatively high bandwidth. I've noticed that query times vary dramatically depending on how the query is ...

2. JDBC - c3p0 - hibernate - setAutocommit, Can someone please help me clarify the story stackoverflow.com

The fundamental source of my questionning came from this observation. When I use Hibernate and make any query, I get the following in the MySQL logs:

SET autocommit=0
insert into SimpleNamedEntity (name, version) ...

3. C3p0/Hibernate coderanch.com

4. Hibernate, c3p0 and "No JDBC driver class..." forum.hibernate.org

Newbie Joined: Mon Sep 27, 2010 9:16 am Posts: 2 Hello, community! I use in my project: hibernate-code 3.5.1-Final hibernate-entitymanager 3.5.1-Final hibernate-c3p0 3.5.1-Final And I have a problem... :-) When I was tried to build EJB factory via Persistences.createEntityManagerFactory(...) I've got next exception: Quote: 10/09/27 17:08:34 INFO connection.ConnectionProviderFactory: Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider 10/09/27 17:08:34 INFO connection.C3P0ConnectionProvider: C3P0 using driver: null at ...

5. C3PO: native JDBC connection forum.hibernate.org

Hi, is it possible to retrieve the underlying JDBC connection from a connection which is provided by C3PO? For DBCP I know: Code: if( conn instanceof PoolableConnection) { PoolableConnection pconn = (PoolableConnection) conn; ...

6. Using c3p0, the JDBC connection is suddenly closed forum.hibernate.org

Beginner Joined: Mon Nov 07, 2005 11:10 pm Posts: 30 Hi, I have recently migrated from Hibernate 2.1.8 to 3.1.2. I have managed to: 1) Replace all JARs with newer versions from 3.1.2 2) Search and replace the DTD URLs in all *.hbm.xml files 3) Search and replace net.sf.hibernate to org.hibernate 4) Update *.hbm.xml with correct lazy attributes that replicates the ...

7. Resultset getting closed when c3p0 Connection Pooling Used forum.hibernate.org

Hi, I am firing a hql in a method say A and iterating throught the result in a loop. Within the loop I am calling a method say B which inturn fires another hql or uses criteria. When the control moves back to the loop in the calling method A, I get an exception "SQL Error: 17010 SQLState: null" and the ...

8. DB2 Invalid Conversion Error/C3P0 Prepared Statement Caching forum.hibernate.org

I am getting an Invalid Conversion error from DB2 - see stack trace below 2007-09-25 16.29.46 SQL Error: -99999, SQLState: 07006 2007-09-25 16.29.46 [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006 2007-09-25 16.29.46 Error Processing Finished Product Declaration org.hibernate.exception.SQLGrammarException: could not load an entity: [com.nppc.mes.domain.productdefinition.FinishedProduct#17800 46572] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadEntity(Loader.java:1359) I am using Hibernate 3.0.5, with C3P0 enabled. Tried with the ...