Orbeon with oracle database

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Orbeon with oracle database

Anil Dongre

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
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon with oracle database

Alessandro Vernet
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"/>
Just checking: did you replace "server:1521/orbeon" in the  
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
Reply | Threaded
Open this post in threaded view
|

RE: Re: Orbeon with oracle database

Anil Dongre
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"/>
Just checking: did you replace "server:1521/orbeon" in the
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
Reply | Threaded
Open this post in threaded view
|

Re: RE: Re: Orbeon with oracle database

Alessandro Vernet
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