date:20090530

Connection Closing Problem

2009-05-30 Thread Nathan Modrzewski

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} /
property name=username value=${username} /
property name=password value=${password} /
property name=maxActive value=32 /
property name=maxIdle value=5 /
property name=maxWait value=3 /
property name=validationQuery value=select id
from system_settings /
property name=logAbandoned value=false /
property name=timeBetweenEvictionRunsMillis
value=6 /
property name=numTestsPerEvictionRun value=5 /
property name=minEvictableIdleTimeMillis
value=60 /
/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

Re: Connection Closing Problem

2009-05-30 Thread Larry Meadors

Is this in a web application or standalone application?

Larry



On 5/30/09, Nathan Modrzewski nmodrzew...@eaglexm.com wrote:
 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} /
   property name=username value=${username} /
   property name=password value=${password} /
   property name=maxActive value=32 /
   property name=maxIdle value=5 /
   property name=maxWait value=3 /
   property name=validationQuery value=select id
 from system_settings /
   property name=logAbandoned value=false /
   property name=timeBetweenEvictionRunsMillis
 value=6 /
   property name=numTestsPerEvictionRun value=5 /
   property name=minEvictableIdleTimeMillis
 value=60 /
 /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


-- 
Sent from my mobile device

RE: Connection Closing Problem

2009-05-30 Thread Nathan Modrzewski

It is a standalone application. 

Also, I have tested using straight JDBC and it closes correctly.

-- Nathan

-Original Message-
From: Larry Meadors [mailto:larry.mead...@gmail.com] 
Sent: Saturday, May 30, 2009 5:08 PM
To: user-java@ibatis.apache.org
Subject: Re: Connection Closing Problem

Is this in a web application or standalone application?

Larry



On 5/30/09, Nathan Modrzewski nmodrzew...@eaglexm.com wrote:
 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} /
   property name=username value=${username} /
   property name=password value=${password} /
   property name=maxActive value=32 /
   property name=maxIdle value=5 /
   property name=maxWait value=3 /
   property name=validationQuery value=select id
 from system_settings /
   property name=logAbandoned value=false /
   property name=timeBetweenEvictionRunsMillis
 value=6 /
   property name=numTestsPerEvictionRun value=5 /
   property name=minEvictableIdleTimeMillis
 value=60 /
 /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


-- 
Sent from my mobile device

Connection Closing Problem

Re: Connection Closing Problem

RE: Connection Closing Problem

3 matches

Site Navigation

Mail list logo

Footer information