RE: Setting Up JDBC driver for Oracle database
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
RE: Setting Up JDBC driver for Oracle database
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
Re: Setting Up JDBC driver for Oracle database
data-sources data-source name=Devel One DS class=com.evermind.sql.ConnectionDataSource location=jdbc/DevelOneCoreDS pooled-location=jdbc/DevelOnePooledDS xa-location=jdbc/xa/DevelOneXADS ejb-location=jdbc/DevelOneDS schema=database-schemas/oracle.xml url=jdbc:oracle:thin:@samoa.spottedfly.com:1521:DEV1 -- change to your host and SID connection-driver=oracle.jdbc.driver.OracleDriver username=mySchemaName password=myPassword / /data-sources peace - scot Mong Kon Mo wrote: 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 -- scot weber - [EMAIL PROTECTED] - Given a choice between a folly and a sacrament, one should always choose the folly -- because we know a sacrament will not bring us closer to God and there's always a chance that a folly will. - Erasmus The only man who never makes a mistake is the man who never does anything. - Theodore Roosevelt.