ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From TNO <tno...@free.fr>
Subject Re: Error when web application is unused for a long time
Date Fri, 19 Aug 2005 15:59:46 GMT
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...


Mime
View raw message