can't say buddy as i don't have these examples with right now. but try to look in here (in order), you will find the cause.
org.apache.artimus.article.Access.findAll() org.apache.commons.scaffold.sql.AccessBase.findCollection() org.apache.commons.scaffold.sql.ResultSetUtils.getCollection() -navjot ----- Original Message ----- From: "Jeff Kilbride" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, March 29, 2003 9:34 AM Subject: Re: Struts In Action - Artimus 1.0 example - SQLException > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
