ifxjdbc.jar has changed since it was created. Delete anyway?The same message appears for ifxjdbc-g.jar. Even if your response is 'yes' to remove the files, the lib directory remains with the JAR files under it. You must manually remove the lib directory.
java demo1 'jdbc:informix-sqli://mymachine:1526:INFORMIXSERVER=myserver; user=myname;password=mypasswd'When running demo programs on an NT machine, you can use double quotes or no quotes, as in the following example (a URL must be on one line):
Java demo1 jdbc:informix-sqli://mymachine:1526:INFORMIXSERVER=myserver; user=myname;password=mypasswdIf you quote the URL string using single quotes on an NT machine, you see the following messages:
ERROR: failed to connect!
MSG: No suitable driver
The following new Informix environment variables allow you to retain the old behavior (the default value of these variables is 0, which provides the new, JDBC specification-compliant mappings):
Environment Variable Setting | JDBC Data Type | Informix Data Type | Java Data Type |
IFX_SET_FLOAT_AS_SMFLOAT = 0 (new behavior) | FLOAT | FLOAT | double |
IFX_SET_FLOAT_AS_SMFLOAT = 1 (old behavior) | FLOAT | SMALLFLOAT | float |
IFX_GET_SMFLOAT_AS_FLOAT = 0 (new behavior) | REAL | SMALLFLOAT | float |
IFX_GET_SMFLOAT_AS_FLOAT = 1 (old behavior) | FLOAT | SMALLFLOAT | double |
select a, b from tab where a = ? and b = ?The 1.x or 2.0 driver would incorrectly assume that the first '?' matched the 1st column (a) in the project list and the second '?' matched the 2nd column (b) in the project list. This was an incorrect assumption, because the statement could have been as follows:
select a, b from tab where c = ? and d = ?This bug has been fixed in Version 2.2x. In cases of ambiguity, use the PreparedStatement extensions to explicitly tell the driver what the WHERE column data types is. These extensions are described in Chapter 3 of the IBM Informix JDBC Driver Programmer's Guide, Version 2.21.
The executeBatch() method fails when used twice, with the following error:
java.sql.sqlexception: number of input values does not match number of question marks
Bug # 149879
CLOB access is very slow when using the getAsciiStream() method.
Bug# 150063
The DatabaseMetaData.supportsFullOuterJoins() method returns TRUE even though we do not support right and full outer joins.
Bug # 151841
The XAResource start() method gives error if the autocommit flag is set to false.
Bug # 151971
A bulk insert to a logged database with autocommit mode set to true (default) does not work.
Bug # 152377
The executeBatch() method gives a syntax error when used with callable statement.
Bug # 152903
The incorrect date is returned if the database is queried after calling the CallableStatement cstmt.executeBatch() method.
Bug # 153011
The driver fails to report the exact position of the SQL syntax error.
Bug # 153022
The executeBatch() method fails when the target table has foreign key constraint.
Bug # 153465
The setCharacterStream() method does not work with text columns.
Bug # 153673
The column_def field of the result set from a DatabaseMetaData.getColumns() method should return null instead of empty string, even if column has no default.
Bug # 153681
Connections without a database do not work with locales set other than the default.
Bug # 154125
JDBC 2.21.JC1 fails to connect to the server using JDK 1.2.2
Bug # 154126
On HP 11.0 platform JDBC 2.21.JC1 shows incorrect autocommit behavior and
raises exception for Statement's SetQueryTimeout and Cancel methods.
Bug #103756
Collections and rows are not supported in opaque types.
Bug #116246
Silent install requires the DISPLAY environment variable to be set on UNIX machines.
Bug #118048
A core dump occurs when you attempt to install IBM Informix JDBC Driver Version 2.20.JC1A on an HP 11.00 machine that has JDK 1.21 already installed.
Bug# 144650
JDBC DRIVER GIVES WRONG RESULTS WHEN USED WITH DATABASE "EXTEND" FUNCTION. The select statement:
select extend(today, year to year), extend(today, year to month), extend(today, year to day), today from systables where tabid=1
generates:
1999-11-30 00:00:00.0 2000-10-31 00:00:00.0 2000-11-20 00:00:00.0 2000-11-20
It should be:
2000 2000-11 2000-11-20 2000-11-20
Workaround: use database casts like this:
select extend(today, year to year)::varchar(20),
extend(today, year
to month)::varchar(20),
extend(today, year
to day)::varchar(20),
today from systables where tabid=1
Bug# 145992
INCORRECT RESULT DISPLAY FOR CHINESE BIG5 CHARS RANGE (F9D6~F9FE) This bug is caused because the Sun JDK does not support Chinese Big5+ character encoding. On my request to the Sun's engineer has filed this bug against Sun JDK which will get fixed in the new JDK release. For tracking purposes you can check the status of bug# 4426470 at http://java.sun.com/jdc There is another bug#4421440 n Sun's bug database which is an RFE (request for enhancement) for Java to support Big5+.
Bug# 150201
SETCLOB & SETBLOB ON AN INSERT STATEMENT DOES NOT ALWAYS INSERT THE CLOB; WHEN THE OBJECT IS AN IFXCBLOB, ONLY THE LOCATOR IS INSERTED For example, say a user has inserted a clob and then wants to make a copy of that clob. So they select back the first copy and perform an insert passing the clob they got from a rs.getClob. Instead of having two copies of the data, they have two references to the same data. So, when they later update what they think is data specific to one of the rows, they will find that data associated with the other row has changed as will. This is by design and this behavior will be documented. To keep this from happening use the data from the first CLOB / BLOB to instantiate a new CLOB / BLOB. See the server documentation on BLOB / CLOB and Locator support.
Bug # 153843
On Windows 95/98/ME, the InstallShield program for IBM Informix JDBC Driver incorrectly checks for Administrator privileges.
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:
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..