Oracle8 JDBC Driver
Overview
This Connector provides access to Oracle 8 databases using Oracle's provided
JDBC driver. Please refer to your Oracle installation and documentation for a
full description of the driver. Using this driver with the Metamerge Server
requires the Oracle JDBC class library to be available. Make sure the Classes111.zip
(from the \Oracle\Ora8x\JDBC\lib) is in your Java class path, or copy the file to the "lib/ext" directory
of your Java runtime directory, or copy the file to the Metamerge\jars
directory.
Configuration
If you choose the Thin driver you do not need more than the classes111.zip
file above. This provides a pure cross-platform Java environment with no OS
dependencies. Configure an instance of the JDBC Connector with the following
values.
Parameter |
Value |
Description |
jdbcDriver |
oracle.jdbc.driver.OracleDriver |
The Oracle 8 JDBC driver |
jdbcSource |
jdbc:oracle:thin:@<host.domain>:<port>:<SID> |
Substitute <host.domain> with the IP
address or name for the Oracle server. The port (usually 1521) and SID
must also be configured. |
Note
An SQL DATE only contains a date, but the Oracle SQL DATE type may contain
both a date and a time. If you want to store a DATE value containing both a date
and a time (different from zero), you should make sure you provide an object of
type java.sql.Timestamp, as you could with this Attribute Mapping:
a = java.util.Date();
ret.value = new java.sql.Timestamp (a.getTime());
This is only available from version 1.19 of the connector (enclosed in
Metamerge 4.6.4).
See Also
Please read the documentation for the JDBC Connector for a description of additional parameters.
|