Orbeon Forms community mailing list

Problems to connect to oracle DB

Classic

List

Threaded

3 messages Options

falba48

Problems to connect to oracle DB

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.

falba48

Re: Problems to connect to oracle DB

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.

Alessandro Vernet

Re: Problems to connect to oracle DB

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