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
