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