![]() |
![]() |
|
|
| |
Installing WebLogic jDriver for Informix
This document tells you how to install WebLogic jDriver for Informix, BEA's Type 4 JDBC driver for Informix.
Specifically, it provides information about the following topics:
Overview
WebLogic jDriver for Informix is a Java implementation of the Java Database Connectivity (JDBC) API, the industry standard for relational database access from Java clients. It provides Java clients with direct access to the Informix database management system (DBMS).
Before You Begin
This section explains when and how you need to upgrade your software for WebLogic Server Version 6.1.
Evaluation Licenses
The WebLogic jDriver licensing functionality is included in the license file located in the directory where you installed this version of WebLogic jDriver for Informix. For example:
c:\bea\license.bea
Installation Procedure
The following instructions describe how to install WebLogic jDriver for Informix.
WebLogic Server Installations
WebLogic jDriver for Informix is bundled with your WebLogic Server distribution and is installed when you install WebLogic Server. The weblogic.jar file includes the Informix classes. You do not need to perform any steps for installation.
Installing a Standalone WebLogic jDriver for Informix
Standalone WebLogic jDrivers for Informix will be available shortly.
Using Connection Pools
If you are using WebLogic jDriver for Informix with either WebLogic Server or WebLogic Express, you can set up a pool of connections to your Informix DBMS that will be established when WebLogic Server is started. Because the connections are shared among users, these connection pools eliminate the overhead of opening a new database connection for each user.
Your application then uses a multitier (Type 3) JDBC driver, such as the WebLogic Pool, JTS, or RMI driver, to connect to WebLogic Server. WebLogic Server then uses WebLogic jDriver for Informix and one of the existing connections from the pool to connect to the Informix database on behalf of your application.
Configuring a Connection Pool with WebLogic Server
Using the Connection Pool in Your Application
To use a connection pool, you must first establish a database connection. How you establish that connection depends on whether the application in which you want to use the connection pool is a client-side or a server-side application.
Client-Side Applications
To use a connection pool in a client-side application, establish the database connection by using the WebLogic RMI driver. For more information about the RMI driver, see Using WebLogic Multitier Drivers in Programming WebLogic JDBC.
Server-Side Applications
To use a connection pool in a server-side application (such as a servlet), establish your database connection by using the WebLogic pool or jts drivers. For more information, see: Programming Tasks in Programming WebLogic HTTP Servlets
Verifying Your Connection to the Informix Database
Check your connection to the Informix database. You must have the following information:
If you do not have the required information about your database, see Determining Your Database, Hostname, and Port in the following section.
Once you have collected the required information, you can test your connection. At a command line, type:
java utils.dbping INFORMIX4 user password db@host:port
The arguments in this command line are defined as follows:
Note the syntax of the command: the database name is followed by @ (the at sign); the host name and port are separated by a colon.
For instructions for verifying your connection to a DBMS, see Testing Connections in Configuring WebLogic JDBC Features in Programming WebLogic JDBC at
.
Determining Your Database, Hostname, and Port
Before you can connect to your Informix server installation, you must answer the following questions about it:
To avoid confusion, be careful not to use the word server to mean both the machine on which your database is running and the database instance itself. In this document we avoid this pitfall by using the following terms:
To get information about the Informix server to which you want to connect, look in $INFORMIXDIR/etc/sqlhosts and find the appropriate entry under the SERVER column. The entry in this file will tell you the host name and service name—located in the far right column—for the connection. As long as you know the service name, you can determine the port number.
Then look in your /etc/services file (or, on a Windows NT platform, in \Winnt
\system32\drivers\etc\services) to find the port number associated with the service name.
References
This section provides references to documents and code examples that may helpful to you.
Documentation
Code Examples
WebLogic Server provides code examples to help you get started. Code examples are located in the samples/examples/jdbc/informix4 directory of your WebLogic Server distribution.
![]() |
![]() |
![]() |
|
Copyright © 2001 BEA Systems, Inc. All rights reserved.
|