StarSQL for Java v2.78 Release Notes
November 2018
StarSQL for Java is a type 4 (Direct-to-Database Pure Java) JDBC driver for DRDA access to IBM DB2 databases.
This version of StarSQL for Java supports the JDBC 3.0 API.
The following topics are addressed in these Release Notes. Refer to the StarSQL for Java Quick Start Guide for detailed information about installing StarSQL for Java for the first time, and refer to the StarSQL for Java User's Guide for detailed information about using the StarSQL JDBC driver..
- What's New in this Release
- Upgrade Considerations
- System Requirements
- Installing and Using the StarSQL for Java Driver
- Fix Pack and PTF Notes
- Known Issues
- Release History
- Contacting StarQuest
What's New in this Release
StarSQL for Java v2.7 introduces the following new features and improvements:
- Support for batch operations
- Ability to set Held Cursors per statement (in addition to the existing per-connection support)
- Additional fixes and enhancements
Upgrade Considerations
This section describes issues of interest for users who are upgrading from a prior version of StarSQL for Java.
- The minimum JRE level is now 1.5.
- SSL support is now integrated into the StarSQL_JDBC.jar file; the separate StarSQL_SSL13.jar and StarSQL_SSL14.jar files are no longer used.
System Requirements
You can install and run the StarSQL for Java driver on any computer that has a Java Virtual Machine (JVM) equivalent to the Sun JDK 1.5 or later.
To use workstation licensing on UNIX, you must install the StarLicense package for your UNIX operating system.
StarSQL for Java can connect to any of the following host databases:
- DB2 for z/OS v9 and later
- DB2 for i (formerly known as DB2/400, DB2 UDB for iSeries, and DB2 for i5/OS) running OS/400 V5R4 and later
- DB2 for Linux, UNIX, and Windows (DB2 for LUW) v9.7 and later
- Apache Derby 10.10 and later
Installing and Using the StarSQL for Java Software
- The StarSQL for Java Quick Start Guide provides step-by-step instructions for installing and using the StarSQL JDBC driver in the shortest time.
- After you've installed the software, refer to the contents, index, or search the StarSQL for Java User's Guide for the topic or issue you want to learn more about.
- Browse the StarSQL for Java technical documents at http://www.starquest.com/Supportdocs/browse.shtml for specialized information, such as using the StarSQL for Java driver in a particular environment or to accomplish a special task.
All StarQuest products require a license to use the software. StarSQL for Java uses a file named StarLicense.properties for the license configuration. The StarSQL for Java driver will first try to find the StarLicense.properties file in the CLASSPATH (java.class.path). If that fails, then it will look in java.home/lib (the lib directory of the JRE directory). If it fails to find the file, it will use default values for licensing (a StarLicense server named "starlic", listening on port 4999).
FixPak and PTF Notes
i 7.5
Install the following PTF's:
5770SS1-SI79457 for APAR SE77672
Known Issues
Administrator privileges may be needed to modify configuration
On a Windows system, you will need administrator privileges to modify the StarLicense.properties file. Right-click on the Program group shortcut Edit StarLicense.Properties and enable the Run as Administrator option.
Using DatabaseMetadata API methods with synonym
Some DatabaseMetadata API methods may not work correctly when the table name is a synonym.
Using StarSQL for Java with WebSphere on z/OS
When StarSQL for Java is installed on z/OS, all text files are converted to EBCDIC. This enables the use of StarSQL for Java with Java applications running from the UNIX shell of z/OS Unix System Services (USS). However, to use StarSQL for Java with WebSphere v5.x for z/OS, StarLicense.properties must be in ASCII rather than EBCDIC. To convert your existing StarLicense.properties file to ASCII with iconv:
$ mv StarLicense.properties StarLicense.properties.ebcdic
$ iconv -f -t "IBM-1047" "ISO8859-1" StarLicense.properties.ebcdic > StarLicense.properties
Release History
This section provides information about problems or enhancements that are made available as "point releases" and major releases of the [StarQuest product] software.
| Version Number | Release Date | Significant Changes |
|---|---|---|
| 2.78.1109 | 11/09/18 | 14454 - executeBatch: Some parameter values can cause incorrect FD:OCA descriptor to be sent |
| 2.77.1029 | 10/29/18 | 14433 - Obfuscation script: preserve line numbers |
| 2.76.1003 | 10/03/18 | 14404 - ShowVersion: recognize enterprise version 14415 - Error with empty CLOBs |
| 2.75.0822 | 8/22/18 | 14386 - Regression with typdefovr (setobject) 14387 - compatibility with Java 9 Modules 14388 - better error from AGNPRMRM and SRVDGN |
| 2.74.0813 | 8/13/18 | 14375 - DEC & CHAR behaviours 14384 - Missing/truncated DRDA instance variable data sent from multi-threaded load application |
| 2.73.0807 | 8/7/18 | 14362 - Windows Installer: update to IS2018 & vs2017 redistributables 14377 - re-reading rows: java.lang.ArrayIndexOutOfBoundsException: -1 14378 - Obfuscation & native licensing |
| v2.71.0718 | 7/18/18 | 14330 - Assembling scalar data over buffer boundary issue 14331 - Windows installer: remove StarSQL_SSL14.jar 14332 - UNIX installers: remove StarSQL_SSL14.jar 14339 - Driver may leak a timer thread when connection count temporarily drops to zero |
| v2.70.0701 | 7/1/18 | 8591/14319 - Support addBatch, executeBatch 10400 - Eliminate StarSQL_SSL14.jar 14262 - add ability to set held cursor per statement 14268 - Some properties (e.g. dateFormat) are missing in apps that can interrogate & display properties 14274, 14290, 14297 - syntax errors 14307 - timestamp(12) issues 14318 - re-prepare statement after an XA rollback |
| v2.64.0927 | 9/27/15; 6/21/17 | 13467 - getColumns() and DB2 LUW 10.5 13478 - Installer: update to IS2015 and use new SHA-256 code-signing certificate 13781 - Installer update to InstallShield 2016 13830 - Update VS2015u3 PRQ to latest version and fix registry condition 13973 - Unlimited version fails in Oracle 12.2 server-side app |
| v2.63.1208 | 12/08/14 | 13005 - fix for ResultSet.getBinaryStream |
| v2.62.0930 | 09/30/14 | 12883 -handle LOB output parameters from a stored procedure that returns result sets |
| v2.61.0509 | 05/09/14 | 12764 DB2 v10 for z/OS: handle Object Streaming |
| v2.60.0411 | 05/22/12 | 12016 Connection is not marked as being closed after getting IOException on socket 12022 report that getParameterMetaData() is supported |
| v2.59.0210 | 02/10/12 | 10546 Installer: add 64-bit nodelocked licensing support 11657 enhance parser to handle multi-statement SQL 11897 Enhance DataStudio compatibility 11922 Installer: update to IS2011, use standard starlic, and add VS9 redistributable |
| v2.58.0509 | 05/09/11 | 11677 StarPipes Proxy Licensing |
| v2.57.0228 | 02/28/11 | 11049 CLOB/BLOB implementation hides errors
11300 Reporting Precision of BIGINT 11582 Return meaningful value for Vendor Code (SQLCode) in getErrorCode method 11596 Calling getMoreResults on a prepared "query" can cause cursor to be inadvertently closed |
| v2.56.1116 | 11/16/09 | 10982 Some SBCS conversions missing for "common" MBCS hosts 10983 Change order of SECMEC in ACCSEC (workaround UDB 7.2 bug) 10984 Misinterprets ACCRDB replies - RDBAFLRM is error, regardless of SQLSTATE 11016 Failure to connect to some multi-byte UDB hosts |
| v2.55.0910 | 09/10/09 | 10856 Support JDBC 3.0 method getGeneratedKeys() 10892 problem with SQLDTA larger than 32K (affects stored procedures) 10903 handle CLOB output parameters from zOS |
| v2.54.0826 | 08/26/09 | 10881 JVM does not terminate due to persistent StarSQL/Java Threads |
| v2.53.0724 | 07/24/09 | 10712 NullPointerException occurs when changing the password using the newPassword property 10638 Support StarPipes RDBAliasing 10785 "driver not capable" error using the DB2 v9 row_number() over() function 10791 Support StarAdmin 10663 Documentation update 10806 Documentation update 10822 Bind problem (DBCLOB) to DB2 for zOS v8 10823 Bind problem (DBCLOB) to DB2 for zOS v9 10828 Cannot get table metadata for table using SQuirrel SQL Client |
| v2.52.0316 | 03/16/09 | 10624 Support INTEGER and SMALLINT data type conversion to BigDecimal |
| v2.51.1216 | 12/16/08 | 10457 Nullpointer exception when fetching data with Squirrel SQL client 10542 Support for DB2 Server for VSE & VM 10543 StarLicense.properties: change default settings |
Contacting Stelo
If you need to contact technical support, please provide the following information to help the support engineers address your issue. You can contact Stelo via phone, email, or facsimile as indicated at the bottom of this page.
| Company Information | Address Phone |
| Contact Information | First and Last Name of individual contact Email Address |
| Host Type | Hardware and Operating System (i.e., IBM i 7.3) |
| Network Protocol/Gateways | Protocol and/or Gateways used (i.e., TCP/IP, SSL/TLS) |
| Client Type | Client Type and Operating System (i.e., Windows Server 2019, Oracle Linux 8.6) |
| Stelo Product, Version, and Source |
Which Stelo product and what version is installed (i.e., StarSQL for Windows v6.41.0719) Where you obtained the software (i.e., direct from Stelo, name of specific reseller) |
| Problem Information | Provide as much detail as possible, including information about any application that is using the Stelo product when the problem occurs and the exact error message that appears. |
© 2023 Stelo. All rights reserved.
Stelo, a StarQuest company
548 Market St, #22938
San Francisco, CA 94104-5401
Telephone: +1 415.669.9619
Sales information: https://www.stelodata.com/contact-stelo
URL: https://www.stelodata.com
Support: https://support.stelodata.com
Info Center: https://docs.stelodata.com