Configure Oracle with OPS

Hello Everybody,

Can you please explain how to configure oracle with OPS In which xml I have to make changes and what all jars are reuqired and there paths.




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

 > Can you please explain how to configure oracle with OPS In which xml
 > I have to make changes and what all jars are reuqired and there
 > paths.

You must first get a JAR file from Oracle. This is the one I use (I am
not sure if this is the latest version):

   ojdbc14_g.jar

Put this in your Tomcat's common/lib directory, if you are using
Tomcat, or refer to the documentation of your servlet container for
other containers.

With Tomcat 5.5, you must configure a JDBC resource in your
server.xml. For example:

<Context path="/my-path" docBase="C:/my/war/" reloadable="false"
override="true">
     <Resource name="jdbc/my-jdbc-name" auth="Container"
               type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
               url="jdbc:oracle:thin:@localhost:1521:my-service-name"
               username="my-username" password="my-password"
maxActive="20" maxIdle="10" maxWait="-1"/>
</Context>

You should also have a resource declaration in your web.xml:

<resource-ref>
     <description>DataSource</description>
     <res-ref-name>jdbc/my-jdbc-name</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
</resource-ref>

(Don't blame us for the above, blame Apache, Sun or the JCP ;-)

Then from the SQL processor, you can use:

   <sql:connection>
     <sql:datasource>my-jdbc-name</sql:datasource>
     ...

-Erik

--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Eric, I am still unable to connect to the Oracle. I am getting erropr message Unable to load driver. I am trying to modify the tutorial examples. Do i have to make some changes in the configuration files like web.xml/ server.xml of the given examples.

Regards,
Saurabh



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Saurabh,

Yes you do have to make changes to those files, as I pointed out in my
first response. If you haven't made those changes and if you haven't put
the Oracle driver JAR file in the proper location, nothing will work.

BTW web.xml and server.xml are not configuration files of a particular
example, they are respectively configuration files for your web
application and your Tomcat servlet container.

-Erik

[hidden email] wrote:
> Eric, I am still unable to connect to the Oracle. I am getting erropr message Unable to load driver. I am trying to modify the tutorial examples. Do i have to make some changes in the configuration files like web.xml/ server.xml of the given examples.
>
> Regards,
> Saurabh

--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws