1
Before You Install

Before you install Connect JDBC, you need to verify that you have a supported version of the database and that your system meets certain requirements.

This chapter covers the following topics:

• Supported Databases

• System and Product Requirements

• Evaluation Installations

Supported Databases

Table 1-1 shows the databases supported by each Connect JDBC driver.

Table 1-1 Databases Supported by Connect JDBC

Driver	Supported Databases
DB2	DB2 Universal Database versions 6 and 7 for Windows NT, Windows 2000, and UNIX, including Linux DB2 for OS/390, versions 5.x, 6.x, and 7.1 (7.1 functionality not exposed)
Informix	Informix Dynamic Server 9.x and 2000 for Windows and UNIX
SQL Server	SQL Server 7.0 and SQL Server 2000 for Windows
Sybase ASE	SQL Server System 11 and Adaptive Server 11.5 and higher for Windows and UNIX

System and Product Requirements

A complete installation of the Connect JDBC Driver Pack, including documentation, requires approximately 7 MB of hard disk space.

Table 1-2 lists the product requirements for using Connect JDBC.

Table 1-2 Product Requirements for Connect JDBC

For applications using...	Product Requirements
JDBC 1.22 API	JDK 1.1.x or higher compatible JVM
JDBC 2.0 Core API	JDK 1.2 or higher compatible JVM
JDBC 2.0 Optional Package	JDK 1.2 or higher compatible JVM Also, the following APIs are required and are supplied with Connect JDBC: JDBC Optional Package 2.0 JNDI 1.2

DataDirect Connect JDBC Driver

A customized version of the DataDirect Connect JDBC driver is shipped with Oracle9iAS to provide connectivity to non-Oracle databases. Do not use the DataDirect Connect JDBC driver outside of Oracle9iAS. You should refer to standard DataDirect documentation and release notes for technical information on the DataDirect JDBC driver. However, it is important to note the differences between the standard DataDirect JDBC driver and this customized version:

1. The customized DataDirect driver jar files use the YM prefix. The following DataDirect jar files are distributed with Oracle9iAS:

   YMbase.jar  YMinformix.jar  YMsqlserver.jar  YMutil.jar YMdb2.jar  
   YMsybase.jar
   
   

2. The URL sub-protocol prefix is oracle. When you connect, use the correct sub-protocol. For example:

   jdbc:oracle:db2://server1:1433
   
   

3. The package names are com.oracle.ias.

4. The vendor message prefix is [oias].

5. The customized DataDirect driver is configured to run within the Oracle9iAS product. Attempting to use the customized DataDirect JDBC driver outside Oracle9iAS, will yield the following exception:

   java.sql.SQLException: [oias][... JDBC Driver]
   
   

This driver is locked for use with embedded applications.

Evaluation Installations

The installer allows you to install all of the Connect JDBC drivers for a 30-day evaluation.