java.sql.SQLException: Already closed.

[Melvin Wong]

But now I have a new prob.

 

-I'm using iBatis 2.3.4 and DBCP 1.2.2 on Tomcat 6

-When I start Tomcat and run my first request, things went fine

-Then I when i run my second request, error below happened

-My ibatis config file is attached

 

**********************************

ERROR LOG

 

java.sql.SQLException: Already closed.

                at
org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)

                at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(P
oolingDataSource.java:181)

                at
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.close(JdbcTransact
ion.java:81)

                at
com.ibatis.sqlmap.engine.transaction.TransactionManager.end(TransactionManag
er.java:93)

                at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapEx
ecutorDelegate.java:734)

                at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSession
Impl.java:176)

                at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientIm
pl.java:153)

              at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlM
apExecutorDelegate.java:835)

                at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDe
legate.java:410)

                at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.jav
a:82)

                at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:
58)

                at
my.com.justmobile.engine.SSUMEngine.log(SSUMEngine.java:408)

                at
my.com.justmobile.engine.SSUMEngine.validate(SSUMEngine.java:292)

                at
my.com.justmobile.engine.SSUMEngine.process(SSUMEngine.java:205)

                at
my.com.justmobile.SSUMServlet.processRequest(SSUMServlet.java:145)

                at my.com.justmobile.SSUMServlet.doGet(SSUMServlet.java:242)

                at
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)

                at
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

                at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:290)

                at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)

                at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:233)

                at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:175)

                at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128
)

                at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102
)

                at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:109)

                at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)

                at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:
852)

                at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(H
ttp11AprProtocol.java:584)

                at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)

                at java.lang.Thread.run(Thread.java:619)

 

Attached are my configurations files. I'm still waiting to discuss your
rate. I'm open, let me know your thoughts. 

 

 

Thank you for your time to read this email.

Mel

SqlMapConfig.properties
Description: Binary data

ssum.properties
Description: Binary data

<?xml version="1.0" encoding="UTF-8"?>
<!--
    Document   : IBatisConfig.xml.xml
    Created on : December 1, 2008, 2:44 AM
    Author     : Iker Hernaez (i.hern...@hif-soft.net)
    Description:
        Defines the connection and sqlMaps used by SecureScoreUploadModule (SSUM).
        Uses the 'ssum.db.jndi' property in file 'my/com/justmobile/ssum.properties'
        for looking up the connection through JNDI.
-->
<!DOCTYPE sqlMapConfig 
  PUBLIC '-//ibatis.apache.org//DTD SQL Map Config 2.0//EN'
  'http://ibatis.apache.org/dtd/sql-map-config-2.dtd'>
<sqlMapConfig>
    <properties resource="SqlMapConfig.properties" />
    <settings
       cacheModelsEnabled="true"
       enhancementEnabled="true"
       lazyLoadingEnabled="true"
       maxRequests="32"
       maxSessions="10"
       maxTransactions="5"
       useStatementNamespaces="false"
    />
    <transactionManager type="JDBC" >
	<dataSource type="DBCP">
            <property name="driverClassName" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${username}"/>
            <property name="password" value="${password}"/>
            <property name="initialSize" value="5"/>
            <property name="maxActive" value="45"/>
            <property name="maxIdle" value="-1"/>
            <property name="maxWait" value="-1"/>
            <property name="poolPreparedStatements" value="false"/>
	</dataSource>
    </transactionManager>
    <sqlMap resource="my/com/justmobile/db/Validation.xml" />
    <sqlMap resource="my/com/justmobile/db/PlayerGame.xml" />
    <sqlMap resource="my/com/justmobile/db/ScoreUploadLog.xml" />
    <!-- These're deprecated. If SSUMEngine.validateOld() is deleted, delete them too. -->
    <sqlMap resource="my/com/justmobile/db/Player.xml" />
    <sqlMap resource="my/com/justmobile/db/Game.xml" />
</sqlMapConfig>