this error comes WHEN you try to read from the Result Set after result set OR statement OR connection is closed for the query fired.
HTH ----- Original Message ----- From: "Jeff Kilbride" <[EMAIL PROTECTED]> To: "Struts User" <[EMAIL PROTECTED]> Sent: Saturday, March 29, 2003 9:11 AM Subject: Struts In Action - Artimus 1.0 example - SQLException > Hi All, > > I'm working my way through the Artimus example in "Struts In Action". I was > able to create the resources and I can see the tables in my MySQL database. > The "Add Article" and "Find articles by [Title | Author | Content]" > functions work, but the "Find articles by ID" and "List articles posted..." > functions, as well as clicking on a found article link, all produce the same > SQLException: > > ---------------------------- > java.sql.SQLException: Operation not allowed after ResultSet closed > at com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:3580) > at com.mysql.jdbc.ResultSet.next(ResultSet.java:2424) > at > org.apache.commons.scaffold.sql.ResultSetUtils.getCollection(Unknown Source) > at > org.apache.commons.scaffold.sql.StatementUtils.getCollection(Unknown Source) > at > org.apache.commons.scaffold.sql.StatementUtils.getCollection(Unknown Source) > at org.apache.commons.scaffold.sql.AccessBase.findCollection(Unknown > Source) > at org.apache.artimus.article.Access.findAll(Unknown Source) > at org.apache.artimus.CreateResources.execute(Unknown Source) > at org.apache.struts.scaffold.ProcessAction.executeLogic(Unknown > Source) > at org.apache.struts.scaffold.BaseHelperAction.executeLogic(Unknown > Source) > at org.apache.struts.scaffold.BaseAction.execute(Unknown Source) > at org.apache.struts.scaffold.BaseAction.perform(Unknown Source) > at > org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.ja > va:1787) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:165) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) > at > com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:9 > 6) > at com.caucho.server.http.Invocation.service(Invocation.java:315) > at > com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) > at > com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:22 > 5) > at > com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:10 > 6) > at > com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:83 > ) > at > org.apache.struts.tiles.ActionComponentServlet.doForward(ActionComponentServ > let.java:389) > at > org.apache.struts.tiles.ActionComponentServlet.processActionForward(ActionCo > mponentServlet.java:109) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1596) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:165) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) > at > com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:9 > 6) > at com.caucho.server.http.Invocation.service(Invocation.java:315) > at > com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) > at > com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) > at > com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164) > at com.caucho.server.TcpConnection.run(TcpConnection.java:139) > at java.lang.Thread.run(Thread.java:536) > ---------------------------- > > Has anyone seen this before? > > Thanks, > --jeff > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]