RE: Setting Up JDBC driver for Oracle database

[elephantwalker]

Mong,

Here's a data-sources.xml I use with 8i, I don't know if it will work with
8, though:

<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources"
"http://www.orionserver.com/dtds/data-sources.dtd";>

<data-sources>

        <data-source
                class="com.evermind.sql.DriverManagerDataSource"
                name="ora data-source"
                location="jdbc/MyDS"
                xa-location="jdbc/xa/MyXADS"
                ejb-location="jdbc/MyDS"
                connection-driver="oracle.jdbc.driver.OracleDriver"
                username="scott"
                password="tiger"
                url="jdbc:oracle:thin:@mymachine:1521:ora"
                inactivity-timeout="30"
                schema="database-schemas/oracle.xml"
        />
</data-sources>

Regards,

the elepantwalker



-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mong Kon Mo
Sent: Friday, June 29, 2001 4:58 PM
To: Orion-Interest
Subject: Setting Up JDBC driver for Oracle database


Hello,

I am trying setup Orion to communicate with an Oracle 8.0.5.1 database.
I've obtained the JDBC drivers from Oracle, but I'm confused about what
I should be doing next.  The Orion documentation says I need to copy the
driver to the Orion\lib directory and add a data source in
data-sources.xml; but what fields do I change and what values should I
use?

Can anyone, perhaps someone who uses Orion and Oracle, help clear up
this process for me?


Thanks in advance,

Mong Kon Mo