ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sundar Sankar <fatboys...@gmail.com>
Subject Re: FW: Connection Closing Problem
Date Tue, 02 Jun 2009 20:15:16 GMT
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