Problems to connect to oracle DB

[Patxi Alba]

Hi,

I have configured a connection to oracle on my tomcat server with orbeon. But when trying to access or save a form it shows me the following error:

I have already created the structure and the user orbeon, this is the configuration of the properties-local.xml

<property

        as="xs:string"

        name="oxf.fr.persistence.provider.*.*.*"

        value="jdbc/oracle"/>

    <property 

        as="xs:anyURI"  

        name="oxf.fr.persistence.oracle.uri"

        value="/fr/service/oracle"/>

    <property 

        as="xs:string"  

        name="oxf.fr.persistence.oracle.datasource"

        value="jdbc/oracle"/>

And this is the tomcat config:

<Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true">

                    <!-- SingleSignOn valve, share authentication between web applications

             Documentation at: /docs/config/valve.html -->

                    <!--

        <Valve className="org.apache.catalina.authenticator.SingleSignOn" />

        -->

                    <!-- Access log processes all example.

             Documentation at: /docs/config/valve.html

             Note: The pattern used is equivalent to using pattern="common" -->

                    <Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" prefix="localhost_access_log" suffix=".txt" pattern="%h %l %u %t &quot;%r&quot; %s %b" />

                         <Context path="/orbeon" docBase="/orbeon" reloadable="false" override="true" allowLinking="true" crossContext="true">

                                   <Resource name="jdbc/oracle" auth="Container"

                                          type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

                                          url="jdbc:oracle:thin:@localhost:1521:xe"

                                          username="orbeon" password="sandbox" maxTotal="20" maxIdle="10"

                                          maxWaitMillis="-1"/>

                                   <ResourceLink name="jdbc/oracle"

                                         global="jdbc/oracle"

                                         type="javax.sql.DataSource" />

                              </Context>

               </Host>

Could you guide me to find the fault?

Greetings and thanks.

[Patxi Alba]

The problem is here: url="jdbc:oracle:thin:@localhost:1521:xe"

I change te localhost for my pc local IP and connect. Or another solution is modify host to localhost points to your pc local IP, not 127.0.0.1 

url="jdbc:oracle:thin:@192.168.1.130:1521:xe"

[Alessandro Vernet]

Hi falba48,

So you're saying that changing the JDBC URL solved the problem? Good. Also,
you must have changed the value of the `oxf.fr.persistence.provider.*.*.*`
property from `jdbc/oracle` to just `oracle`. And of course, just let us
know you still have a problem with this.

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/