RELEASE NOTES
FOR
IBM Informix Embedded SQLJ 1.01.JC2
DATE: December 2001
Table of Contents
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 IBM Informix Embedded SQLJ on your computer. This file also 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 Embedded SQLJ User's Guide, which provides thorough
information about product features and behavior.
These release notes
are written for the following audience:
-
System administrators who install IBM Informix
Embedded SQLJ
-
Database administrators who control access to
IBM Informix Dynamic Server databases
-
Developers who write applications using IBM
Informix Embedded SQLJ
II. SQLJ REFERENCE IMPLEMENTATION
Version 1.01.JC2 of IBM
Informix Embedded SQLJ is based on the SQLJ Reference Implementation Version
1.0.1.1. See the SQLJ Web site, www.sqlj.org, for standard specifications,
documentation, tutorials, the Reference Implementation software, and many
other resources.
III. SUPPORTED PLATFORMS
Version 1.01.JC2 of IBM
Informix Embedded SQLJ has been tested on Solaris and Windows 2000,
working with the Type 4 IBM Informix JDBC Driver, Version 2.x, using
JDK1.2 or later.
IV. INFORMIX SERVER COMPATIBILITY
Your IBM Informix Embedded
SQLJ programs use IBM Informix JDBC Driver to access Informix database
servers. The following versions of Informix database servers are compatible
with IBM Informix JDBC Driver:
-
IBM Informix Dynamic Server, Version 7.x
-
IBM Informix Dynamic Server, Workgroup and Developer
Editions, Version 7.x
-
IBM Informix Dynamic Server with Advanced Decision
Support and Extended Parallel Options, Version 8.x
-
IBM Informix Dynamic Server with Universal Data
Option, Version 9.x
-
IBM Informix-OnLine Dynamic Server, Version
5.x
If you are
using a Version 5.x server, specify the environment variable USEV5SERVER=YES
in the database URL or property list when you make a connection to a database.
V. SUPPORTED FEATURES
JDBC 1.2 features are
supported in this release. JDBC 2.0 features are not supported.
VI. ON-LINE USER'S GUIDE
A PDF version
of the
IBM Informix Embedded SQLJ User's Guide is included in the
product distribution in the following location:
$IFXJHOME/doc/release/sqlj/sqlj.pdf
$IFXJHOME refers to
your IBM Informix Embedded SQLJ and IBM Informix JDBC Driver installation
directory.
VII. SAMPLE PROGRAMS
IBM Informix Embedded
SQLJ includes sample on-line programs in the $IFXJHOME/demo/sqlj directory.
The README file in this directory briefly explains what each of the programs
demonstrates and how to set up, compile, and run the programs. The programs
also enable you to verify that IBM Informix Embedded SQLJ and IBM Informix
JDBC Driver are correctly installed. These sample programs are modified
and updated versions of the examples included in the
IBM Informix Embedded
SQLJ User's Guide.
VIII. KNOWN PROBLEMS
This section describes
known problems with this release of IBM Informix Embedded SQLJ and shows
how to work around these problems.
In your path, you must
place your JDK/bin directory before any other directory that might contain
a directory named "java".
This is because the
IBM Informix Embedded SQLJ tools (ifxsqlj, ifxsqljc, ifxprofp) use java.lang.Runtime.exec("java
...") to execute the underlying Reference Implementation tools. This method
searches your PATH to find a Java virtual machine, "java".
If, in your PATH, any
directory containing a "java" directory exists before the intended JDK/bin
directory, the method picks up the wrong "java" directory and returns the
following error: java.lang.IOException:java:cannot execute.
IX. FIXED PROBLEMS
148095
119172
Use the following syntax to execute functions :
#sql { EXECUTE FUNCTION <function name>() INTO :<hostvar>
};