The purpose of these release notes is to make you aware of any
special actions required to configure and use the IBM® Informix® JDBC
Driver on your computer. This file also describes new features and
feature differences from earlier versions of this product and other IBM Informix products and how these differences affect
current products. This release notes document is not intended to be
all-inclusive; it should be used as an addendum to the IBM Informix JDBC Driver Programmer's Guide, which
provides thorough information about product features and behavior.
These release notes are written for Java™ programmers
who use the JDBC API to connect to IBM Informix databases via the IBM Informix JDBC Driver.
IBM Informix Server Compatibility
IBM Informix JDBC Driver 3.50 is supported with the
following server versions:
IBM Informix Dynamic Server, Version 9.2x, 9.3x, 9.4x,
10.0, 11.10, 11.50
IBM Informix Dynamic Server Express Edition, Version
10.0, 11.10, 11.50
IBM Informix Extended Parallel Server, Version 8.3x,
8.4x, 8.5x
IBM Informix Dynamic Server, Version 7.x
IBM Informix-SE, Version
5.x, 7.x
IBM Informix OnLine, Version 5.x
Configuration
You must have JRE 1.4.2 or later installed to use the IBM Informix JDBC Driver. Refer to http://java.sun.com/products/jdbc/ for
details.
The IBM Informix JDBC driver is tested to run on these platforms:
Sun 32-bit Solaris Sparc Solaris 9, 10
Sun 64-bit Solaris Sparc Solaris 9, 10
Sun 64-bit Solaris AMD64 (Opteron) Solaris 10
HP 32-bit HP-UX PA-RISC HP-UX 11i, HP-UX 11.23, 11.31
HP 64-bit HP-UX PA-RISC HP-UX 11i, HP-UX 11.23,11.31
HP 64-bit HP-UX Itanium® HP-UX
11.23PI HP-UX 11.31
IBM 32-bit AIX® PowerPC® AIX 5L™ 5.3
IBM 64-bit AIX PowerPC AIX 5L 5.3
Windows® 32-bit Windows 2003, Windows XP, Windows Vista, Windows Server
2008 (Longhorn)
IBM 64-bit Linux POWER™ (pSeries/iSeries, OpenPower®, JS20 Blades) RHEL 4, RHEL 5, SUSE SLES
10, Asianux 2.0, Asianux 3.0
IBM 64-bit Linux zSeries® RHEL 4 RHEL 5, SUSE SLES 10
Windows 64-bit (EM64T/AMD64) Windows 2003, Windows XP, Windows Vista, Windows Server
2008 (Longhorn)
MAC 64-bit MAC Intel EM64T/AMD
OS X Leopard
What's New in Version 3.50.JC3 for the Informix JDBC Driver
The Informix JDBC Driver,
Version 3.50.JC3, supports the following new feature.
Savepoint Support in JDBC Applications
Informix Dynamic Server
(IDS) now supports using savepoints within the statements of an SQL
transaction. See the IDS release notes for a description of this feature.
The following methods supplied by the JDBC 3.0 specification are
now valid in this release:
setSavepoint( )
getSavepointId( )
getSavepointName( )
releaseSavepoint( )
rollbackSavepoint( )
The methods that return multiple result sets are now the only standard
methods the JDBC 3.0 specification that are not currently supported
by the IBM Informix JDBC driver.
In addition, the following new method of the IfxConnection class
can define a savepoint whose identifier is unique in the current connection:
setSavepointUnique( )
Two new classes have been added to JDBC to support savepoint objects:
IfmxSavepoint ( Interface )
IfxSavepoint ( Savepoint class)
What's New in Version 3.50.JC1 for the Informix JDBC Driver
Changes were made in the 3.50.JC1 version of Informix JDBC driver to allow you to use the following
features of IDS, version 11.50. See the IDS release notes for that
version to learn more about the new features:
High availability cluster Connection Manager (installed as part
of IBM Informix Client SDK)
The new BIGINT and BIGSERIAL data types
Single sign-on authentication
Support for IS NULL or IS NOT NULL with expressions
J/Foundation Upgraded to JRE 5.0
The following new feature is available in the Informix JDBC Driver, 3.50.JC1.
Support for Service Name in SQLHOSTS and Connection URLs
You can now specify the service name of the Informix database server instead of the port number
when configuring connections in the sqlhosts file
or a connection URL.
Database Connections in the Demo Programs
Except for the pickaseat demo, the examples listed in the IBM Informix JDBC Driver Programmer's
Guide, Version 3.50, use the DriverManager.getConnection() method
to get a database connection. Sun Microsystems recommends using a
DataSource object instead. For more information, refer to the Sun
documentation and to the README.TXT file in the demo/pickaseat directory.
Fixed Problems
The following are required. Otherwise, the java.net library might
throw a java.net.UnknownHostException when connecting to
an IDS server using a host with an ipV6 address:
APAR IY56903 for AIX 5.1
or
APAR IY57293 for AIX 5.2
Defects fixed in Version 3.50.JC3
The following defect was corrected in version 3.50.JC3:
IC58245 JDBC-GENERIC GETPROCEDURECOLUMNS RETURNS NULL FOR COLUMN
NAME WITH A COLUMN TYPE OF 5 (RETURN)
Defects fixed in Version 3.50.JC2
The following defects were corrected in version 3.50.JC2:
IC57135 JDBC-GENERIC JDBC HANGS WHEN CONNECTING TO IDS VIA WEBLOGIC
IC56691 USING SETOBJECT() TO SET A NUMERIC VALUE TO INSERT TO
"" RAISES AN EXCEPTION.
IC57329 DATABASEMETADATA.GETPROCEDURECOLUMNS() RETURNS WRONG COLUMN_TYPE
WHEN "OUT" / "INOUT" KEYWORDS ARE USE IN ROUTINE PARAMETER LIST
Defects fixed in Version 3.50.JC1
The following defects were corrected in version 3.50.JC1:
IC56169 REQUEST JDBC DRIVER TO PARSE SERVICENAME WHEN USING SQLHOSTS
LOOKUP IMPLEMENTATION
IC56171 NULLPOINTEREXCEPTION RAISED WHEN USING SETOBJECT FOR A
PLACEHOLDER LINKED TO A FUNCTION CALL
IC49877 THE JDBC DRIVER ALLOWS THE INSERTION OF INVALID CHARACTERS
FOR A CHARACTER SET
IC52058 SYSTEM OR INTERNAL ERROR JAVA.LANG.REFLECT.INVOCATIONTARGETEXCEPTION.
ERROR: -79716 WHEN USING TEXT COLUMNS
IC52537 NEED TO REWRITE THE IFXTMPFILE CLASS TO AVOID USING THE
FILE.DELETEONEXIT() METHOD
IC52703 CODE-SET CONVERSION FOR TEXT DATA TYPES NOT WORKING
IC52997 THE ENVIRONMENT VARIABLE NAME IFX_PAD_VARCHAR IS WRONGLY
DOCUMENTED AS IFX_PADVARCHAR WITHIN JDBC 3 DOCUMENTATION
IC53003 NULLPOINTER EXCEPTION USING SETCHARACTERSTREAM() WITH
A ZERO LENGTH STRING
IC53411 JDBC: DATE/TIME OFFSET WHEN READING AND WRITING DATA
IC53557 BINDING TO FLOAT TYPE WITH THE JAVA METHOD SETDOUBLE CAUSES
PROBLEMS ON JDBC 3.00.JC3
IC54835 JAPANESE CHARACTERS ARE CORRUPTED WHEN JDBC CONNECTS TO
ONLINE 5.20
IC54850 ERROR 349 "DATABASE NOT SELECTED YET WHEN" WHEN CALLING
DATABASEMETADATA.GETUDTS IF THERE IS NO OPEN DATABASE.
IC54852 EXECUTING SIMULTANEOUS CALLS TO GETUDTS() COULD FAIL WITH
ERROR 673 "ROUTINE ROUTINE-NAME ALREADY EXISTS IN DATABASE"
Limitations
Sun JDK 1.4.2 does not support the codeset CP943.
Refer to the IBM Informix JDBC Driver Programmer's
Guide for complete list of unsupported methods.
XML Parser
The Xerces XML library xerces.jar has been
removed from distribution with the IBM Informix JDBC driver 3.10 and
later. Xerces is an open source library that is freely available for
download from the following location:
Java and all Java-based trademarks
and logos are trademarks or registered trademarks of Sun Microsystems,
Inc. in the United States, other countries, or both.
Documentation Notes
Documentation Notes and Corrections
This section describes feature and performance topics not covered
in the IBM Informix JDBC Driver Programmer's
Guide or modified since publication.
There are no known notes or corrections at this time.