You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by TNO <tn...@free.fr> on 2005/08/19 15:44:39 UTC
Error when web application is unused for a long time
Hello,
I am working on a web application using Ibatis, Spring and JSP on Jonasz
Server with DB PostGre.
Sometime after 2 hours of inactivity, we have this error. With a F5
refresh on the navigator, the application re-works fine.
I wonder if Ibatis and my cache configuration can be involved in my error...
By the way, I have no cache configuration !
Here the exception, sorry it's the french one !
Thanks, Thomas
org.apache.jasper.JasperException: (SqlMapClient operation): encountered
SQLException [ --- The error occurred in
arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
occurred while applying a parameter map. --- Check the
getConsFormulaire-InlineParameterMap. --- Check the statement (query
failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested
exception is com.ibatis.common.jdbc.exception.NestedSQLException: ---
The error occurred in arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml.
--- The error occurred while applying a parameter map. --- Check the
getConsFormulaire-InlineParameterMap. --- Check the statement (query
failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient
operation): encountered SQLException [ --- The error occurred in
arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
occurred while applying a parameter map. --- Check the
getConsFormulaire-InlineParameterMap. --- Check the statement (query
failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested
exception is com.ibatis.common.jdbc.exception.NestedSQLException: ---
The error occurred in arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml.
--- The error occurred while applying a parameter map. --- Check the
getConsFormulaire-InlineParameterMap. --- Check the statement (query
failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:99)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:184)
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:222)
arc.cons.dao.ibatis.ConsFormulaireDAOiBatis.get(ConsFormulaireDAOiBatis.java:27)
arc.cons.service.impl.ConsFormulaireMgrImpl.get(ConsFormulaireMgrImpl.java:49)
sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
arc.common.advice.PerformanceInterceptor.invoke(PerformanceInterceptor.java:65)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
$Proxy8.get(Unknown Source)
sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
$Proxy9.get(Unknown Source)
org.apache.jsp.tdb.tdbFormChamp_jsp._jspService(tdbFormChamp_jsp.java:103)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
Re: Error when web application is unused for a long time
Posted by Prashanth Sukumaran <pr...@yahoo.com>.
Hi,
You need to have the PING Query in the sql-map-config.xml. I think that should fix the problem.
Rgds
Prashanth Sukumaran.
--- TNO <tn...@free.fr> wrote:
> Hello,
>
> I am working on a web application using Ibatis, Spring and JSP on Jonasz
> Server with DB PostGre.
> Sometime after 2 hours of inactivity, we have this error. With a F5
> refresh on the navigator, the application re-works fine.
>
> I wonder if Ibatis and my cache configuration can be involved in my error...
> By the way, I have no cache configuration !
>
> Here the exception, sorry it's the french one !
>
> Thanks, Thomas
>
> org.apache.jasper.JasperException: (SqlMapClient operation): encountered
> SQLException [ --- The error occurred in
> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
> occurred while applying a parameter map. --- Check the
> getConsFormulaire-InlineParameterMap. --- Check the statement (query
> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested
> exception is com.ibatis.common.jdbc.exception.NestedSQLException: ---
> The error occurred in arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml.
> --- The error occurred while applying a parameter map. --- Check the
> getConsFormulaire-InlineParameterMap. --- Check the statement (query
> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
> java.security.AccessController.doPrivileged(Native Method)
> javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
> org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
>
> org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
>
>
>
> org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient
> operation): encountered SQLException [ --- The error occurred in
> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
> occurred while applying a parameter map. --- Check the
> getConsFormulaire-InlineParameterMap. --- Check the statement (query
> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested
> exception is com.ibatis.common.jdbc.exception.NestedSQLException: ---
> The error occurred in arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml.
> --- The error occurred while applying a parameter map. --- Check the
> getConsFormulaire-InlineParameterMap. --- Check the statement (query
> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
>
>
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:99)
>
>
>
>
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)
>
>
> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:184)
>
>
>
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:222)
>
>
> arc.cons.dao.ibatis.ConsFormulaireDAOiBatis.get(ConsFormulaireDAOiBatis.java:27)
>
> arc.cons.service.impl.ConsFormulaireMgrImpl.get(ConsFormulaireMgrImpl.java:49)
>
> sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
>
>
>
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
>
>
>
>
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
>
>
> arc.common.advice.PerformanceInterceptor.invoke(PerformanceInterceptor.java:65)
>
>
>
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
>
>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
>
> $Proxy8.get(Unknown Source)
> sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
>
>
>
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
>
>
>
>
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
>
>
>
>
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
>
>
>
>
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
>
>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
>
> $Proxy9.get(Unknown Source)
> org.apache.jsp.tdb.tdbFormChamp_jsp._jspService(tdbFormChamp_jsp.java:103)
>
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
> java.security.AccessController.doPrivileged(Native Method)
> javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
> org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
>
> org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Re: Error when web application is unused for a long time
Posted by TNO <tn...@free.fr>.
I try this :
<bean id="dataSourceArcDb"
class="com.ibatis.common.jdbc.SimpleDataSource">
<constructor-arg type="java.util.HashMap">
<map>
<entry key="JDBC.Driver" value="${jdbc.driverClassName}"/>
<entry key="JDBC.ConnectionURL" value="${jdbc.url}"/>
<entry key="JDBC.Username" value="${jdbc.username}"/>
<entry key="JDBC.Password" value="${jdbc.password}"/>
<entry key="JDBC.DefaultAutoCommit"
value="${jdbc.defaultAutoCommit}"/>
<entry key="Pool.PingQuery" value="SELECT 1"/>
<entry key="Pool.PingEnabled" value="true"/>
<entry key="Pool.PingConnectionsOlderThan" value="1000000"/>
</map>
</constructor-arg>
</bean>
it seems to work fine...
Thanks everybody
TNO a écrit :
> But I have a problem... I'm using Spring framework...
>
> I use Spring to initialize my dataSource in the Spring
> application-context.xml:
>
> <bean id="dataSourceArcDb"
> class="org.apache.commons.dbcp.BasicDataSource">
> <property
> name="driverClassName"><value>${jdbc.driverClassName}</value>
> </property><property
> name="url"><value>${jdbc.url}</value></property>
> <property
> name="username"><value>${jdbc.username}</value></property>
> <property
> name="password"><value>${jdbc.password}</value></property>
> <property
> name="defaultAutoCommit"><value>${jdbc.defaultAutoCommit}</value>
> </property>
> </bean>
> ...
> <bean id="sqlMapClientArcDb"
> class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
> <property name="configLocation">
> <value>classpath:arc/db/config/sql-map-config-arcdb.xml</value>
> </property>
> </bean>
> ...
> <bean id="adresseDAO" class="arc.db.dao.ibatis.AdresseDAOiBatis">
> <property name="dataSource"><ref bean="dataSourceArcDb" /></property>
> <property name="sqlMapClient"><ref bean="sqlMapClientArcDb"
> /></property>
> </bean>
>
> With org.apache.commons.dbcp.BasicDataSource, there is no property Pool.
> They are specific to com.ibatis.common.jdbc.SimpleDataSource.
>
> and when I try to use a com.ibatis.common.jdbc.SimpleDataSource
> instead of org.apache.commons.dbcp.BasicDataSource,
> Spring tells me that there is no default constructor. Confirm by the
> javaDoc and the code, it needs a Map!
>
> May be a little evolution to use a
> com.ibatis.common.jdbc.SimpleDataSource with Spring is to create a
> default constructor ?
>
> Thomas
>
>
> Meindert a écrit :
>
>> It doesn't have to be a "real" query, following settings worked for
>> me (mysql)
>>
>> <dataSource type="SIMPLE">
>>
>> ...
>>
>> <property name="Pool.PingQuery" value="SELECT 1"/>
>>
>> <property name="Pool.PingEnabled" value="true" />
>>
>> <property name="Pool.PingConnectionsOlderThan" value="1000000" />
>>
>> ...
>>
>> ------------------------------------------------------------------------
>>
>> *From:* TNO [mailto:tnodev@free.fr]
>> *Sent:* 19 August 2005 03:45 PM
>> *To:* ibatis
>> *Subject:* Error when web application is unused for a long time
>>
>>
>>
>> Hello,
>>
>> I am working on a web application using Ibatis, Spring and JSP on
>> Jonasz Server with DB PostGre.
>> Sometime after 2 hours of inactivity, we have this error. With a F5
>> refresh on the navigator, the application re-works fine.
>>
>> I wonder if Ibatis and my cache configuration can be involved in my
>> error...
>> By the way, I have no cache configuration !
>>
>> Here the exception, sorry it's the french one !
>>
>> Thanks, Thomas
>>
>> org.apache.jasper.JasperException: (SqlMapClient operation):
>> encountered SQLException [ --- The error occurred in
>> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
>> occurred while applying a parameter map. --- Check the
>> getConsFormulaire-InlineParameterMap. --- Check the statement (query
>> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
>> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested
>> exception is com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in
>> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
>> occurred while applying a parameter map. --- Check the
>> getConsFormulaire-InlineParameterMap. --- Check the statement (query
>> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
>> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
>>
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
>>
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
>> sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>> org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
>>
>> java.security.AccessController.doPrivileged(Native Method)
>> javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
>> org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
>>
>> org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
>>
>>
>>
>> org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient
>> operation): encountered SQLException [ --- The error occurred in
>> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
>> occurred while applying a parameter map. --- Check the
>> getConsFormulaire-InlineParameterMap. --- Check the statement (query
>> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
>> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested
>> exception is com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in
>> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
>> occurred while applying a parameter map. --- Check the
>> getConsFormulaire-InlineParameterMap. --- Check the statement (query
>> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
>> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
>> org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:99)
>>
>> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)
>>
>> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:184)
>>
>> org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:222)
>>
>> arc.cons.dao.ibatis.ConsFormulaireDAOiBatis.get(ConsFormulaireDAOiBatis.java:27)
>>
>> arc.cons.service.impl.ConsFormulaireMgrImpl.get(ConsFormulaireMgrImpl.java:49)
>>
>> sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
>>
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
>>
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
>>
>> arc.common.advice.PerformanceInterceptor.invoke(PerformanceInterceptor.java:65)
>>
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
>>
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
>>
>> $Proxy8.get(Unknown Source)
>> sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
>>
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
>>
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
>>
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
>>
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
>>
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
>>
>> $Proxy9.get(Unknown Source)
>> org.apache.jsp.tdb.tdbFormChamp_jsp._jspService(tdbFormChamp_jsp.java:103)
>>
>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
>>
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
>>
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
>> sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>> org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
>>
>> java.security.AccessController.doPrivileged(Native Method)
>> javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
>> org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
>>
>> org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
>>
>>
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG Anti-Virus.
>> Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date:
>> 18/08/2005
>>
>>
>> --
>> No virus found in this outgoing message.
>> Checked by AVG Anti-Virus.
>> Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date:
>> 18/08/2005
>>
>
>
>--
>Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs...
>
--
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs...
Re: Error when web application is unused for a long time
Posted by TNO <tn...@free.fr>.
But I have a problem... I'm using Spring framework...
I use Spring to initialize my dataSource in the Spring
application-context.xml:
<bean id="dataSourceArcDb"
class="org.apache.commons.dbcp.BasicDataSource">
<property
name="driverClassName"><value>${jdbc.driverClassName}</value>
</property><property
name="url"><value>${jdbc.url}</value></property>
<property name="username"><value>${jdbc.username}</value></property>
<property name="password"><value>${jdbc.password}</value></property>
<property
name="defaultAutoCommit"><value>${jdbc.defaultAutoCommit}</value>
</property>
</bean>
...
<bean id="sqlMapClientArcDb"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
<value>classpath:arc/db/config/sql-map-config-arcdb.xml</value>
</property>
</bean>
...
<bean id="adresseDAO" class="arc.db.dao.ibatis.AdresseDAOiBatis">
<property name="dataSource"><ref bean="dataSourceArcDb" /></property>
<property name="sqlMapClient"><ref bean="sqlMapClientArcDb"
/></property>
</bean>
With org.apache.commons.dbcp.BasicDataSource, there is no property Pool.
They are specific to com.ibatis.common.jdbc.SimpleDataSource.
and when I try to use a com.ibatis.common.jdbc.SimpleDataSource instead
of org.apache.commons.dbcp.BasicDataSource,
Spring tells me that there is no default constructor. Confirm by the
javaDoc and the code, it needs a Map!
May be a little evolution to use a
com.ibatis.common.jdbc.SimpleDataSource with Spring is to create a
default constructor ?
Thomas
Meindert a écrit :
> It doesn't have to be a "real" query, following settings worked for me
> (mysql)
>
> <dataSource type="SIMPLE">
>
> ...
>
> <property name="Pool.PingQuery" value="SELECT 1"/>
>
> <property name="Pool.PingEnabled" value="true" />
>
> <property name="Pool.PingConnectionsOlderThan" value="1000000" />
>
> ...
>
> ------------------------------------------------------------------------
>
> *From:* TNO [mailto:tnodev@free.fr]
> *Sent:* 19 August 2005 03:45 PM
> *To:* ibatis
> *Subject:* Error when web application is unused for a long time
>
>
>
> Hello,
>
> I am working on a web application using Ibatis, Spring and JSP on
> Jonasz Server with DB PostGre.
> Sometime after 2 hours of inactivity, we have this error. With a F5
> refresh on the navigator, the application re-works fine.
>
> I wonder if Ibatis and my cache configuration can be involved in my
> error...
> By the way, I have no cache configuration !
>
> Here the exception, sorry it's the french one !
>
> Thanks, Thomas
>
> org.apache.jasper.JasperException: (SqlMapClient operation):
> encountered SQLException [ --- The error occurred in
> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
> occurred while applying a parameter map. --- Check the
> getConsFormulaire-InlineParameterMap. --- Check the statement (query
> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested
> exception is com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in
> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
> occurred while applying a parameter map. --- Check the
> getConsFormulaire-InlineParameterMap. --- Check the statement (query
> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
>
> java.security.AccessController.doPrivileged(Native Method)
> javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
> org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
>
> org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
>
>
>
> org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient
> operation): encountered SQLException [ --- The error occurred in
> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
> occurred while applying a parameter map. --- Check the
> getConsFormulaire-InlineParameterMap. --- Check the statement (query
> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested
> exception is com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in
> arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
> occurred while applying a parameter map. --- Check the
> getConsFormulaire-InlineParameterMap. --- Check the statement (query
> failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
> d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
> org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:99)
>
> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)
>
> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:184)
>
> org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:222)
>
> arc.cons.dao.ibatis.ConsFormulaireDAOiBatis.get(ConsFormulaireDAOiBatis.java:27)
>
> arc.cons.service.impl.ConsFormulaireMgrImpl.get(ConsFormulaireMgrImpl.java:49)
>
> sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
>
> arc.common.advice.PerformanceInterceptor.invoke(PerformanceInterceptor.java:65)
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
>
> $Proxy8.get(Unknown Source)
> sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
>
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
>
> $Proxy9.get(Unknown Source)
> org.apache.jsp.tdb.tdbFormChamp_jsp._jspService(tdbFormChamp_jsp.java:103)
>
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
>
> java.security.AccessController.doPrivileged(Native Method)
> javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
> org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
>
> org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 18/08/2005
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 18/08/2005
>
--
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs...
RE: Error when web application is unused for a long time
Posted by Meindert <me...@pastelebusiness.com>.
It doesnt have to be a real query, following settings worked for me
(mysql)
<dataSource type="SIMPLE">
<property name="Pool.PingQuery" value="SELECT 1"/>
<property name="Pool.PingEnabled" value="true" />
<property name="Pool.PingConnectionsOlderThan" value="1000000" />
_____
From: TNO [mailto:tnodev@free.fr]
Sent: 19 August 2005 03:45 PM
To: ibatis
Subject: Error when web application is unused for a long time
Hello,
I am working on a web application using Ibatis, Spring and JSP on Jonasz
Server with DB PostGre.
Sometime after 2 hours of inactivity, we have this error. With a F5 refresh
on the navigator, the application re-works fine.
I wonder if Ibatis and my cache configuration can be involved in my error...
By the way, I have no cache configuration !
Here the exception, sorry it's the french one !
Thanks, Thomas
org.apache.jasper.JasperException: (SqlMapClient operation): encountered
SQLException [ --- The error occurred in
arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error occurred
while applying a parameter map. --- Check the
getConsFormulaire-InlineParameterMap. --- Check the statement (query
failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested exception
is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error
occurred in arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
occurred while applying a parameter map. --- Check the
getConsFormulaire-InlineParameterMap. --- Check the statement (query
failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
72)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:16
1)
org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient
operation): encountered SQLException [ --- The error occurred in
arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error occurred
while applying a parameter map. --- Check the
getConsFormulaire-InlineParameterMap. --- Check the statement (query
failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
d''entrée/sortie a eu lieu lors d''envoi vers le serveur.]; nested exception
is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error
occurred in arc/cons/dao/ibatis/config/ConsFormulaireSQL.xml. --- The error
occurred while applying a parameter map. --- Check the
getConsFormulaire-InlineParameterMap. --- Check the statement (query
failed). --- Cause: org.postgresql.util.PSQLException: Une erreur
d''entrée/sortie a eu lieu lors d''envoi vers le serveur.
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQ
LStateSQLExceptionTranslator.java:99)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translat
e(SQLErrorCodeSQLExceptionTranslator.java:257)
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemp
late.java:184)
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapCli
entTemplate.java:222)
arc.cons.dao.ibatis.ConsFormulaireDAOiBatis.get(ConsFormulaireDAOiBatis.java
:27)
arc.cons.service.impl.ConsFormulaireMgrImpl.get(ConsFormulaireMgrImpl.java:4
9)
sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopU
tils.java:287)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(ReflectiveMethodInvocation.java:155)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:122)
arc.common.advice.PerformanceInterceptor.invoke(PerformanceInterceptor.java:
65)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:144)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro
xy.java:174)
$Proxy8.get(Unknown Source)
sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopU
tils.java:287)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(ReflectiveMethodInvocation.java:155)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:122)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tr
ansactionInterceptor.java:57)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:144)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro
xy.java:174)
$Proxy9.get(Unknown Source)
org.apache.jsp.tdb.tdbFormChamp_jsp._jspService(tdbFormChamp_jsp.java:103)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
24)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:16
1)
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 18/08/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 18/08/2005