I have the a similair problem, where my MySQL connection seems to die with a socket
connection error. I am going to try the following:
In hibernate.cfg.xml file, use:
<property
name="hibernate.connection.datasource">java:comp/env/jdbc/JbpmDS</property>
| instead of the direct jdbc connection.
In my webapps context.xml which should be found in
tomcat\conf\Catalina\localhost\[myappname].xml file, use something like:
<Resource name="jdbc/JbpmDS" auth="Container"
type="javax.sql.DataSource"/>
| <ResourceParams name="jdbc/JbpmDS">
| <parameter>
| <name>factory</name>
| <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
| </parameter>
| <parameter>
| <name>maxActive</name>
| <value>100</value>
| </parameter>
| <parameter>
| <name>maxIdle</name>
| <value>30</value>
| </parameter>
| <parameter>
| <name>maxWait</name>
| <value>10000</value>
| </parameter>
| <parameter>
| <name>username</name>
| <value>jbossjbpm</value>
| </parameter>
| <parameter>
| <name>password</name>
| <value>jbossjbpm</value>
| </parameter>
| <parameter>
| <name>driverClassName</name>
| <value>com.mysql.jdbc.Driver</value>
| </parameter>
| <parameter>
| <name>defaultAutoCommit</name>
| <value>true</value>
| </parameter>
| <parameter>
| <name>url</name>
| <value>jdbc:mysql://localhost/jbpm321</value>
| </parameter>
| <parameter>
| <name>removeAbandoned</name>
| <value>true</value>
| </parameter>
| <parameter>
| <name>removeAbandonedTimeout</name>
| <value>60</value>
| </parameter>
| <parameter>
| <name>logAbandoned</name>
| <value>true</value>
| </parameter>
| </ResourceParams>
|
I'm hoping the maxIdle parameter will do the trick.
You could lower the maxIdle value if need be.
Or, you could look at using hibernate.c3p0.timeout property in hibernate.cfg.xml, instead
of using the above method, but I think you may then need to go and get some extra
hibernate jar files or something.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4110775#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...