Ok, so this is a problem with either the Artimus example code or Scaffold? Any ideas for tracking it down?
Thanks, --jeff ----- Original Message ----- From: "Navjot Singh" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 7:46 PM Subject: Re: Struts In Action - Artimus 1.0 example - SQLException > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
