orbeon 4.5 DB (oracle 11g) connectivity problem

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

orbeon 4.5 DB (oracle 11g) connectivity problem

babak.naddaf@gmail.com
hello every one

We are deciding to use orbeon PE version as our form generator in a Liferay portal project. Therefore i am trying to save orbeon forms and data in the oracle Database0(11g). After following below instruction

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/oracle-and-mysql-persistence-layers

 with a PE trial version orbeon dose not save anything in database and (also there isn't any log). the tomcat application server config looks like:

 <GlobalNamingResources>
   
    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
              description="User database that can be updated and saved"
              factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
              pathname="conf/tomcat-users.xml" />
                         
        <Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource"
      initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
      driverClassName="oracle.jdbc.OracleDriver"
      poolPreparedStatements="true"
      validationQuery="select * from dual"
      testOnBorrow="true"
      username="JPA"
      password="12345678"
      url="jdbc:oracle:thin:@//192.168.100.48:1521/SOA" />
         
  </GlobalNamingResources>

and the properties-local.xml.template file is as follow:


<properties xmlns:xs="http://www.w3.org/2001/XMLSchema"
            xmlns:oxf="http://www.orbeon.com/oxf/processors">
                       
<property as="xs:string" name="oxf.fr.persistence.provider.*.*.*" value="oracle"/>
<property as="xs:string" name="oxf.fr.persistence.oracle.datasource" value="oracle"/>
</properties>

is there any other configuration which i have forgotten?

Sincerely yours.
Reply | Threaded
Open this post in threaded view
|

Re: orbeon 4.5 DB (oracle 11g) connectivity problem

Erik Bruchez
Administrator
The properties file must be:

    properties-local.xml

NOT:

    properties-local.xml.template

I hope this helps,

-Erik
Reply | Threaded
Open this post in threaded view
|

Re: orbeon 4.5 DB (oracle 11g) connectivity problem

babak.naddaf@gmail.com
Thanks Erik it is working now.