IC56169: REQUEST JDBC DRIVER TO PARSE SERVICENAME WHEN USING SQLHOSTS LOOKUP IMPLEMENTATION

Error description

Following the JDBC Driver Programmer's Guide to enable sqlhosts file lookup using SQLH_TYPE and SQLH_FILE entries in the
application connection URL works as anticipated when a port number is specified for the defined server in sqlhosts.
However, if a service name is used instead of a port number in the sqlhosts server definition, the following error isgenerated by the application at runtime:
SQL Code: -79999

SQL State:IX000

Message:Message text will be provided in later releases

java.lang.NumberFormatException: For input string: "sqlexec"

This request is to also include the service name to this functionality.

Problem summary

****************************************************************
USERS AFFECTED:
JDBC driver before 3.50.JC1
****************************************************************
PROBLEM DESCRIPTION:
JDBC was not able to handle service name in the connection
string. It was must to provide the port number in the connection
URL or SQLHOSTS file.
****************************************************************
RECOMMENDATION:
Upgrade to JDBC 3.50.JC1 or above.
****************************************************************

Problem conclusion

The problem has been fixed in 3.50.Jc1. Now JDBC users can pass service name in a connection URL as well as in SQLHOSTS.