mysql « Connection « JPA Q&A





1. Hibernate/mysql connection pooling    stackoverflow.com

We host a service (servlet running on jboss), which receives something like 5-6 requests per second. Every request needs to connect to mysql through hibernate. Most of our requests do selects, ...

2. Something wrong with Hibernate DB connection pooler c3p0    stackoverflow.com

since last post, did all the changes suggested but this problem still haunts me. Here's the error i get:

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 44,499,102 ...

3. C3P0 connection pool tester is not called    stackoverflow.com

I tried to check if connect is up or down to MySQL using C3P0 connection pool tester. It works if password is correct. But password can be changed and I need ...

4. C3P0 Connection Problem    stackoverflow.com

I am using hibernate and cp30 for database operations and getting error:

com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection
Here are my jdbc properties:
    <property name="acquireIncrement" value="2"/>
    <property name="initialPoolSize" value="6"/>
    ...

5. (MySQLNonTransientConnectionException) Hibernate3.6 + MySQL5 + c3p0    stackoverflow.com

I am using JPA + hibernate 3.6.6 + MySQL5 (mysql-connector-java-5.1.6-bin.jar) with c3p0-0.9.1.jar pool implementation. My persistence.xml

<properties>
  <property name="hibernate.connection.username" value="xxx"/>
  <property name="hibernate.connection.driver_class" value="xxx"/>
  <property name="hibernate.connection.password" value="xxx"/>
  <property name="hibernate.connection.url" ...

6. Hibernate and MySQL connection issues    coderanch.com

After a lot of research, it appears that a lot of people (including me) are having "broken pipe" problems with Hibernate and MySQL after the typical 8 hour timeout period. Hibernate does not apparently handle this problem for us. One possible posted solution that I'm trying to try is to use C3PO, the connection pool from sourceforge. However, when I add ...

7. MySQL Connection Problems    forum.hibernate.org

Hello. I am having a connection problem with MySQL. I did a search but got over 8000 results. My hibernate.cfg.xml looks like this: org.gjt.mm.mysql.Driver ******** jdbc:mysql://dmzhost/ebl_price_catalog webservice org.hibernate.connection.C3P0ConnectionProvider 1 5 300 50 org.hibernate.dialect.MySQL5Dialect When ...

8. c3p0 not able to limit connections from mysql    forum.hibernate.org

Hi, i am using Hibernate 3.1 with struts 2.0 and mysql as DB. My c3p0 connection setting are as follows.. 3 5 20 org.hibernate.connection.C3P0ConnectionProvider 20 But still when I start my application and do showprocesslist it shows 6 connection in sleep more over as I roam into the application with ...

9. Hibernate & mysql connection after connection closed.    forum.hibernate.org

Hi! I use hibernate in my web application, and got couple times following exception, after my computer has been idle over night, and started use application again next day. Exception will disappear, if i install program again to tomcat, but that's really isn't any solution. Mar 11, 2004 1:13:59 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions WARNING: SQL Error: 0, SQLState: 08003 Mar 11, 2004 ...





10. Connection problem with MySQL    forum.hibernate.org

Author Message arijitm Post subject: Connection problem with MySQL Posted: Thu Mar 18, 2004 5:59 am Beginner Joined: Tue Mar 02, 2004 1:12 pm Posts: 25 Location: Newcastle Upon Tyne Hi I am trying to develop a persistent framework with Hibernate, and using Hibernate 2.1, and MySql as my data store. The example provided in the Hibernate source distribution ...

11. mysql killing the connection after X seconds?    forum.hibernate.org

I was testing my application and after a certain amount of time I get a JDBCException, Could not execute query. Is this because mysql is closing the connection after a certian amount of time? To fix the problem, I just restart Tomcat and it works, so I'm not sure how the connection is being terminated. I'm running Tomcat 5.0.24 MySQL 4.0.18 ...

12. Connection problems with Hibernate/Tomcat50./mysql    forum.hibernate.org

hi all, i have a webapp taht uses Hibernate and MYSQL, running on top of tomcat. i am letting Hibernate handle the connections to mysql db, since i have no connection pools defined in tomcat. after running the application for nearly 9 hours, when i tried to use my app to connect to the database i got following exception: Caused by: ...

13. MySQL connection expires    forum.hibernate.org

I have written a web application that connects to a MySQL database. Everything works fine for the first 8 hours, after which the MySQL connection expires. I have changed the hibernate.properties file several times as suggested in the forum, but to no avail. I use: Hibernate 2.1.4 C3P0 0.9.0-pre6 MySQL 4.0.18 Tomcat 5.0.16 hibernate.properties: hibernate.c3p0.acquire_increment=2 hibernate.c3p0.idle_test_period=300 hibernate.c3p0.max_size=100 hibernate.c3p0.min_size=5 hibernate.c3p0.timeout=3000 hibernate.connection.driver_class=org.gjt.mm.mysql.Driver hibernate.connection.url=### ...

14. Hibernate - MySQL Problem. Connection gets closed in 8 hrs    forum.hibernate.org

Hi , I have a problem with Hibernate-MySQL appln in which database connection gets lost and is not recovering after some 5 hours of inactivity throwing, with following exception. EXCEPTION ========= Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.UnknownHostException MESSAGE: serverURL STACKTRACE: java.net.UnknownHostException: serverURL at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:153) at java.net.Socket.connect(Socket.java:452) at java.net.Socket.connect(Socket.java:402) at java.net.Socket.(Socket.java:309) at ...

15. mysql hibernate connection Broken pipe    forum.hibernate.org

I am using hibernate 3.0 with mysql-connector-java-3.1.7 and after a few hours wihtout activity in the database the hibernate connection gives me the following error wen trying to make an insertion: org.hibernate.exception.GenericJDBCException: could not insert: [net.saphety.emessage.hibernate.Emessage] at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1777) at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2178) at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239) at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:240) at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) at ...

16. connection Hibernate-mysql    forum.hibernate.org

I have a local data base called pruebasjava in mysql and have created hibernate.cfg.xml com.mysql.jdbc. Driver jdbc: mysql: ///pruebasjava





17. c3p0/mysql connection poling    forum.hibernate.org

Is there a way I can check that hibernate actually is using C3P0 for pooling and that the number of connections is as specified in my config? I ask because when I check "Server Connections" on "MySQL Administrator", it says only 1 user connected to the database, when in fact I have specified a min of 10. I'm using MySQL 5, ...

18. Connection with mysql close suddenly    forum.hibernate.org

Beginner Joined: Fri Sep 02, 2005 3:42 pm Posts: 32 Hi, i'm using a mysql in one application and suddenly my connection with DB follows down. The exception is: Code: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909) ...

19. Problem with MySql Connection    forum.hibernate.org

Pleas help. I am using hibernate 3.1.3. and integrated with struts application. I am using mySql as the database with hibernate connection. I deployed it as a war file in weblogic 8.1. It is working fine. But when is keep it open this application and next day access the program it fails at JDBC part and gives the follwing error. But ...

21. MySQL Database connection with c3p0 fails (works only once)    forum.hibernate.org

Newbie Joined: Wed Oct 04, 2006 10:24 am Posts: 3 Hi everybody, I am building a small CMS application with struts and hibernate on tomcat 5.5.17 Since I've discovered that the built in connection pool is not intended for production use, I am trying to switch over to c3p0 and there are my problems. (Using c3p0-0.9.1-pre6) The connection with c3p0 works ...

22. Re: Problem with MySql Connection    forum.hibernate.org

Hi all, Pleas help. I am using hibernate 3.1.3. and integrated with struts application. MySql Weblogic 8.1 I am using Weblogic connection(from JNDI look up). I deployed it as a war file in weblogic 8.1.But when I access this application after a very logn time(next day) it fails at JDBC part and gives the error given at the end. But when ...

23. loose connection with mysql    forum.hibernate.org

hi I use hibernate 3.2, java 1.5, mysql4 and rcp. My application is for intranet (~10 users). I had a problem that my connection gone when the application was in idle. So i add the connection.pool_size = 0 to the configuration. Now there is no problems with the connection. Is this a right solution? Or exists it a better one? For ...

24. MySQL - too many connections problem    forum.hibernate.org

sorry, i use hibernate 3... and the below are the datasource details, testuser jdbc:mysql://test:3306/testdb org.hibernate.dialect.MySQLDialect TEST com.mysql.jdbc.Driver 10 false update tests 10 100

25. Hibernate MySql connection problem.    forum.hibernate.org

In MySql DB on my hosting set wait_timeout=60 but I can't change it b/c I haven't permission, after one minute appearse exception "could not execute query" and trace log in catalina.out log file. Question: What I need to add in my hibernate.cfg.xml file or what i need done for takinig connection alive??? Please help It's wary important!!!

26. mysql connection closed    forum.hibernate.org

Newbie Joined: Sat Aug 23, 2008 9:10 am Posts: 5 i'm using hibernate3. is my dao using the right way to retrieve object from mysql db ? i don't close connection, and i use hibernatesessionfactory.currentSession() to always get current session Code: public MyMember getMyMember(String name) { MyMember MyMember = new MyMember(); ...

27. Connection problem with mySql    forum.hibernate.org

I am using springframework and hibernate with MySql I have problem with connection as If once the connection lost with the MySql server It can not reconnect to MySql. If there is any mapping or property setting I missed please suggest me. I am using.... b]Hibernate version:[/b] Hibernate3 Mapping documents: Code: jdbc:mysql://localhost:3306/mcardio username ...

28. Problem establishing a connection with MySql database    forum.hibernate.org

Newbie Joined: Tue Jul 14, 2009 5:17 am Posts: 1 Hi, I'm a student and I am trying to create a simple online questionnaire to collect information for a final year dissertation. I have wrote a small application using Struts, JSP, Hibernate to connect to a MySQL database. The application is running fine on my local development machine, but when I ...