ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: No operations allowed after connection closed.
Date Sun, 16 Oct 2005 15:40:10 GMT
You might want to consider configuring a validation query (a.k.a. ping
query). Your connections are probably being invalidated by some policy (e.g.
timeout).

Clinton


On 10/15/05, Oak McIlwain <oak_mcilwain@yahoo.com> wrote:
>
> I have just uploaded a web app to a server and I am getting an
> intermittent exception as follow:
>   --- The error occurred in persistence/sqlmaps/Property.xml.
> --- The error occurred while executing query.
> --- Check the SELECT * FROM Miem_Property WHERE Pty_Property_ID = ? .
> --- Check the SQL Statement (preparation failed).
> --- Cause: java.sql.SQLException: No operations allowed after connection
> closed.
> Caused by: java.sql.SQLException: No operations allowed after connection
> closed.
> com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(
> SqlMapDaoTemplate.java:164)
> persistence.sqlmapdao.PropertySqlMapDao.getProperty(Unknown Source)
> sun.reflect.GeneratedMethodAccessor298.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:585)
> com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> $Proxy29.getProperty(Unknown Source)
> service.PropertyService.getProperty(Unknown Source)
> action.view.ViewProperty.execute(Unknown Source)
> org.apache.struts.action.RequestProcessor.processActionPerform(
> RequestProcessor.java:419)
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java
> :224)
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1192)
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:412)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
>  The sql is valid and works fine but ever since I uploaded it this has
> been happening every 15 or so requests.
>  OS: Linux
> Mysql : 4.1.13
> Java: 1.5.0
> Connector/j: mysql-connector-java-3.2.0-alpha-bin (having tried many
> others with similar results)
>  Any help would be much appreciated !
>
> ------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/>
>
>

Mime
View raw message