I. OVERVIEW OF RELEASE NOTES

II. SQLJ REFERENCE IMPLEMENTATION

III. SUPPORTED PLATFORMS

IV. INFORMIX SERVER COMPATIBILITY

V. SUPPORTED FEATURES

VI. ON-LINE USER'S GUIDE

VII. SAMPLE PROGRAMS

VIII. KNOWN PROBLEMS

IX. FIXED PROBLEMS

The purpose of these release notes is to make you aware of any special actions required to configure and use 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 "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 Informix Embedded SQLJ
• Database administrators who control access to Informix Dynamic Server databases
• Developers who write applications using Informix Embedded SQLJ

Version 1.01 of Informix Embedded SQLJ is based on the SQLJ Reference Implementation Version 1.011. See the SQLJ Web site, www.sqlj.org, for standards' specifications, documentation, tutorials, the Reference Implementation software, and many other resources.

Version 1.01 of Informix Embedded SQLJ was compiled with Version 1.2 of the JavaSoft Java Development Kit (JDK) on Solaris 2.5.1. This product has been tested on Solaris and Windows NT, working with the Type 4 Informix JDBC Driver, Version 2.0, which works on all Informix supported platforms.

Your Informix Embedded SQLJ programs use Informix JDBC Driver to access Informix database servers. The following versions of Informix database servers are compatible with Informix JDBC Driver:

• Informix Dynamic Server, Version 7.x
• Informix Dynamic Server, Workgroup and Developer Editions, Version 7.x
• Informix Dynamic Server with Advanced Decision Support and Extended Parallel Options, Version 8.x
• Informix Dynamic Server with Universal Data Option, Version 9.x
• 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.

JDBC 1.2 features are supported in this release. JDBC 2.0 features are not supported.

An HTML version of the "Informix Embedded SQLJ User's Guide" is included in the product distribution in the following location:

$IFXJHOME/doc/release/sqlj/index.html

$IFXJHOME refers to your Informix Embedded SQLJ and Informix JDBC Driver installation directory.

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 Informix Embedded SQLJ and Informix JDBC Driver are correctly installed. These sample programs are modified and updated versions of the examples included in the "Informix Embedded SQLJ User's Guide."

This section describes known problems with this release of 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 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.

Translator now correctly prompts for password when you invoke ifxsqlj for on-line semantics checking, specifying the -user flag but omitting -password.