SQLTableModel problem
Ćukasz Olek <[email protected]> Sun, 23 Mar 2003 11:56:58 +0100
| Newsgroups | gmane.comp.java.tapestry.devel |
|---|---|
| Message-ID | <000401c2f12a$ece11690$9e07153e@Jenny> |
Hello! I've just tried to use table with SQLTableModel and I met the following problem: I tried the Alpha4 version of Tapestry and with MySQL database using JDBC 3.06 driver for MySQL. It fetched all records except the last one, because it has been already closed. Any help appreciated. Thanks Luke Olek 15603 [Thread-7] ERROR sql.SqlTableColumn - Cannot get the value for column: pesel java.sql.SQLException: Operation not allowed after ResultSet closed at com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:3580) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:3562) at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:1388) at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:1550) at org.apache.tapestry.contrib.table.model.sql.SqlTableColumn.getColumnValu e(SqlTableColumn.java:106) at org.apache.tapestry.contrib.table.model.simple.SimpleTableValueRendererS ource.getRenderer(SimpleTableValueRendererSource.java:91) at org.apache.tapestry.contrib.table.model.common.AbstractTableColumn.getVa lueRenderer(AbstractTableColumn.java:197) at org.apache.tapestry.contrib.table.components.TableValues.getTableValueRe nderer(TableValues.java:153) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java) at ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java) at ognl.ObjectPropertyAccessor.getPossibleProperty(ObjectPropertyAccessor.j ava) at ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java) at ognl.OgnlRuntime.getProperty(OgnlRuntime.java) at ognl.ASTProperty.getValueBody(ASTProperty.java) at ognl.SimpleNode.getValue(SimpleNode.java) at ognl.Ognl.getValue(Ognl.java) at ognl.Ognl.getValue(Ognl.java) at org.apache.tapestry.binding.ExpressionBinding.resolveProperty(Expression Binding.java:233) at org.apache.tapestry.binding.ExpressionBinding.getObject(ExpressionBindin g.java:226) at org.apache.tapestry.binding.AbstractBinding.getObject(AbstractBinding.ja va:213) at org.apache.tapestry.param.AbstractParameterConnector.getBindingValue(Abs tractParameterConnector.java:156) at org.apache.tapestry.param.ObjectParameterConnector.setParameter(ObjectPa rameterConnector.java:95) at org.apache.tapestry.param.ParameterManager.setParameters(ParameterManage r.java:126) at org.apache.tapestry.AbstractComponent.prepareForRender(AbstractComponent .java:891) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.contrib.informal.InheritInformalAny.renderComponent( InheritInformalAny.java:150) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.components.Foreach.renderComponent(Foreach.java:165) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:158 ) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.components.RenderBody.renderComponent(RenderBody.jav a:88) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.contrib.informal.InheritInformalAny.renderComponent( InheritInformalAny.java:150) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.components.Foreach.renderComponent(Foreach.java:165) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:158 ) at org.apache.tapestry.contrib.table.components.TableRows.renderComponent(T ableRows.java:231) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.components.RenderBody.renderComponent(RenderBody.jav a:88) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.contrib.informal.InheritInformalAny.renderComponent( InheritInformalAny.java:150) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:158 ) at org.apache.tapestry.contrib.table.components.TableView.renderComponent(T ableView.java:456) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.contrib.informal.InheritInformalAny.renderComponent( InheritInformalAny.java:150) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:158 ) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java: 639) at org.apache.tapestry.form.Form.renderComponent(Form.java:362) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:158 ) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:859) at org.apache.tapestry.AbstractPage.renderPage(AbstractPage.java:344) at org.apache.tapestry.engine.RequestCycle.renderPage(RequestCycle.java:423 ) at org.apache.tapestry.engine.AbstractEngine.renderResponse(AbstractEngine. java:731) at org.apache.tapestry.engine.PageService.service(PageService.java:125) at org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:85 3) at org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java :238) at org.apache.tapestry.ApplicationServlet.doGet(ApplicationServlet.java:199 ) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241 5) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:43 2) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:53 4) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:530) at java.lang.Thread.run(Thread.java:536) ------------------------------------------------------- This SF.net email is sponsored by:Crypto Challenge is now open! Get cracking and register here for some mind boggling fun and the chance of winning an Apple iPod: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en