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 <[EMAIL PROTECTED]> 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
