Hi,
I encountered something similar and approached it by tweaking the datasource
bean:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url"
value="jdbc:mysql://x.x.x.x/db?useUnicode=true&characterEncoding=utf-8"/>
<property name="username" value="root"/>
<property name="password" value=""/>
<property name="maxActive" value="100"/>
<property name="maxIdle" value="30"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
<property name="validationQuery">
<value>SELECT 1</value>
</property>
<property name="testOnBorrow" value="true"/>
</bean>
I've only experienced it with MySql, never with Oracle. The above is not
necessarily the final solution though. After deploying, I still have had a
MySql pooling exception. May have missed using another property.
Do NOT consider using the c3p0 DB pooling implementation.
Regards,
Jon
java_user_ wrote:
>
> Has anyone figured out what is causing the CommunicationsException after
> 8+ hours on idle time?
> It is a stale connection and adding "autoReconnect=true" in the JDBC URL
> has not fixed the issue.
>
> There appears to be a few threads on the forum discussing the issue but I
> have not seen a final resolution...
>
> Thanks
>
>
> org.springframework.transaction.CannotCreateTransactionException: Could
> not open Hibernate Session for transaction; nested exception is
> org.hibernate.TransactionException: JDBC begin failed:
> Caused by: org.hibernate.TransactionException: JDBC begin failed:
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
> at
>
--
View this message in context:
http://www.nabble.com/CommunicationsException-tp18569133s2369p18708292.html
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
