Problems to connect to oracle DB

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

Problems to connect to oracle DB

falba48
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.

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/34a6296d-abb1-4fa7-9906-5121e6f9f225o%40googlegroups.com.
Reply | Threaded
Open this post in threaded view
|

Re: Problems to connect to oracle DB

falba48
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"

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/98933137-af2f-4e6b-b0bf-06bc68a776e6o%40googlegroups.com.
Reply | Threaded
Open this post in threaded view
|

Re: Problems to connect to oracle DB

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

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/1592626603526-0.post%40n4.nabble.com.
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet