Can anyone help explain why I'm still getting this stack trace with this hibernate config? The "MySQL close connections after 8 hours" problem is remedied on the development server (running Tomcat 4.1.29, MySQL 4.0.17, Hibernate 2.1.2, Solaris) but NOT on the deployment server (of course) whcih is running: Tomcat 4.1.29, MySQL 4.0.18, Hibernate 2.1.2, Solaris. One noticeable difference between the two installations is not the MySQL versions, but rather the Java versions 1.4.2 on development and 1.4.1 on deployment. Could this be the issue? Not that I shouldn't upgrade the 1.4.1 instance, but I just want to get this thing running at this point and if it isn't the root of the problem then I don't want to spend the time doing it at the moment.... Thank you!
Hibernate config....
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory name="scape:/hibernate/SessionFactory">
<property name="hibernate.cache.provider_class">net.sf.ehcache.hibernate.Provider</property>
<!-- <property name="connection.datasource">java:comp/env/jdbc/scapeDB</property>-->
<property name="show_sql">true</property>
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<property name="connection.username">scape</property>
<property name="connection.password">scap3</property>
<property name="connection.url">jdbc:mysql://localhost:3306/scape?autoReconnectForPools=true</property>
<property name="connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="transaction.factory_class">net.sf.hibernate.transaction.JDBCTransactionFactory</property>
<property name="cache.use_query_cache">true</property>
<property name="use_outer_join">false</property>
<property name="hibernate.cglib.use_reflection_optimizer">false</property>
<!--configure connection pool -->
<property name="dbcp.maxActive">100</property>
<property name="dbcp.whenExhaustedAction">1</property>
<property name="dbcp.maxWait">120000</property>
<property name="dbcp.maxIdle">1</property>
<property name="dbcp.minIdle">0</property>
<property name="dbcp.ps.maxActive">10</property>
<property name="dbcp.ps.whenExhaustedAction">1</property>
<property name="dbcp.ps.maxWait">120000</property>
<property name="dbcp.ps.maxIdle">100</property>
<property name="dbcp.validationQuery">select 1</property>
<property name="dbcp.testOnBorrow">true</property>
<property name="dbcp.testOnReturn">false</property>
<!-- Mapping files -->
<mapping resource="object.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Login
FAQ
Search
