Depends on your datasource... I'm using spring so it's in my spring.xml
-----Original Message----- From: Odelya YomTov [mailto:[email protected]] Sent: 08 September 2009 02:17 PM To: [email protected] Subject: RE: Problem with connecting Hi! To which file would you add it? -----Original Message----- From: meindert [mailto:[email protected]] Sent: Tuesday, September 08, 2009 2:52 PM To: [email protected] 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:[email protected]] Sent: 08 September 2009 10:45 AM To: [email protected] 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: [email protected] For additional commands, e-mail: [email protected] 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: [email protected] For additional commands, e-mail: [email protected] **************************************************************************** ******** 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: [email protected] For additional commands, e-mail: [email protected] 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: [email protected] For additional commands, e-mail: [email protected]
