Hi I am trying to configure Orbeon Form builder with oracle
database. I used Form Runner - Oracle Persistence Layer at
http://wiki.orbeon.com/forms/doc/developer-guide/form-runner-oracle-persistence-layer
as a guide to configure Orbeon Form builder with oracle. I am using Oracle 10g as the database. Configuration in resource\config\properties.xml file in the Orbeon Form
builder war is as below <property as="xs:anyURI"
name="oxf.fr.persistence.app.uri.*.*.*"
value="/fr/service/oracle"/> <property as="xs:anyURI"
name="oxf.fr.persistence.app.uri.orbeon.builder.form" value="/fr/service/resource"/> <property as="xs:anyURI"
name="oxf.fr.persistence.app.uri.orbeon.bookcast.form"
value="/fr/service/oracle"/> <property as="xs:anyURI"
name="oxf.fr.persistence.app.uri.Test.*.*"
value="/fr/service/oracle"/> <!--<property as="xs:anyURI"
name="oxf.fr.persistence.app.orbeon.bookcast.data.uri"
value="/fr/service/oracle"/>--> <property as="xs:anyURI"
name="oxf.fr.persistence.service.exist.uri"
value="/exist/rest/db"/> <property as="xs:anyURI "
name="oxf.fr.persistence.service.oracle.datasource"
value="oracle"/> I have deployed Orbeon Form builder in Tomcat and configured
a datasource in Tomcat. The datasource definition is as below <Resource name="jdbc/oracle"
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:@//server:1521/orbeon"/> I can create a form but cant save it nor publish it. Please let me know what I need to do to configure Orbeon
Form builder with oracle DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails. -- 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 |
Administrator
|
Anil,
On Apr 2, 2009, at 11:00 PM, Anil Dongre wrote: > I have deployed Orbeon Form builder in Tomcat and configured a > datasource in Tomcat. The datasource definition is as below > > <Resource name="jdbc/oracle" 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:@//server:1521/orbeon"/> configuration above with then name of your server, and the name of the schema you setup in Oracle? Alex -- Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise Orbeon's Blog: http://www.orbeon.com/blog/ Personal Blog: http://avernet.blogspot.com/ Twitter - http://twitter.com/avernet -- 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 |
Yes I did set url="jdbc:oracle:thin:@//server:1521/orbeon" with proper server name but it doesn't work even then.
No errors or exceptions in tomcat log. Is there any other place I need to check for log statements? Thanks and regards Anil -----Original Message----- From: Alessandro Vernet [mailto:[hidden email]] Sent: Monday, April 06, 2009 1:27 PM To: [hidden email] Subject: [ops-users] Re: Orbeon with oracle database Anil, On Apr 2, 2009, at 11:00 PM, Anil Dongre wrote: > I have deployed Orbeon Form builder in Tomcat and configured a > datasource in Tomcat. The datasource definition is as below > > <Resource name="jdbc/oracle" 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:@//server:1521/orbeon"/> configuration above with then name of your server, and the name of the schema you setup in Oracle? Alex -- Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise Orbeon's Blog: http://www.orbeon.com/blog/ Personal Blog: http://avernet.blogspot.com/ Twitter - http://twitter.com/avernet DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails. -- 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 |
Administrator
|
On Apr 6, 2009, at 1:07 AM, Anil Dongre wrote:
> Yes I did set url="jdbc:oracle:thin:@//server:1521/orbeon" with > proper server name but it doesn't work even then. > No errors or exceptions in tomcat log. Is there any other place I > need to check for log statements? Yes, you should check the orbeon.log. If you start Tomcat from your bin directory, it will be in the regular Tomcat log. Otherwise, edit resources/config/log4j.xml and change the path to the orbeon.log under the SingleFileAppender to something appropriate on your system. Alex -- Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise Orbeon's Blog: http://www.orbeon.com/blog/ Personal Blog: http://avernet.blogspot.com/ Twitter - http://twitter.com/avernet -- 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 |
Free forum by Nabble | Edit this page |