Mong,
The Oracle driver should come with Oracle. If you do a search in the
oracle directory you should find a file call classes12.zip, copy that to the
orion/lib directory. Here is an Oracle data source that works and I am
using right now (This should be your data-sources.xml in the orion/config
directory).
<?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="Oracle"
schema="database-schemas/oracle.xml"
location="jdbc/OracleCoreDS"
xa-location="jdbc/xa/OracleXADS"
ejb-location="jdbc/OracleDS"
max-connections="10"
pooled-location="jdbc/OracleDS"
connection-driver="oracle.jdbc.driver.OracleDriver"
username="scott"
password="tiger"
url="jdbc:oracle:thin:@<your server name or IP>:1521:test"
inactivity-timeout="30"
/>
</data-sources>
Good Luck
Doug
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mong Kon Mo
Sent: Friday, June 29, 2001 6: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
