ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Modrzewski" <nmodrzew...@eaglexm.com>
Subject RE: FW: Connection Closing Problem
Date Tue, 02 Jun 2009 20:18:11 GMT
Not yet...getting ready too.

 

If I'm using Apache Dbcp to handle connection pooling, do I have to
manually close the pooling objects?

 

From: Sundar Sankar [mailto:fatboysuns@gmail.com] 
Sent: Tuesday, June 02, 2009 2:15 PM
To: user-java@ibatis.apache.org
Subject: Re: FW: Connection Closing Problem

 

Did u try stepping in through the Ibatis code to see what might actually
be happening when u make the call?

On Tue, Jun 2, 2009 at 1:03 PM, Nathan Modrzewski
<nmodrzewski@eaglexm.com> wrote:

I'm still having problems with this and have not been able to figure it
out. Anybody have any ideas?

Thanks,
 -- Nathan


-----Original Message-----
From: Nathan Modrzewski [mailto:nmodrzewski@eaglexm.com]
Sent: Saturday, May 30, 2009 4:35 PM
To: user-java@ibatis.apache.org

Subject: Connection Closing Problem

I am having a problem with my Postgresql 8.3 connections not being
closed when the program is finished. Here are a few of the messages from
the Postgresql log file:

2009-05-30 16:18:59 MDT [echodrive_machine @ echodrive]: LOG:
unexpected EOF on client connection
2009-05-30 16:19:00 MDT [echodrive_machine @ echodrive]: LOG:
unexpected EOF on client connection
2009-05-30 16:19:00 MDT [echodrive_machine @ echodrive]: LOG:
unexpected EOF on client connection
2009-05-30 16:19:02 MDT [echodrive_machine @ echodrive]: LOG:
unexpected EOF on client connection


I'm sure its something I'm doing wrong. I am using Apache Dbcp for my
connection pooling. I'm using IBatis 2.3.4 and Apache DBCP 1.2.2.

Below is a the xml settings I use for my IBatis and DBCP setup.


<sqlMapConfig>
   <settings
       useStatementNamespaces="true"
       cacheModelsEnabled="false"
       enhancementEnabled="false"
       lazyLoadingEnabled="false"
       maxRequests="1024"
       maxSessions="256"
       maxTransactions="64"
   />

   <transactionManager type="JDBC" commitRequired="true">
           <property name="JDBC.DefaultAutoCommit" value="false" />
           <property name="JDBC.SetAutoCommitAllowed" value="false" />
         <dataSource type="DBCP">
               <property name="driverClassName"
value="org.postgresql.Driver" />
               <property name="url"
value="jdbc:postgresql://db-05.eaglexm.com:5432/${database}
<http://db-05.eaglexm.com:5432/$%7Bdatabase%7D> " />
                   <property name="username" value="${username}" />
                   <property name="password" value="${password}" />
                   <property name="maxActive" value="32" />
                   <property name="maxIdle" value="5" />
                   <property name="maxWait" value="30000" />
                   <property name="validationQuery" value="select id
from system_settings" />
                   <property name="logAbandoned" value="false" />
                   <property name="timeBetweenEvictionRunsMillis"
value="60000" />
                   <property name="numTestsPerEvictionRun" value="5" />
                   <property name="minEvictableIdleTimeMillis"
value="600000" />
       </dataSource>
   </transactionManager>

   ... my "sqlMap" statements / includes ...
</sqlMapConfig>

Below is some java code that uses it:

Reader reader =
Resources.getResourceAsReader("ibatis_map/echodrive/server/SqlMapConfig.
xml");
try {
   map = SqlMapClientBuilder.buildSqlMapClient(reader,properties);
   map.startTransaction();
   try {
       // Do some selects / updates / inserts

       map.commitTransaction();
   } finally {
       map.endTransaction();
   }
} finally {
   reader.close();
}

If anyone has any ideas, I would appreciate it.

Thanks,
 -- Nathan

 


Mime
View raw message