I had that problem with 'stale' connections, and added the ping
<property name="Pool.PingQuery" value="SELECT 1"/>
<property name="Pool.PingEnabled" value="true" />
<property name="Pool.PingConnectionsOlderThan" value="1000000" />
To sqlMapConfig
-----Original Message-----
From: James, Steven [mailto:[EMAIL PROTECTED]
Sent: 31 May 2007 05:03 PM
To: [email protected]
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:[EMAIL PROTECTED]
Sent: Donnerstag, 31. Mai 2007 16:51
To: [email protected]
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 = Resources.getResourceAsReader("sqlMapConfig.xml");
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
List myList = sqlMap.queryForList("getAllAddresses", null);
Finally this is the sqlMapConfig.xml I'm using
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config
2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd";>
<sqlMapConfig>
<settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" maxRequests="32"
maxSessions="10"
maxTransactions="5" useStatementNamespaces="false" />
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver"
value="com.mysql.jdbc.Driver"
/>
<property name="JDBC.ConnectionURL"
value="jdbc:mysql://mymachine:3306/mydatabase" />
<property name="JDBC.Username" value="myuser" />
<property name="JDBC.Password" value="mypassword" />
</dataSource>
</transactionManager>
<sqlMap resource="getAllAddresses.xml" />
</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-closed%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.
