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.
IBM Informix JDBC Driver 2.21 is compatible with the following server versions:
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.
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.
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
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 |
This section describes the known problems with this release of IBM Informix JDBC Driver and shows how to work around these problems.
Please refer to the IBM Informix JDBC Driver Programmer's Guide, Version 2.21 for complete list of unsupported methods.
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).
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:
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.