Hi,
I have configured Orbeon with Oracle 10G (Release 2), but it is not saving anything to the database.
This is my configuration steps.
1) Have copied
"ojdbc14.jar" in D:\apache-tomcat-5.5.31\common\lib.
2) In Tomcat Context.xml, following entry is there:I have mentioned my machine name(also tried with IP Address)
<Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
validationQuery="select * from dual"
driverClassName="oracle.jdbc.OracleDriver"
poolPreparedStatements="true"
username="orbeon"
password="Password"
url="jdbc:oracle:thin:@//MACHINENAME:1521/wcmpoc"/>
3) In Orbeon web.xml file, made the following entry:
<resource-ref>
<description>DataSource</description>
<res-ref-name>jdbc/mydb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
4) In my properties-local.xml, made the following entry
<property as="xs:anyURI" name="oxf.fr.persistence.service.oracle.datasource" value="mydb"/>
<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.xyz.*.*" value="/fr/service/oracle"/>
It always save the data in its local(exist) database, not in oracle.
While publishing the form, it gives error.
2010-09-22 15:25:04,014 ERROR ProcessorService - Exception at
org.orbeon.oxf.common.OXFException: OraclePreparedStatement not found
at org.orbeon.oxf.processor.sql.delegates.SQLProcessorOracleTomcat5Delegate.getOraclePreparedStatement(SQLProcessorOracleTomcat5Delegate.java:57)
at org.orbeon.oxf.processor.sql.SQLProcessorOracleDelegateBase.setClob(SQLProcessorOracleDelegateBase.java:70)
at org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:470)
at org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endElement(SQLProcessor.java:542)
Can somebody, please help.. I am trying this from past 3-4 days.
Regards,
John
Locked
