RE: Oracle RDBMS Setup

[Rob Lapensee]

Title: Oracle RDBMS Setup

You will need to get the jdbc driver from oracle (www.oracle.com) get the classes12_01.zip (not the classes111.zip).   Then the data-sources.xml file in orion/config should have something like the following as one of the data-source entries:         <data-source                 class="com.evermind.sql.DriverManagerDataSource"                 name="user1"                 location="jdbc/OracleCoreDS"                 xa-location="jdbc/xa/OracleXADS"                 ejb-location="jdbc/Oracle"                 connection-driver="oracle.jdbc.driver.OracleDriver"                 username="user1"                 password=”password1"                 url="jdbc:oracle:thin:@(description=(address=(host=192.1.1.1)(protocol=tcp)(port=1521))(connect_data=(sid=S1)))"                 inactivity-timeout="30"         />     then use “jdbc/Oracle” as the jndi lookup to get the DataSource, then use the DataSource to get the jdbc Connection.     Regards,   Rob Lapensee Director of Technology Delfour Corporation [EMAIL PROTECTED] www.delfour.com   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lee, Se Hee Sent: Friday, November 10, 2000 1:40 PM To: Orion-Interest Subject: Oracle RDBMS Setup   How do I set up the Orion to work with Oracle? I am new to Orion (just downloaded) and try to make it to create DataSource with Oracle.. Does Orion comes with its own JDBC Driver for Oracle or should I should Oracle's driver? Thanks a lot for any comment and help.. Se Hee