PK92906: SQLSERVERDICTIONARY EXCEPTION IS THROWN WHEN USING MICROSOFT SQL SERVER JDBC DRIVER V1.2 OR 2.0.

Fixes are available

APAR status

Closed as new function.

Error description

If the Microsoft SQL Server JDBC Driver v1.2 or 2.0 is used
instead of the jTDS driver, then the SQLServerDictionary will
throw an exception while trying to parse the driverName
"Microsoft SQL Server JDBC Driver" to determine the server
version.

Example stack :
java.lang.NumberFormatException: For input string: "JDBC"
at
java.lang.NumberFormatException.forInputString(NumberFormatExcep
tion.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.parseInt(Integer.java:497)
at
org.apache.openjpa.jdbc.sql.SQLServerDictionary.connectedConfigu
ration(SQLServerDictionary.java:92)

Local fix

```
candidate to be fixed in next release
```

Problem summary

****************************************************************
* USERS AFFECTED:  All users of IBM WebSphere Application      *
*                  Server V7.0                                 *
****************************************************************
* PROBLEM DESCRIPTION: NumberFormatException: For input        *
*                      string: "JDBC" is encountered when      *
*                      using Microsoft JDBC Driver v1.2 or     *
*                      2.0 with JPA.                           *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When using the Microsoft SQL Server JDBC Driver v1.2 or 2.0
with JPA, the following Exception can occur:

ava.lang.NumberFormatException: For input string: "JDBC"
at
java.lang.NumberFormatException.forInputString(NumberFormatExcep
tion.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.parseInt(Integer.java:497)
at
org.apache.openjpa.jdbc.sql.SQLServerDictionary.connectedConfigu
ration(SQLServerDictionary.java:92)
at
org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(
DBDictionaryFactory.java:190)
at
org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(
DBDictionaryFactory.java:100)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictiona
ryInstance(JDBCConfigurationImpl.java:584)

Problem conclusion

The SQLServerDictionary was updated to properly handle the
driverName that the Microsoft SQL Server JDBC Driver v1.2 and
v2.0 reports when queried.

The fix for this APAR is currently targeted for inclusion in
fix pack 7.0.0.7.  Please refer to the Recommended Updates
page for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Temporary fix

Comments

APAR Information

APAR number
PK92906
Reported component name
WEBSPHERE APP S
Reported component ID
5724J0800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-07-31
Closed date
2009-08-04
Last modified date
2009-08-04

APAR is sysrouted FROM one or more of the following:

PK90747
APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name
WEBSPHERE APP S
Fixed component ID
5724J0800

Applicable component levels

R700 PSY
UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
24 October 2021

Tips

PK92906: SQLSERVERDICTIONARY EXCEPTION IS THROWN WHEN USING MICROSOFT SQL SERVER JDBC DRIVER V1.2 OR 2.0.

Fixes are available

Subscribe

APAR status

Closed as new function.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R700 PSY

Document Information

Share your feedback

Need support?