Your change must be made within the context set for OXF, e.g. you would have something like this in your server.xml:
<Context path="/oxf"
docBase="C:/oxf-war/"
reloadable="false" override="true">
<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>
</Context>-Erik
Tony Tay wrote: > 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
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
