Sorry, my own fault :(
I only rewrote the key from: <key name="usr_id" type="long">
to: <key name="usr_id" type="int">
Now all works fine.
Antonio Gallardo
El Viernes, 25 de Octubre de 2002 12:36, Antonio Gallardo Rivera escribió:
> Thanks for your prompt response Chris. I am using CVS 2.1 lastest. builded
> on 24-oct-02 at 20:00 UTC. I think this is the lastest. I use CVS to update
> the sources. Also, PostgreSQL 7.2, JSDK 1.4.1
>
> Antonio Gallardo
>
> Here is the exception:
>
> Original exception : java.lang.ClassCastException at
> org.apache.cocoon.util.JDBCTypeConversions.setColumn(JDBCTypeConversions.ja
>va:354) at
> org.apache.cocoon.acting.modular.DatabaseAction.setColumn(DatabaseAction.ja
>va:609) at
> org.apache.cocoon.acting.modular.DatabaseAddAction.processRow(DatabaseAddAc
>tion.java:96) at
> org.apache.cocoon.acting.modular.DatabaseAction.processTable(DatabaseAction
>.java:398) at
> org.apache.cocoon.acting.modular.DatabaseAction.act(DatabaseAction.java:738
>) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:139) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:158) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNo
>de.java:146) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invo
>ke(PreparableMatchNode.java:166) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:158) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invo
>ke(PreparableMatchNode.java:166) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:109) at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipe
>lineNode.java:153) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:109) at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pip
>elinesNode.java:143) at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProces
>sor.java:326) at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProces
>sor.java:308) at org.apache.cocoon.Cocoon.process(Cocoon.java:595) at
> org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1034) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>nFilterChain.java:247) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>hain.java:193) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>ava:260) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>ava:191) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
>0) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>.java:170) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>2) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a:174) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> 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:405)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn
>ection(Http11Protocol.java:380) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
>va:533) at java.lang.Thread.run(Thread.java:536)
>
>
>
> java.lang.ClassCastException
>
>
>
> org.apache.cocoon.ProcessingException: Could not add record:
> java.lang.ClassCastException at
> org.apache.cocoon.acting.modular.DatabaseAction.act(DatabaseAction.java:818
>) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:139) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:158) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNo
>de.java:146) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invo
>ke(PreparableMatchNode.java:166) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:158) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invo
>ke(PreparableMatchNode.java:166) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:109) at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipe
>lineNode.java:153) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:109) at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pip
>elinesNode.java:143) at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProces
>sor.java:326) at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProces
>sor.java:308) at org.apache.cocoon.Cocoon.process(Cocoon.java:595) at
> org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1034) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>nFilterChain.java:247) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>hain.java:193) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>ava:260) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>ava:191) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
>0) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>.java:170) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>2) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a:174) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> 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:405)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn
>ection(Http11Protocol.java:380) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
>va:533) at java.lang.Thread.run(Thread.java:536) Caused by:
> java.lang.ClassCastException at
> org.apache.cocoon.util.JDBCTypeConversions.setColumn(JDBCTypeConversions.ja
>va:354) at
> org.apache.cocoon.acting.modular.DatabaseAction.setColumn(DatabaseAction.ja
>va:609) at
> org.apache.cocoon.acting.modular.DatabaseAddAction.processRow(DatabaseAddAc
>tion.java:96) at
> org.apache.cocoon.acting.modular.DatabaseAction.processTable(DatabaseAction
>.java:398) at
> org.apache.cocoon.acting.modular.DatabaseAction.act(DatabaseAction.java:738
>) ... 49 more java.lang.ClassCastException at
> org.apache.cocoon.util.JDBCTypeConversions.setColumn(JDBCTypeConversions.ja
>va:354) at
> org.apache.cocoon.acting.modular.DatabaseAction.setColumn(DatabaseAction.ja
>va:609) at
> org.apache.cocoon.acting.modular.DatabaseAddAction.processRow(DatabaseAddAc
>tion.java:96) at
> org.apache.cocoon.acting.modular.DatabaseAction.processTable(DatabaseAction
>.java:398) at
> org.apache.cocoon.acting.modular.DatabaseAction.act(DatabaseAction.java:738
>) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:139) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:158) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNo
>de.java:146) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invo
>ke(PreparableMatchNode.java:166) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTy
>peNode.java:158) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:85) at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invo
>ke(PreparableMatchNode.java:166) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:109) at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipe
>lineNode.java:153) at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.inv
>okeNodes(AbstractParentProcessingNode.java:109) at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pip
>elinesNode.java:143) at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProces
>sor.java:326) at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProces
>sor.java:308) at org.apache.cocoon.Cocoon.process(Cocoon.java:595) at
> org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1034) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>nFilterChain.java:247) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>hain.java:193) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>ava:260) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>ava:191) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
>0) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>.java:170) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>2) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a:174) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> 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:405)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn
>ection(Http11Protocol.java:380) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
>va:533) at java.lang.Thread.run(Thread.java:536)
>
> El Viernes, 25 de Octubre de 2002 08:37, Christian Haul escribió:
> > On 25.Oct.2002 -- 08:14 AM, Antonio Gallardo Rivera wrote:
> > > Hello.
> > >
> > > I am trying to insert permission into a table. The descriptor is:
> > >
> > > <table name="permisos">
> > > <keys>
> > > <key name="usr_id" type="long">
> > > <mode name="request-attr" type="all"
> > > parameter="org.apache.cocoon.components.modules.output.OutputModule:usu
> > >ar ios.usr_id[0]"/> </key>
> > > <key name="obj_id" type="long" set="master">
> > > <mode name="request-param" parameter="obj_id" type="all"/>
> > > </key>
> > > </keys>
> > > </table>
> > >
> > > The table-set is:
> > >
> > > <table-set name="usuario_y_permisos">
> > > <table name="usuarios"/>
> > > <table name="permisos" others-mode="request-attr"/>
> > > </table-set>
> > >
> > > The error I got is in the sitemap.log:
> > >
> > > Thread-4/DatabaseAction: query: INSERT INTO permisos (usr_id, obj_id)
> > > VALUES (?, ?)
> > > Thread-4/DatabaseAction: Trying to set column permisos.usr_id from
> > > request-attr using getAttribute method
> > > Thread-4/DatabaseAction: Setting column permisos.usr_id [0] 5
> > > Thread-4/DatabaseAction: Trying to set column permisos.obj_id from
> > > request-param using getAttributeValues method
> > > Thread-4/DatabaseAction: Setting column permisos.obj_id [0] 3
> > > Thread-4/DatabaseAction: Setting column permisos.obj_id [1] 2
> > > Thread-4/DatabaseAction: ====> row no. 0
> > > Thread-4/DatabaseAction: Setting column permisos.usr_id[0] to 5
> > > Thread-4/DatabaseAction: Rolling back transaction. Caused by null
> >
> > Mmmh, it looks fine so far. Could you make it throw an exception
> > ("<throw-exception>yes</throw-exception>" in config) and send me the
> > log? You are using a 2.1 CVS snapshot? JDK version? Database?
> >
> > Chris.
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
