hi , More info:
1. how do i specify the Oracle SID for the database connection ? I do not use global names for Oracle. Just straight SQL like login as in: sqlplus test/[EMAIL PROTECTED] for my oracle db which sits on another machine (192.168.10.1). My install for Apache tomcat was for Standalone. 2. Which web.xml do i edit for specifying the datasources. The web.xml in oxf-2.2/WEB-INF directory ? Also do i delete the datasource declaration which was already there or do i add another <resources-ref> ? ----- Original Message ----- From: "Tony Tay" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 24, 2004 10:42 AM Subject: Setting up Oracle as a datasource > hi > > I must be doing something wrong. I restarted after making changes to > tomcat1-4.27/config/server.xml file. Thanks for helping. Am new to this > bit. > > This is what i did: > > I used server.xml in tomcat-4.1.27/conf/ directory and made the following > changes: > > </ResourceParams> > <parameter> > <name>driverClassName</name> > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:oracle:oci:@192.168.10.1</value> > </parameter> > <parameter> > <name>username</name> > <value>test</value> > </parameter> > <parameter> > <name>password</name> > <value>test<value/> > </parameter> > </ResourceParams> > > > I overwrote the original (show below with the above): > > <ResourceParams name="jdbc/db"> > <parameter> > <name>factory</name> > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>org.hsqldb.jdbcDriver</value> > </parameter> > <parameter> > <name>url</name> > > <value>jdbc:hsqldb:http://localhost:8080/oxf/db</value> > </parameter> > <parameter> > <name>username</name> > <value>sa</value> > </parameter> > <parameter> > <name>password</name> > <value/> > </parameter> > </ResourceParams> > > > > > Today's Topics: > > > > 1. Re: oracle database and keyboard issues (Erik Bruchez) > > > > > > ---------------------------------------------------------------------- > hi, > > > > > Message: 1 > > Date: Fri, 12 Mar 2004 14:06:45 -0800 > > From: Erik Bruchez <[EMAIL PROTECTED]> > > Subject: Re: oracle database and keyboard issues > > To: OXF Users <[EMAIL PROTECTED]> > > Message-ID: <[EMAIL PROTECTED]> > > Content-Type: text/plain; charset=us-ascii; format=flowed > > > > Tony, > > > > 1. Regarding connecting to Oracle: you have to set a datasource as > > usual in your app server. For example in Tomcat, you would have > > something like this in your context: > > > > <Resource name="jdbc/db" auth="Container" type="javax.sql.DataSource"/> > > <ResourceParams name="jdbc/db"> > > <parameter> > > <name>username</name> > > <value>scott</value> > > </parameter> > > <parameter> > > <name>password</name> > > <value>tiger</value> > > </parameter> > > <parameter> > > <name>driverClassName</name> > > <value>oracle.jdbc.driver.OracleDriver</value> > > </parameter> > > <parameter> > > <name>url</name> > > <value>jdbc:oracle:oci:@rosaura</value> > > </parameter> > > </ResourceParams> > > > > The UBL example currently is only an illustration of XForms > > capabilities. It does not connect to a database. To do so, you will > > have to write a "save" action to save the current data to the > > database, and another pipeline to read data from it. The simple > > Address Book example is a good start as it does similar things. An > > earlier posting on the list explains how to use that example with > > Oracle. > > > > Where can i make the above config changes ? > > > _______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
