StarQuest Technical Documents

StarSQL for Java Troubleshooting

Last Update: 30 April 2015
Product: StarSQL for Java
Version: 2.2 & later
Article ID: SQV0SJ012

Abstract

This document describes issues encountered at customer sites and the solution for each.

Unexpected disconnect using IBM WebSphere Application Server or other Java applications

Symptom:

Occasionally a query would fail with the error [StarSQL][JDBC Driver] Communications error - the input stream ended abnormally while receiving data. WebSphere's Test Connection function succeeded. A DRDA trace indicated a successful connection to the host system, followed by an SQL statement sent to the host over an hour later, with no response from the host.

Solution:

This situation may occur if the WebSphere connection pool is set to hold connections longer than the DB2 idle timer. The result is that the application attempts to connect using a socket that has already been closed by DB2. The solution is to configure the WebSphere idle timer to a value less than the DB2 idle timer.

This condition is not unique to WebSphere; similar mismatches may occur when using other Java applications and application servers.

Connecting to Apache Derby

Symptom:

Connecting to Apache Derby fails with the error:

The use of Distributed Data Management (DDM) command X'2121' not supported

Solution:

Add decimalDelimiter=host;sendUnicode=True to the connection URL e.g.

JDBC://127.0.0.1:1527/SQDRPLUS;decimalDelimiter=host; sendUnicode=True

 

 


DISCLAIMER

The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.