JDBC driver 4.18.950


Contents

Overview

The JDBC driver allows Java applets (running within a web browser) or Java applications to access information from Oracle, Informix and Ingres databases on any UNIX platform.

The JDBC distribution supplied includes the JDBC driver, the Sun JDBC driver manager, and a sample Java applet and application provided as JDBC demonstrators.

The JDBC driver runs on the client device either being installed locally or downloaded from a web server. This communicates with a "server module" on the UNIX database server which is specific to a particular DBMS on a specific version of UNIX. The client device part of the JDBC driver is provided inside the self-extracting file sqlrjdbc.exe for Windows, and the tar format file sqlrjdbc.tar for UNIX. The server module (also contained in SQL-Retriever) can also be installed from the CD. Refer to the appropriate installation instructions for further information.

Additional documentation is provided with the JDBC driver and can be viewed once the driver is installed. The documentation can be accessed using the file index.htm, which located in the doc subdirectory.

 

Installing the JDBC driver on Windows

Refer to the following instructions to install the JDBC driver on Windows 95 and NT.

To install the JDBC driver on Windows 95 and NT

  1. Double-click the file sqlrjdbc.exe.
  2. Type the folder name into which the JDBC files will be extracted. For example if you are using Microsoft Internet Explorer or Microsoft Visual J++, type C:\Windows\Java (or C:\Winnt\Java for NT 4.0). If you are using Netscape Navigator, type C:\Program Files\Netscape\Navigator\Program\Java. Or if you are using the Sun Java Developers Kit, accept the default location.
  3. Click Unzip.
  4. Click Close.

If you are using Internet Explorer or Netscape Navigator, you should refer to "Setting the class path" in the JDBC driver documentation for important configuration information. If you are using Visual J++ or the Java Developers Kit, you should refer to "The class path".

Installing the JDBC driver on UNIX

Refer to the following instructions to install the JDBC driver on UNIX.

To install the JDBC driver from CD on UNIX

  1. Log in as root on the UNIX host.
  2. Mount the CD, by typing one of the following:
A list of the commands to install the JDBC driver from CD on UNIX
On this UNIX system... Type this...
DEC Digital UNIX 4.0D+ mount -t cdfs -o ro,noversion /dev/cddev cddir
HP-UX 10.01+ mount /dev/dsk/cddev cddir -r -F cdfs
IBM AIX 4.2+ mount -v cdfs -r /dev/cddev cddir
SCO OpenServer Release 5+ mount -f HS -o ro,lower /dev/cddev cddir
SCO UnixWare 2.1+ mount -F cdfs -r /dev/cdrom/cddev cddir
Siemens Sinix 5.43 mount -F cdrom -o ro /dev/cddev cddir
Silicon Graphics IRIX 5.3 mount -t iso9660 /dev/cddev cddir
SPARC Solaris 2.4+ mount -F hsfs -o ro,nrr /dev/cddev cddir

replacing cddev with the device name of the CD drive, and cddir with the name of your CD's mount directory.

  1. cd to the directory into which you want to extract the tar file's contents. For example, /usr/local/lib/netscape for Netscape Navigator, or /usr/local/java for the Java Developers Kit.
  2. Extract the files from the tar file by typing:

    tar xovf /cddir/jdbc/sqlrjdbc.tar

    For example, if your CD is mounted on /cdrom, type:

    tar xovf /cdrom/jdbc/sqlrjdbc.tar

To install the JDBC driver from tar file on UNIX

  1. Use a file transfer mechanism to transfer the tar format file sqlrjdbc.tar to a temporary directory on the UNIX system, for example /tmp. Be sure to use binary transfer mode.
  2. Log in to the UNIX system and cd to the directory into which you want to extract the tar file's contents. For example, /usr/local/lib/netscape for Netscape Navigator, or /usr/local/java for the Java Developers Kit.
  3. Extract the files from the tar file by typing:

    tar xovf /tmp/sqlrjdbc.tar

    If you did not save the tar file in the /tmp directory amend the command accordingly.

    Note that superuser (root) privilege may be required.

If you are using Netscape Navigator, you should refer to "Setting the class path" in the JDBC driver documentation for important configuration information. If you are using the Java Developers Kit, you should refer to "The class path".

Setting the JDBC driver up on a UNIX web server

Refer to the following instructions to set up the JDBC driver and sample applet on a UNIX web server. Note that in order for web browsers to use the JDBC driver for data access when obtained from the web server, the database (and therefore the driver's associated server module component) must reside on the web server.

To set up the JDBC driver from CD on a web server

  1. Log in as root on the UNIX web server.
  2. Mount the CD, by typing one of the following:
A list of commands to set up the JDBC driver from CD on a web server
On this UNIX system... Type this...
DEC Digital UNIX 4.0D+ mount -t cdfs -o ro,noversion /dev/cddev cddir
HP-UX 10.01+ mount /dev/dsk/cddev cddir -r -F cdfs
IBM AIX 4.2+ mount -v cdfs -r /dev/cddev cddir
SCO OpenServer Release 5+ mount -f HS -o ro,lower /dev/cddev cddir
SCO UnixWare 2.1+ mount -F cdfs -r /dev/cdrom/cddev cddir
Siemens Sinix 5.43 mount -F cdrom -o ro /dev/cddev cddir
Silicon Graphics IRIX 5.3 mount -t iso9660 /dev/cddev cddir
SPARC Solaris 2.4+ mount -F hsfs -o ro,nrr /dev/cddev cddir

replacing cddev with the device name of the CD drive, and cddir with the name of your CD's mount directory.

  1. Use su to become the web server administrator.
  2. cd to the directory below the document root into which you want to extract the tar file's contents.
  3. Extract the files from the tar file by typing:

    tar xovf /cddir/jdbc/sqlrjdbc.tar.

    For example, if your CD is mounted on /cdrom, type:

    tar xovf /cdrom/jdbc/sqlrjdbc.tar

To set up the JDBC driver from tar file on a web server

  1. Use a file transfer mechanism to transfer the tar format file sqlrjdbc.tar to a temporary directory on the UNIX web server, for example /tmp. Be sure to use binary transfer mode.
  2. Log in to the web server and cd to an appropriate directory below the document root into which you want to extract the tar file's contents.
  3. Extract the files from the tar file by typing:

    tar xovf /tmp/sqlrjdbc.tar

Installing the SQL-Retriever server module

Refer to the following instructions to install the SQL-Retriever server module on your UNIX database server from the CD. You must install the UNIX software in order for the JDBC driver to work.

Note that superuser (root) privilege is required to install the SQL-Retriever software.

To install the SQL-Retriever server module from CD on UNIX

  1. Log in as root on the UNIX host.
  2. Mount the CD, by typing one of the following:
A list of commands to install the SQL-Retriever server module from CD on UNIX
On this UNIX system... Type this...
DEC Digital UNIX 4.0D+ mount -t cdfs -o ro,noversion /dev/cddev cddir
HP-UX 10.01+ mount /dev/dsk/cddev cddir -r -F cdfs
IBM AIX 4.2+ mount -v cdfs -r /dev/cddev cddir
SCO OpenServer Release 5+ mount -f HS -o ro,lower /dev/cddev cddir
SCO UnixWare 2.1+ mount -F cdfs -r /dev/cdrom/cddev cddir
Siemens Sinix 5.43 mount -F cdrom -o ro /dev/cddev cddir
Silicon Graphics IRIX 5.3 mount -t iso9660 /dev/cddev cddir
SPARC Solaris 2.4+ mount -F hsfs -o ro,nrr /dev/cddev cddir

replacing cddev with the device name of the CD drive, and cddir with the name of your CD's mount directory.

  1. Change to the CD directory. For example, if your CD is mounted on /cdrom, type:

    cd /cdrom

  2. Run the setup script on the CD. Type:

    sh ./setup

    Some systems (for example, HP-UX) display filenames in UPPER CASE, followed by ";1". In this case, type sh ./SETUP\;1

  3. Follow the instructions on your screen.
  4. When Setup is complete, you can remove all files from your temporary directory.

Known problems

Please note this problem.

  1. Internet Explorer versions 3.0 and 3.01 will crash the first time they are used with the JDBC driver.