I'm trying to use the SQL processor in Orbeon Forms 3.7 beta 1, but have run into a lot of trouble.
I have a pipeline like this:
<p:pipeline xmlns:p="
http://www.orbeon.com/oxf/pipeline" xmlns:oxf="
http://www.orbeon.com/oxf/processors" xmlns:xforms="
http://www.w3.org/2002/xforms" xmlns:sql="
http://orbeon.org/oxf/xml/sql" xmlns:odt="
http://orbeon.org/oxf/xml/datatypes" xmlns:xs="
http://www.w3.org/2001/XMLSchema"> <p:param type="input" name="instance"/>
<p:param type="output" name="data"/>
<p:processor name="oxf:sql">
<p:input name="data" href="#instance" debug="true"/>
<p:input name="config">
<sql:config>
<CustomerSuggestions>
<sql:connection>
<sql:datasource>sandbox</sql:datasource>
<sql:execute>
<sql:query>select CUSTOMER_NAME from CUSTOMERS where CUSTOMER_NAME like '%A%'</sql:query>
<sql:result-set>
<sql:row-iterator>
<CustomerSuggestion><sql:get-column-value column-name="CUSTOMER_NAME" type="xs:string"/></CustomerSuggestion>
</sql:row-iterator>
</sql:result-set>
</sql:execute>
</sql:connection>
</CustomerSuggestions>
</sql:config>
</p:input>
<p:output name="data" ref="data" debug="true"/>
</p:processor>
</p:pipeline>
And I have defined my JDBC datasource in META-INF/context.xml:
<Context>
<Resource name="jdbc/sandbox" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000" user="sandbox"
password="sandbox" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sandbox"/>
</Context>
And in WEB-INF/web.xml:
<resource-ref>
<description>Sandbox HSQL DB</description>
<res-ref-name>jdbc/sandbox</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
I am sure that my HSQL database is up and running because I could use the Database Manager bundled with the hsqldb.jar to access it, using the jdbc:hsqldb:hsql protocol.
Somehow, Orbeon Forms complains about "ERROR SQLProcessor - PreparedStatement: null." In addition, I get a "ERROR ProcessorService - Exception at line 19 of oxf:/apps/my-sandbox/suggest-customers.xpl
java.sql.SQLException: No suitable driver" at line 19 of my pipeline definition.
Does somebody know what's wrong?
Locked
