Release Notes for IBM Informix JDBC Driver 2.21.JC4

March 2003

Table of Contents

  1. Overview of Release Notes
  2. IBM Informix Dynamic Server Compatibility
  3. Configuration
  4. New Features
  5. Database Connections in the Demo Programs
  6. Fixed Problems
  7. Known Problems
  8. Limitations
  9. XML Parser
  10. Acknowledgements

I. Overview of Release Notes

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. In addition, this file contains information about known bugs and their workarounds. 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, Version 2.21, 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.

II. IBM Informix Dynamic Server Compatibility

IBM Informix JDBC Driver 2.21 is compatible with the following server versions:

III. Configuration

To use the IBM Informix JDBC Driver directly, you must have a JDK 1.2 (or later) package on your platform. Please refer to http://java.sun.com/products/jdbc/ for details.

IV. New Features

IBM Informix JDBC Driver Version 2.21 includes new features, each of which is fully documented in the IBM Informix JDBC Driver Programmer's Guide.

V. Database Connections in the Demo Programs

Except for the pickaseat demo, the examples listed in the IBM Informix JDBC Driver Programmer's Guide, Version 2.21, 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.

VI. Fixed Problems

PTS #                                                  Problem Short Description

156725

JDBC BATCHINSERT HANGS WHEN SIZE OF DATA TO BE INSERTED EXCEEDS FET_BUF_SIZE

156771

SELECTING FROM A TABLE WITH LVARCHAR COLUMN WHICH HAS CONTROL CHARS DATA SUCH AS \N\T\B\R\'\" RETURNS INCORRECT RESULTS

157148

IN USING JDBC, THE BLOB DATA ISN'T LOADED IN THE SBSPACE WHERE THE TABLE IS SAYING (PUT COL IN SBSPACE).

157280

JDBC NEEDS TO IMPLEMENT THE NEW SQLI PROTOCOL MECHANISM BEING IMPLEMENTED BY SERVER FEATURE 155341.

157293

IMPLEMENT SETREADONLY() METHOD FROM JAVA.SQL.CONNECTION INTERFACE

157454

EXECUTE FUNCTION WITH OUT PARAMETER MULTIPLE TIMES USING PREPARED CALLABLE STATEMENT FAILS AFTER FIRST EXECUTION, THROWS -9791

157476

CONVERSION TO LONG FROM INT8 PERFORMANCE ISSUE

157727

SUPPORTING 32K LVARCHAR (FEA#151525 FROM IDS9.40)

157818

JDBC DRIVER, ROW DATA TYPE AS OUT PARAMETER IN CALLABLESTATEMENT RETURN NULL.

157818

JDBC DRIVER, ROW DATA TYPE AS OUT PARAMETER IN  CALLABLESTATEMENT RETURN NULL.

157819

JDBC DRIVER, JDBC CLIENT HANGS WHEN USING DISTINCT OR MULTISET DATA TYPE AS OUT PARAMETER

157836

JDBC DRIVER 2.2 INTERVAL DATA TYPE AS OUT PARAMETER IN CALLABLESTATEMENT GET AN ERROR.

157838

FEA 154442 JDBC TEMP BRANCH, CALLABLESTATEMENT REGISTEROUTPARAMETERS()/ SETNULL() NOT WORK FOR SOME DATA TYPE

158045

METADATA TEMP TABLES ARE CREATED WITH LOGGING TURNED ON CAUSING A PERFORMANCE PROBLEM AND MAKING IT IMPOSSIBLE TO USE JDBC IN AN HDR PAIR

158056

JDBC DRIVER CALLS BITSET CLASS CLEAR() METHOD WHICH DOESN'T EXIST IN JDK 1.2.2.

158057

JDBC DRIVER HAS A PROBLEM CLOSING CONNECTIONS. IT ERRORS OUT AT COM.INFORMIX.JDBC.IFXSQLICONNECT.CLOSE

158158

JDBC DRIVER RETURNS WRONG OR AMBIGUOUS CLASS NAME FOR BYTE DATA TYPE WHEN GETPARAMETERMETADATA() IS DONE FOR IT.

158174

THE JDBC DRIVER NEEDS TO SUPPORT THE SQL-99 CROSS JOIN FEATURE THAT IS BEING SUPPORTED IN THE 9.40 SERVER (PTS #153097)

158199

JDBC DRIVER RETURNS NULLABLE=1 FOR SERIAL AND SERIAL8 DATATYPES. SERIAL AND SERIAL8 DATA TYPES CANNOT BE NULL. SO NULLABLE MUST BE 0.

158261

WHEN GETPARAMETERMETADATA() IS RUN AGAINST ANY SERVER OTHER THAN 9.40, ERROR -79700 IS THROWN. THIS IS NOT THE CORRECT ERROR MESSAGE.

158315

CALLABLESTATEMENT.GETDATE(INT PARAMETERINDEX, CALENDAR CAL) RETURNS INCORRECT RESULTS

158337

XA TRANASACTION COMMIT HANGS WHEN A SECOND THREAD IS WAITING ON THE COMMIT

158341

REGISTEROUTPARAMETER(INDEX, JAVA.SQL.TYPES.BIT) INCORRECTLY MAPS TO SERVER DATA TYPE CHAR

158348

NO CONVERSION BETWEEN DB AND CLIENT USING UNICODE WHILE FETCHING LVARCHAR AND TEXT COLUMNS

158433

(TIME)CALLABLESTATEMENT.GETOBJECT() GIVES JAVA.LANG.CLASSCASTEXCEPTION: JAVA.SQL.TIMESTAMP FOR JAVA.SQL.TIME DATATYPE

158441

INSERTING STRING OF LENGTH > 128 IN VARCHAR COLUMN DURING A BULK INSERT ( EXECUTEBATCH WITH IFX_USEPUT = 1) THROWS JAVA.LANG.NEGATIVEARRAYSIZEEXCEPTI

158475

STMT.EXECUTEQUERY("SELECT LONGVALUE FROM REPRO_LONG") RETURNS WRONG RESULTS

158477

SQLEXCEPTION IN METHOD SETSTRING WHEN INSERTING IN TEXT FIELD

158601

JDBC MANUAL PAGE C-2 : INCORRECT DATA TYPE MAPPINGS, TIME SHOULD BE MAPPED TO DATETIME HOUR TO SECOND, TIMESTAMP SHOULD BE DATETIME YEAR TO FRACTION(5

158622

JDBC DOES NOT CONNECT TO DATABASE CREATED WITH DB_LOCALE=JA_JP.SJIS

158623

PREPARED STATEMENT IN JDBC WITH LITERAL DOUBLE QUOTES LEADS TO EXCEPTION

158624

GETCHARACTERSTREAM ON CLOB CAUSES SEGV

158644

A QUERY WITH INTO TEMP CLAUSE USING THE EXECUTEQUERY() JAVA METHOD CAUSES A -79750 ERROR

158781

WHEN USING IFX_USEPUT,STATUS ARRAY RETURNED BY EXECUTEBATCH WHEN INSERTING FIXED LENGTH ROWS DIFFERS FROM THE STATUS ARRAY RETURNED FOR VARIABLE LENGT

158926

JDBC NEEDS TO IMPLEMENT SUPPORT FOR THE NEW SERVER FEATURE 151098 - DESCRIBE INPUT, DYNAMIC QUERY EXTENSION, VIA PARAMETERMETADATA

159358

NULL POINTER EXCEPTION USING PREPARED STATEMENT MULTIPLE TIMES

159633

LVARCHAR DISPLAYS INCORRECT JAPANESE DATA VIA JDBC, WHEN DB_LOCALE IS SJIS-S AND CLIENT_LOCALE IS UJIS

159757

JDBC: SETCHARACTERSTREAM ON CLOB CAUSES SQLEXCEPTION: CAN'T CONVERT FROM NULL

159774

CANNOT CACHE PREPARED STATEMENT ACROSS XA TRANSACTION.  THIS BUG IS ENTERED ON BEHALF OF THE WEBSPHERE APPLICATION TEAM.

160232

THE VERSION OF JAVA INSTALLED ON IRIS9 IS "JAVAVM-1.3, AND THIS CAUSES JDBC TO RETURN AN ERROR: ./IDS_INSTALL[1247]:JAVA VM-1.3: BAD NUMBER

160303

CALLING IFXXARESOURCE.ISSAMERM() FROM JBOSS WITHIN A USERTRANSACTION WHICH SIMPLY MAKES CONNECTIONS GIVES A CLASSCASTEXCEPTION

 

 

 

 

VII. Known Problems

This section describes the known problems with this release of IBM Informix JDBC Driver and shows how to work around these problems. 

VIIi. Limitations

Please refer to the IBM Informix JDBC Driver Programmer's Guide, Version 2.21 for complete list of unsupported methods.

IX. XML Parser

IBM Informix JDBC Driver bundles xerces.jar along with the other driver jar files. This xerces.jar is part of the IBM XML4J version 3.2.1 parser and is developed by Apache Software Foundation (http://www.apache.org).

X. Acknowledgements

This product includes software developed by the Apache Software Foundation (http://www.apache.org/). The Apache software includes xerces.jar. The Apache copyright notice follows in its entirety.

The Apache Software License, Version 1.1 Copyright (c) 1999 The Apache Software Foundation. All rights reserved.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

  1. Redistributions of source mso-list:l3 level1 lfo10;tab-stops:list .5in'>Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
  2. Redistributions in binary mso-list:l3 level1 lfo10;tab-stops:list .5in'>Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
  3. The end-user documentation mso-list:l3 level1 lfo10;tab-stops:list .5in'>The end-user documentation included with the redistribution, if any, must include the following acknowledgment: "This product includes software developed by the Apache Software Foundation (http://www.apache.org/)." Alternately, this acknowledgment may appear in the software itself, if and wherever such third-party acknowledgments normally appear.
  4. The names "Xerces" mso-list:l3 level1 lfo10;tab-stops:list .5in'>The names "Xerces" and "Apache Software Foundation" must not be used to endorse or promote products derived from this software without prior written permission. For written permission, please contact apache@apache.org.
  5. Products derived from this software may not be called "Apache," nor may "Apache" appear in their name, without prior written permission of the Apache Software Foundation.

mso-list:l3 level1 lfo10;tab-stops:list .5in'>Products derived from this software may not be called "Apache," nor may "Apache" appear in their name, without prior written permission of the Apache Software Foundation.

THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.


This software consists of voluntary contributions made by many individuals on behalf of the Apache Software Foundation and was originally based on software copyright (c) 1999, International Business Machines, Inc., http://www.ibm.com. For more information on the Apache Software Foundation, please see http://www.apache.org.. 


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.

THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

on behalf of the Apache Software Foundation and was originally based on software copyright (c) 1999, International Business Machines, Inc., http://www.ibm.com. For more information on the Apache Software Foundation, please see http://www.apache.org.. 


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.