Title | Contents | Previous | Next | Index

Chapter 4

The Informix Driver

The DataDirect Connect for JDBC Informix driver (the "Informix driver") supports:

Data Source and Driver Classes

The data source class for the Informix driver is:

com.ddtek.jdbcx.informix.InformixDataSource

See "Connecting Through Data Sources" for information on DataDirect Connect for JDBC data sources.

The driver class for the Informix driver is:

com.ddtek.jdbc.informix.InformixDriver

J2EE Connector Architecture Resource Adapter Class

The ManagedConnectionFactory class for the Informix resource adapter is:

com.ddtek.resource.spi.InformixManagedConnectionFactory

See "J2EE Connector Architecture Resource Adapters" for information about using DataDirect Connect for JDBC drivers as J2EE Connector Architecture resource adapters.

Connection String Properties

You can use the following connection properties with the JDBC Driver Manager or DataDirect Connect for JDBC data sources.

Table 4-1 lists the JDBC connection properties supported by the Informix driver, and describes each property. The properties have the form:

property=value

NOTE: All connection string property names are case-insensitive. For example, Password is the same as password.

Table 4-1. Informix Connection String Properties 

Property

Description

DatabaseName

The name of the database to be used.

InformixServer

The name of the Informix database server to which you want to connect.

MaxPooledStatements

OPTIONAL

The maximum number of pooled PreparedStatements for this connection.

The default is 0.

Password

A case-insensitive password used to connect to your Informix database. A password is required only if security is enabled on your database. If so, contact your system administrator to get your password.

PortNumber

The TCP port. The default varies depending on operating system.

ServerName

The IP address (use for DataSource connections only).

User

The case-insensitive default user name used to connect to your Informix database. A user name is required only if security is enabled on your database. If so, contact your system administrator to get your user name.

Data Types

Table 4-2 lists the data types supported by the Informix driver and how they are mapped to the JDBC data types.

Table 4-2. Informix Data Types  

Informix Data Type

JDBC Data Type

blob

BLOB

boolean

BIT

byte

LONGVARBINARY

clob

CLOB

char

CHAR

date

DATE

datetime hour to second

TIME

datetime year to day

DATE

datetime year to fraction(5)

TIMESTAMP

datetime year to second

TIMESTAMP

decimal

DECIMAL

float

FLOAT

int8

BIGINT

integer

INTEGER

lvarchar

VARCHAR

money

DECIMAL

nchar

CHAR

nvarchar

VARCHAR

serial

INTEGER

serial8

BIGINT

smallfloat

REAL

smallint

SMALLINT

text

LONGVARCHAR

varchar

VARCHAR

SQL Escape Sequences

See Appendix D "SQL Escape Sequences for JDBC" for information about the SQL escape sequences supported by the Informix driver.

Isolation Levels

Informix supports isolation levels Read Committed, Read Uncommitted, Repeatable Read, and Serializable. The default is Read Committed.

Using Scrollable Cursors

The Informix driver supports scroll-sensitive result sets, scroll-insensitive result sets, and updatable result sets.

NOTE: When the Informix driver cannot support the requested result set type or concurrency, it automatically downgrades the cursor and generates one or more SQLWarnings with detailed information.



Title | Contents | Previous | Next | Index

DataDirect Connect for JDBC User's Guide and Reference

2003, DataDirect Technologies. All rights reserved.