Blobs in PostgreSQL

The user guide describes, how to store blob data [1] into database:

    <sql:execute>
        <sql:update>
            insert into test_blob_table (blob_column) values (<sql:param
select="/*" type="xs:base64Binary"/>)
        </sql:update>
    </sql:execute>

This seems to fail with PostgreSQL. See the stack trace is below. I'm
using Tomcat 5.5, PostgreSQL 8.2.5 and the JDBC driver version is
8.2-507 JDBC 3.

PostgreSQL datatype for a blob is BYTEA [2] and at least Hibernate can
use them. Have you any idea, how to make this work? If I try to use the
datatype TEXT [3] to store data as a Base64 encoded string,  which XSD
data type I shoud use to make Orbeon serialize it back to binary, when
reading it?

/Ray

[1] http://www.orbeon.com/ops/doc/processors-sql#binary-data
[2] http://www.postgresql.org/docs/8.2/static/datatype-binary.html
[3] http://www.postgresql.org/docs/8.2/static/datatype-character.html

2007-12-04 15:06:22,544 http-8080-Processor23 ERROR
webapp.ProcessorService  - Exception at oxf:/apps/myapp/data-add.xpl,
line 163, column -1
java.lang.UnsupportedOperationException
        at
org.orbeon.oxf.processor.sql.delegates.SQLProcessorGenericDelegate.setBlob(SQLProcessorGenericDelegate.java:32)
        at
org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:494)
        at
org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:542)
        at
org.orbeon.oxf.processor.sql.SQLProcessor$ForwardingContentHandler.endElement(SQLProcessor.java:634)
        at
org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:544)
        at
org.orbeon.oxf.processor.sql.SQLProcessor$ForwardingContentHandler.endElement(SQLProcessor.java:634)
        at
org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:544)
        at
org.orbeon.oxf.processor.sql.SQLProcessor$ForwardingContentHandler.endElement(SQLProcessor.java:634)
        at
org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:544)
        at
org.orbeon.oxf.processor.sql.SQLProcessor$RootInterpreter.endElement(SQLProcessor.java:304)
        at org.orbeon.oxf.xml.SAXStore.replay(SAXStore.java:173)
        at
org.orbeon.oxf.processor.sql.SQLProcessor.execute(SQLProcessor.java:268)
        at
org.orbeon.oxf.processor.sql.SQLProcessor.start(SQLProcessor.java:117)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$11.run(PipelineProcessor.java:652)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:649)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$11.run(PipelineProcessor.java:652)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:649)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.getInput(PipelineProcessor.java:140)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:89)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.IdentityProcessor$1.readImpl(IdentityProcessor.java:33)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$000(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$2.run(PipelineProcessor.java:96)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$100(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:94)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.NullSerializer.start(NullSerializer.java:31)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$11.run(PipelineProcessor.java:652)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:649)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.getInput(PipelineProcessor.java:140)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:89)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.IdentityProcessor$1.readImpl(IdentityProcessor.java:33)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$000(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$2.run(PipelineProcessor.java:96)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$100(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:94)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.IdentityProcessor$1.readImpl(IdentityProcessor.java:33)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$000(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$2.run(PipelineProcessor.java:96)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$100(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:94)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.IdentityProcessor$1.readImpl(IdentityProcessor.java:33)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$000(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$2.run(PipelineProcessor.java:96)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$100(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:94)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.TeeProcessor.access$000(TeeProcessor.java:36)
        at
org.orbeon.oxf.processor.pipeline.TeeProcessor$1.readImpl(TeeProcessor.java:59)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsDOM4J(ProcessorImpl.java:403)
        at
org.orbeon.oxf.processor.ProcessorImpl$4.read(ProcessorImpl.java:427)
        at
org.orbeon.oxf.processor.ProcessorImpl.readCacheInputAsObject(ProcessorImpl.java:470)
        at
org.orbeon.oxf.processor.ProcessorImpl.readCacheInputAsDOM4J(ProcessorImpl.java:425)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor.start(ConcreteChooseProcessor.java:186)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$11.run(PipelineProcessor.java:652)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:649)
        at
org.orbeon.oxf.processor.PageFlowControllerProcessor.start(PageFlowControllerProcessor.java:417)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$11.run(PipelineProcessor.java:652)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:649)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.getInput(PipelineProcessor.java:140)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:89)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.IdentityProcessor$1.readImpl(IdentityProcessor.java:33)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$000(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$2.run(PipelineProcessor.java:96)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$100(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:94)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.NullSerializer.start(NullSerializer.java:31)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$11.run(PipelineProcessor.java:652)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:649)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.getInput(PipelineProcessor.java:140)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:89)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.IdentityProcessor$1.readImpl(IdentityProcessor.java:33)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$000(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$2.run(PipelineProcessor.java:96)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$100(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:94)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:353)
        at
org.orbeon.oxf.processor.IdentityProcessor$1.readImpl(IdentityProcessor.java:33)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$000(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$2.run(PipelineProcessor.java:96)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.access$100(PipelineProcessor.java:66)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$1.readImpl(PipelineProcessor.java:94)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor$1.readImpl(ConcreteChooseProcessor.java:123)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.pipeline.TeeProcessor.access$000(TeeProcessor.java:36)
        at
org.orbeon.oxf.processor.pipeline.TeeProcessor$1.readImpl(TeeProcessor.java:59)
        at
org.orbeon.oxf.processor.ProcessorImpl$6.read(ProcessorImpl.java:1012)
        at
org.orbeon.oxf.processor.ProcessorImpl$ProcessorOutputImpl.read(ProcessorImpl.java:1195)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsSAX(ProcessorImpl.java:348)
        at
org.orbeon.oxf.processor.ProcessorImpl.readInputAsDOM4J(ProcessorImpl.java:403)
        at
org.orbeon.oxf.processor.ProcessorImpl$4.read(ProcessorImpl.java:427)
        at
org.orbeon.oxf.processor.ProcessorImpl.readCacheInputAsObject(ProcessorImpl.java:470)
        at
org.orbeon.oxf.processor.ProcessorImpl.readCacheInputAsDOM4J(ProcessorImpl.java:425)
        at
org.orbeon.oxf.processor.pipeline.choose.ConcreteChooseProcessor.start(ConcreteChooseProcessor.java:186)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor$11.run(PipelineProcessor.java:652)
        at
org.orbeon.oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:536)
        at
org.orbeon.oxf.processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:649)
        at
org.orbeon.oxf.processor.PageFlowControllerProcessor.start(PageFlowControllerProcessor.java:417)
        at org.orbeon.oxf.pipeline.InitUtils.runProcessor(InitUtils.java:88)
        at
org.orbeon.oxf.webapp.ProcessorService.service(ProcessorService.java:96)
        at
org.orbeon.oxf.servlet.OPSServletDelegate.service(OPSServletDelegate.java:148)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.orbeon.oxf.servlet.OPSServlet.service(OPSServlet.java:75)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
        at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:619)


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Raymond,

On Dec 4, 2007 7:53 AM, Raymond Jones <[hidden email]> wrote:
> This seems to fail with PostgreSQL. See the stack trace is below. I'm
> using Tomcat 5.5, PostgreSQL 8.2.5 and the JDBC driver version is
> 8.2-507 JDBC 3.

At this point it seems that the code is there only for Oracle and
HSQLDB. See org.orbeon.oxf.processor.sql.SQLProcessorInterpreterContext#getDelegate.
You would need to implement
org.orbeon.oxf.processor.sql.delegates.SQLProcessorGenericDelegate
just as it is done in
org.orbeon.oxf.processor.sql.delegates.SQLProcessorHSQLDBDelegate. If
you want to give it a shot, this shouldn't be too hard. Let us know if
you need any help along the way.

Alex
--
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
http://www.orbeon.com/


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws