Here you go 1. First define new database interface (Database interface dialog)
Interface name - text name of this interface, for example, 'Oracle 9i interface'
Driver's path - one or several java libraries (jar/zip files) containing JDBC driver, for example, 'ORACLE_HOME/product/9.0.1/jdbc/lib/classes12.zip:ORACLE_HOME/product/9.0.1/jdbc/lib/nls_charset12.zip'
Driver's class - JDBC driver's java class name, for example, 'oracle.jdbc.driver.OracleDriver' 2. Then define new profile that will use this interface (Database profile dialog)
Profile name - text name of this profile, for example 'My production database'
Database URL - special formatted JDBC url for your database instance, for example, 'jdbc:oracle:thin:@hostname:1521:prod_db
User name - database username for this connection, for example, 'scott'
Password - database password for this connection, for example, 'scott' 3. If you need more profiles (for example different users or different servers) repeat step 2. If you need other interfaces Oracle 10 or Db2 for instance repeat both steps. : Can someone tell what I need to enter into the Database
: Interface Properties to configure an Oracle9i or 10g
: native database driver? I'm running the scheduler on Solaris 2.8
: and have both 9i and 10g client software installed in
: /u01/app/oracle/product/9.2.0 and /u01/app/oracle/product/10.1.0
: respectively.
|
