deploying orbeon forms in WAS and Oracle DB Connectivity

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

deploying orbeon forms in WAS and Oracle DB Connectivity

sunnyramdas
Hi Team,
We have deployed Orbeon Forms in Websphere Application Server but unable to do Oracle DB connectivity using server.xml. Pls help.

Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: deploying orbeon forms in WAS and Oracle DB Connectivity

Alessandro  Vernet
Administrator
Setting up a datasource in your app server can at times be tricky. Did you get a chance to go through the information about the JDBC setup mentioned on the page linked below?

https://doc.orbeon.com/installation/websphere.html

If you did something along those lines and still experience a problem, could you tell us more about what the problem is? Are you getting an error in the orbeon.log?

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: deploying orbeon forms in WAS and Oracle DB Connectivity

sunnyramdas
Thanks for the reply.

The steps provided in the link is for deploying orbeon in WLP (Websphere Liberty Profile). I am looking forward to a good documentation/steps for doing Orbeon DB connectivity in WAS (Websphere Application Server). We have created a data source in WAS and are able to connect to Oracle Server.

But what are the changes required in orbeon configuration (say, server.xml etc) so that DB connection from application (Orbeon) to  DB Server is successfull.


Please help. Please let me know if you need more information from me.

Thanks!!
Reply | Threaded
Open this post in threaded view
|

Re: deploying orbeon forms in WAS and Oracle DB Connectivity

Alessandro  Vernet
Administrator
At the level of the application server, you need to make the data source available to Orbeon Forms through JNDI as `java:comp/env/jdbc/oracle`. At the level of Orbeon Forms, you need to edit the `properties-local.xml` and set the value if the `oxf.fr.persistence.provider.*.*.*` property to `oracle`, as described on:

https://doc.orbeon.com/form-runner/persistence/relational-db.html#with-a-single-schema

You'll let us know if this helps,

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet