You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by Geoff Howard <co...@leverageweb.com> on 2003/01/23 22:24:43 UTC
database reader and hsql
I've been working with Chris Haul to set up a sample of using the mod-db
actions and file uploads together to populate blobs in a database. It works
(after a few simple patches to FilePart and friends). Very cool.
However, to complete the sample I'm now trying to use the new (and very
cool) database reader to get uploaded images back out of the database, and
am having trouble.
I have
- setup the database reader component like so:
<map:reader name="databasereader"
src="org.apache.cocoon.reading.DatabaseReader"
logger="sitemap.reader.databasereader"
pool-max="32" pool-min="1" pool-grow="4">
<use-connection>personnel</use-connection>
</map:reader>
- set up a pipeline like so:
<map:match pattern="*.jpg">
<map:read type="databasereader"
src="{1}"
mime-type="image/jpg">
<!-- option sitemap parameters -->
<map:parameter name="table" value="media"/>
<map:parameter name="image" value="image"/>
<map:parameter name="key" value="id"/>
</map:read>
</map:match>
I get function not supported on getBlob() from hsql result set:
DEBUG (2003-01-23) 15:57.45:999 [access]
(/cocoon/samples/databases/mod-db/110.jpg) Thread-12/AbstractEnvironment:
Reset context to file:/D:/cvs/xml-cocoon2/build/cocoon/webapp/
DEBUG (2003-01-23) 15:57.45:999 [access]
(/cocoon/samples/databases/mod-db/110.jpg) Thread-12/HttpEnvironment:
Response successfully reset
WARN (2003-01-23) 15:57.46:009 [access]
(/cocoon/samples/databases/mod-db/110.jpg) Thread-12/CocoonServlet: The
resource was not found
org.apache.cocoon.ResourceNotFoundException: DatabaseReader error::
java.sql.SQLException: This function is not supported
at org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:163)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupReader
(AbstractProcessingPipeline.java:555)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.preparePipe
line(AbstractProcessingPipeline.java:495)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(Abs
tractProcessingPipeline.java:463)
at
org.apache.cocoon.components.treeprocessor.sitemap.ReadNode.invoke(ReadNode.
java:119)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at org.apache.cocoon.Cocoon.process(Cocoon.java:600)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.java
:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.processConne
ction(Http11Protocol.java:380)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:533)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: This function is not supported
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcResultSet.getNotSupported(Unknown Source)
at org.hsqldb.jdbcResultSet.getBlob(Unknown Source)
at org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:152)
... 71 more
java.sql.SQLException: This function is not supported
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcResultSet.getNotSupported(Unknown Source)
at org.hsqldb.jdbcResultSet.getBlob(Unknown Source)
at org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:152)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupReader
(AbstractProcessingPipeline.java:555)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.preparePipe
line(AbstractProcessingPipeline.java:495)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(Abs
tractProcessingPipeline.java:463)
at
org.apache.cocoon.components.treeprocessor.sitemap.ReadNode.invoke(ReadNode.
java:119)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at org.apache.cocoon.Cocoon.process(Cocoon.java:600)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.java
:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.processConne
ction(Http11Protocol.java:380)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:533)
at java.lang.Thread.run(Thread.java:536)
java.sql.SQLException: This function is not supported
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcResultSet.getNotSupported(Unknown Source)
at org.hsqldb.jdbcResultSet.getBlob(Unknown Source)
at org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:152)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupReader
(AbstractProcessingPipeline.java:555)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.preparePipe
line(AbstractProcessingPipeline.java:495)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(Abs
tractProcessingPipeline.java:463)
at
org.apache.cocoon.components.treeprocessor.sitemap.ReadNode.invoke(ReadNode.
java:119)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:134)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:164)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:153)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:108)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:143)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:317)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:299)
at org.apache.cocoon.Cocoon.process(Cocoon.java:600)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.java
:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.processConne
ction(Http11Protocol.java:380)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:533)
at java.lang.Thread.run(Thread.java:536)
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
RE: database reader and hsql
Posted by Geoff Howard <co...@leverageweb.com>.
Weird, I'm wondering if not all messages are getting through. Right after
that message, I sent this one:
http://marc.theaimsgroup.com/?l=xml-cocoon-dev&m=104338398902705&w=2 showing
a solution using getBinaryStream (although getObject might work too). I
tested it and it all works. There's a patch at bugzilla with the whole ball
of wax - the sample and the patch for DatabaseReader here:
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16382
Let me know if you see a better way to deal with DatabaseReader, or a
problem with the solution I picked. The only drawback I could see was that
getBlob also provides a means to get the length which isn't currently needed
but could be in the future I suppose.
Geoff
> -----Original Message-----
> From: Christian Haul [mailto:haul@informatik.tu-darmstadt.de]
> Sent: Thursday, January 23, 2003 4:46 PM
> To: cocoon-dev@xml.apache.org
> Subject: Re: database reader and hsql
>
>
> Geoff Howard wrote:
> > I get function not supported on getBlob() from hsql result set:
>
> We're out of luck here. See
> http://hsqldb.sourceforge.net/doc/src/org/hsqldb/jdbcResultSet.htm
> l#getBlob(int)
>
> HSQLDB-Specific Information:
>
> Up to and including 1.7.1, HSQLDB does not support this feature.
>
> Calling this method always throws a SQLException, stating that the
> function is not supported.
>
> Perhaps doing a getObject() works. May look into that tomorrow.
>
> Chris.
>
> --
> C h r i s t i a n H a u l
> haul@informatik.tu-darmstadt.de
> fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: database reader and hsql
Posted by Christian Haul <ha...@informatik.tu-darmstadt.de>.
Geoff Howard wrote:
> I get function not supported on getBlob() from hsql result set:
We're out of luck here. See
http://hsqldb.sourceforge.net/doc/src/org/hsqldb/jdbcResultSet.html#getBlob(int)
HSQLDB-Specific Information:
Up to and including 1.7.1, HSQLDB does not support this feature.
Calling this method always throws a SQLException, stating that the
function is not supported.
Perhaps doing a getObject() works. May look into that tomorrow.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
RE: database reader and hsql
Posted by Geoff Howard <co...@leverageweb.com>.
How about the following solution: since the only use of getBlob in
DatabaseReader is to store a private Blob instance variable, and in one
place (in generate) call its getBinaryStream() method, I've modified
DatabaseReader to keep InputStream as its instance variable and use the
result set's getBinaryStream(int column) one method earlier.
- Geoff
The diff: (i'm sending it to bugzilla as part of a patch adding a mod-db
sample doing
file upload -> blob)
Index: blocks/databases/java/org/apache/cocoon/reading/DatabaseReader.java
===================================================================
RCS file:
/home/cvspublic/xml-cocoon2/src/blocks/databases/java/org/apache/cocoon/read
ing/DatabaseReader.java,v
retrieving revision 1.2
diff -u -r1.2 DatabaseReader.java
--- blocks/databases/java/org/apache/cocoon/reading/DatabaseReader.java 7
Jan 2003 23:56:09 -0000 1.2
+++ blocks/databases/java/org/apache/cocoon/reading/DatabaseReader.java 24
Jan 2003 04:35:10 -0000
@@ -53,7 +53,6 @@
import java.io.BufferedInputStream;
import java.io.IOException;
import java.io.InputStream;
-import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
@@ -100,7 +99,7 @@
private ComponentSelector dbselector;
private String dsn;
private long lastModified = System.currentTimeMillis();
- private Blob resource = null;
+ private InputStream resource = null; // because HSQL doesn't yet
implement getBlob()
private Connection con = null;
private DataSourceComponent datasource = null;
private boolean doCommit = false;
@@ -149,7 +148,7 @@
Request request = ObjectModelHelper.getRequest(objectModel);
if (this.modifiedSince(set, request, response)) {
- this.resource = set.getBlob(1);
+ this.resource = set.getBinaryStream(1);
if (this.resource == null) {
throw new ResourceNotFoundException("There is no
resource with that key");
@@ -299,7 +298,7 @@
throw new SQLException("The Blob is empty!");
}
- InputStream is = new
BufferedInputStream(this.resource.getBinaryStream());
+ InputStream is = new BufferedInputStream(this.resource);
long expires = parameters.getParameterAsInteger("expires", -1);
> -----Original Message-----
> From: Geoff Howard [mailto:cocoon@leverageweb.com]
> Sent: Thursday, January 23, 2003 5:21 PM
> To: cocoon-dev@xml.apache.org; haul@informatik.tu-darmstadt.de
> Subject: RE: database reader and hsql
>
>
> aargh - I was afraid of that. from the hsql docs:
>
> getBlob
> public java.sql.Blob getBlob(int i)
> throws java.sql.SQLException
>
> Up to and including 1.7.1, HSQLDB does not support this feature.
> Calling this method always throws a SQLException, stating that
> the function
> is not supported
>
> it does support
>
> public java.io.InputStream getBinaryStream(int columnIndex) though.
>
> > -----Original Message-----
> > From: Geoff Howard [mailto:cocoon@leverageweb.com]
> > Sent: Thursday, January 23, 2003 4:25 PM
> > To: cocoon-dev@xml.apache.org
> > Subject: database reader and hsql
> >
> >
> > I've been working with Chris Haul to set up a sample of using the mod-db
> > actions and file uploads together to populate blobs in a
> > database. It works
> > (after a few simple patches to FilePart and friends). Very cool.
> >
> > However, to complete the sample I'm now trying to use the new (and very
> > cool) database reader to get uploaded images back out of the
> database, and
> > am having trouble.
> >
> > I get function not supported on getBlob() from hsql result set:
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
RE: database reader and hsql
Posted by Geoff Howard <co...@leverageweb.com>.
aargh - I was afraid of that. from the hsql docs:
getBlob
public java.sql.Blob getBlob(int i)
throws java.sql.SQLException
Up to and including 1.7.1, HSQLDB does not support this feature.
Calling this method always throws a SQLException, stating that the function
is not supported
it does support
public java.io.InputStream getBinaryStream(int columnIndex) though.
> -----Original Message-----
> From: Geoff Howard [mailto:cocoon@leverageweb.com]
> Sent: Thursday, January 23, 2003 4:25 PM
> To: cocoon-dev@xml.apache.org
> Subject: database reader and hsql
>
>
> I've been working with Chris Haul to set up a sample of using the mod-db
> actions and file uploads together to populate blobs in a
> database. It works
> (after a few simple patches to FilePart and friends). Very cool.
>
> However, to complete the sample I'm now trying to use the new (and very
> cool) database reader to get uploaded images back out of the database, and
> am having trouble.
>
> I have
>
> - setup the database reader component like so:
> <map:reader name="databasereader"
> src="org.apache.cocoon.reading.DatabaseReader"
> logger="sitemap.reader.databasereader"
> pool-max="32" pool-min="1" pool-grow="4">
> <use-connection>personnel</use-connection>
> </map:reader>
> - set up a pipeline like so:
> <map:match pattern="*.jpg">
> <map:read type="databasereader"
> src="{1}"
> mime-type="image/jpg">
> <!-- option sitemap parameters -->
> <map:parameter name="table" value="media"/>
> <map:parameter name="image" value="image"/>
> <map:parameter name="key" value="id"/>
> </map:read>
> </map:match>
>
> I get function not supported on getBlob() from hsql result set:
>
> DEBUG (2003-01-23) 15:57.45:999 [access]
> (/cocoon/samples/databases/mod-db/110.jpg) Thread-12/AbstractEnvironment:
> Reset context to file:/D:/cvs/xml-cocoon2/build/cocoon/webapp/
> DEBUG (2003-01-23) 15:57.45:999 [access]
> (/cocoon/samples/databases/mod-db/110.jpg) Thread-12/HttpEnvironment:
> Response successfully reset
> WARN (2003-01-23) 15:57.46:009 [access]
> (/cocoon/samples/databases/mod-db/110.jpg) Thread-12/CocoonServlet: The
> resource was not found
> org.apache.cocoon.ResourceNotFoundException: DatabaseReader error::
> java.sql.SQLException: This function is not supported
> at
> org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:163)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.s
> etupReader
> (AbstractProcessingPipeline.java:555)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.p
> reparePipe
> line(AbstractProcessingPipeline.java:495)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.p
> rocess(Abs
> tractProcessingPipeline.java:463)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.ReadNode.invoke
> (ReadNode.
> java:119)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at org.apache.cocoon.Cocoon.process(Cocoon.java:600)
> at
> org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A
> pplication
> FilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati
> onFilterCh
> ain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp
> erValve.ja
> va:260)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardConte
> xtValve.ja
> va:191)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardHostValv
> e.java:180
> )
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat
> cherValve.
> java:170)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(StandardPipeline.java:641)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv
> e.java:172
> )
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardEngine
> Valve.java
> :174)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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.pr
> ocessConne
> ction(Http11Protocol.java:380)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Thre
> adPool.jav
> a:533)
> at java.lang.Thread.run(Thread.java:536)
> Caused by: java.sql.SQLException: This function is not supported
> at org.hsqldb.Trace.getError(Unknown Source)
> at org.hsqldb.Trace.error(Unknown Source)
> at org.hsqldb.jdbcResultSet.getNotSupported(Unknown Source)
> at org.hsqldb.jdbcResultSet.getBlob(Unknown Source)
> at
> org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:152)
> ... 71 more
> java.sql.SQLException: This function is not supported
> at org.hsqldb.Trace.getError(Unknown Source)
> at org.hsqldb.Trace.error(Unknown Source)
> at org.hsqldb.jdbcResultSet.getNotSupported(Unknown Source)
> at org.hsqldb.jdbcResultSet.getBlob(Unknown Source)
> at
> org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:152)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.s
> etupReader
> (AbstractProcessingPipeline.java:555)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.p
> reparePipe
> line(AbstractProcessingPipeline.java:495)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.p
> rocess(Abs
> tractProcessingPipeline.java:463)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.ReadNode.invoke
> (ReadNode.
> java:119)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at org.apache.cocoon.Cocoon.process(Cocoon.java:600)
> at
> org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A
> pplication
> FilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati
> onFilterCh
> ain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp
> erValve.ja
> va:260)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardConte
> xtValve.ja
> va:191)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardHostValv
> e.java:180
> )
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat
> cherValve.
> java:170)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(StandardPipeline.java:641)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv
> e.java:172
> )
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardEngine
> Valve.java
> :174)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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.pr
> ocessConne
> ction(Http11Protocol.java:380)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Thre
> adPool.jav
> a:533)
> at java.lang.Thread.run(Thread.java:536)
> java.sql.SQLException: This function is not supported
> at org.hsqldb.Trace.getError(Unknown Source)
> at org.hsqldb.Trace.error(Unknown Source)
> at org.hsqldb.jdbcResultSet.getNotSupported(Unknown Source)
> at org.hsqldb.jdbcResultSet.getBlob(Unknown Source)
> at
> org.apache.cocoon.reading.DatabaseReader.setup(DatabaseReader.java:152)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.s
> etupReader
> (AbstractProcessingPipeline.java:555)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.p
> reparePipe
> line(AbstractProcessingPipeline.java:495)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.p
> rocess(Abs
> tractProcessingPipeline.java:463)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.ReadNode.invoke
> (ReadNode.
> java:119)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invok
> e(MountNod
> e.java:134)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:84)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
> Node.invok
> e(PreparableMatchNode.java:164)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
> voke(Pipel
> ineNode.java:153)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
> gNode.invo
> keNodes(AbstractParentProcessingNode.java:108)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
> nvoke(Pipe
> linesNode.java:143)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:317)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
> reeProcess
> or.java:299)
> at org.apache.cocoon.Cocoon.process(Cocoon.java:600)
> at
> org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A
> pplication
> FilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati
> onFilterCh
> ain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp
> erValve.ja
> va:260)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardConte
> xtValve.ja
> va:191)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardHostValv
> e.java:180
> )
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat
> cherValve.
> java:170)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(StandardPipeline.java:641)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv
> e.java:172
> )
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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(StandardEngine
> Valve.java
> :174)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
> text.invok
> eNext(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.pr
> ocessConne
> ction(Http11Protocol.java:380)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Thre
> adPool.jav
> a:533)
> at java.lang.Thread.run(Thread.java:536)
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org