I had that problem with 'stale' connections, and = added the ping

To sqlMapConfig

-----Original Message-----
From: James, Steven [mailto:steven.james@logicacmg.com]
Sent: 31 May 2007 05:03 PM
To: user-java@ibatis.apache.org
Subject: RE: "No operations allowed after connection closed" occasionally when using queryForList

I have had this error with mysql, check to see that you are not creating

more than one Sqlclient. Secondly you have lazy loading on so = ensure you

are not calling a get on mapped object outside of the = transaction.

-----Original Message-----

From: CppPlease [mailto:theniguy@hotmail.co.uk] =

Sent: Donnerstag, 31. Mai 2007 = 16:51

To: user-java@ibatis.apache.org

Subject: "No operations allowed after connection = closed" occasionally

when using queryForList

Hi there,

I'm using the code mentioned below (with try catches and such) = and it

seems

to work fine 90% of the time. However, occassionlly I get = a "No

operations

allowed after connection closed" error. A few more = details are below.

--- Check the SQL Statement (preparation failed). =

--- Cause: java.sql.SQLException: No operations allowed after connection

closed.

StackTrace : com.ibatis.common.jdbc.exception.NestedSQLException: =

--- The error occurred in getAllAddresses.xml. =

--- The error occurred while executing query. =

This is the code (minus try/catch)

SqlMapClient sqlMap

Reader reader =3D Resources.getResourceAsReader("sqlMapConfig.xml");

sqlMap =3D = SqlMapClientBuilder.buildSqlMapClient(reader);

List myList =3D sqlMap.queryForList("getAllAddresses", = null);

Finally this is the sqlMapConfig.xml I'm = using

<?xml version=3D"1.0" encoding=3D"UTF-8" = ?>

<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL = Map Config

2.0//EN"

= ; =

"http://www.ibatis.com/dtd/sql-map-config-2.dtd">

<settings cacheModelsEnabled=3D"true" = enhancementEnabled=3D"true"

= ; lazyLoadingEnabled=3D"true" = maxRequests=3D"32"

maxSessions=3D"10"

= ; maxTransactions=3D"5" = useStatementNamespaces=3D"false" = />

= ; <dataSource = type=3D"SIMPLE">

= ; <property name=3D"JDBC.Driver"

value=3D"com.mysql.jdbc.Driver"

= ; <property = name=3D"JDBC.ConnectionURL"

= ; =

value=3D"jdbc:mysql://mymachine:3306/mydatabase" = />

= ; <property name=3D"JDBC.Username" value=3D"myuser" = />

= ; <property name=3D"JDBC.Password" = value=3D"mypassword" />

= ; </dataSource>

= </transactionManager>

</sqlMapConfig>

I was hoping someone might be able to shed a little light on why = this

might

be happening sporadically? The database is a v.simple = mysql database

with 1

table. Also using = mysql-connector-java-3.1.7-bin.jar.

Help is much appreciated,

Thanks in advance.

View this message in context:

http://www.nabble.com/%22No-operations-allowed-after-connection-c= losed%2

2-occasionally-when-using-queryForList-tf3846980.html#a10895483

Sent from the iBATIS - User - Java mailing list archive at = Nabble.com.

This e-mail and any attachment is for authorised use by the = intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be = copied, disclosed to, retained or used by, any other party. If you are not an = intended recipient then please promptly delete this e-mail and any attachment and = all copies and inform the sender. Thank you.