Return-Path: 
 <user-java-return-16909-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 84888 invoked from network); 2 Jun 2009 20:04:35 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 2 Jun 2009 20:04:35 -0000
Received: (qmail 50172 invoked by uid 500); 2 Jun 2009 20:04:46 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 50148 invoked by uid 500); 2 Jun 2009 20:04:46 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 50097 invoked by uid 99); 2 Jun 2009 20:04:31 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Jun 2009 20:04:31 +0000
X-ASF-Spam-Status: No, hits=1.5 required=10.0
	tests=SPF_PASS,WEIRD_PORT
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [64.129.72.1] (HELO mail.eaglexm.com) (64.129.72.1)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Jun 2009 20:04:22 +0000
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.5
Subject: FW: Connection Closing Problem
Date: Tue, 2 Jun 2009 14:03:58 -0600
Message-ID: <AD6473E20781CB4EA0936BAD85AEBE6105F39A20@EX-01.eagledirect.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Connection Closing Problem
Thread-Index: Acnhdu4aWaSiI5NnQx2M+mTxTJsPVwCRkc+w
From: "Nathan Modrzewski" <nmodrzewski@eaglexm.com>
To: <user-java@ibatis.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

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]=20
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.=20

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


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

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

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

Below is some java code that uses it:

Reader reader =3D
Resources.getResourceAsReader("ibatis_map/echodrive/server/SqlMapConfig.
xml");
try {
    map =3D SqlMapClientBuilder.buildSqlMapClient(reader,properties);
    map.startTransaction();
    try {=20
        // Do some selects / updates / inserts
        =20
        map.commitTransaction();
    } finally {
        map.endTransaction();
    }
} finally {
    reader.close();
}

If anyone has any ideas, I would appreciate it.

Thanks,
  -- Nathan