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 <nmodrzew...@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:nmodrzew...@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 >
