Hi!
To which file would you add it?
-----Original Message-----
From: meindert [mailto:meind...@eduflex.com]
Sent: Tuesday, September 08, 2009 2:52 PM
To: user-java@ibatis.apache.org
Subject: RE: Problem with connecting
I would add the validationQuery to the datasource, not sure if it helps in
your case though;
That would validate old connections before using them.
Here is my datasource setup;
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${database_driver}"
/>
<property name="url" value="${database_url}" />
<property name="username" value="${database_user}" />
<property name="password" value="${database_password}" />
<property name="defaultAutoCommit" value="true"/>
<property name="defaultTransactionIsolation" value="2"/>
<property name="maxActive" value="10"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="30"/>
<property name="logAbandoned" value="false"/>
<property name="validationQuery" value="select 1"/>
</bean>
-----Original Message-----
From: Odelya YomTov [mailto:ode...@jpost.com]
Sent: 08 September 2009 10:45 AM
To: user-java@ibatis.apache.org
Subject: Problem with connecting
Hi!
Once a day I get the following message:
javax.servlet.ServletException: Failed to execute queryForObject - id
[getUserByNameAndPassword], parameterObject
[il.co.yalkut.data.userd...@4d8d50]. Cause:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in il/co/yalkut/dbaccess/sql/User.xml.
--- The error occurred while applying a parameter map.
--- Check the getUserByNameAndPassword-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last
packet successfully received from the server was42677 milliseconds ago.The
last packet sent successfully to the server was 42677 milliseconds ago,
which is longer than the server configured value of 'wait_timeout'. You
should consider either expiring and/or testing connection validity before
use in your application, increasing the server configured values for client
timeouts, or using the Connector/J connection property 'autoReconnect=true'
to avoid this problem.
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last
packet successfully received from the server was42677 milliseconds ago.The
last packet sent successfully to the server was 42677 milliseconds ago,
which is longer than the server configured value of 'wait_timeout'. You
should consider either expiring and/or testing connection validity before
use in your application, increasing the server configured values for client
timeouts, or using the Connector/J connection property 'autoReconnect=true'
to avoid this problem.
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.
java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
I added &autoReconnect=true to the url in database.properties but it doesn't
help!
What can I do?
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.81/2350 - Release Date: 09/07/09
18:03:00
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
****************************************************************************
********
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer
viruses.
****************************************************************************
********
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
