IBM Support

PM69245: JAVA.LANG.NUMBERFORMATEXCEPTION WHEN USING A DATA SOURCE DEFINED UNDER USER-DEFINED JDBC PROVIDER WITH QUERYTIMEOUT PROPERTY

Fixes are available

8.5.0.2: WebSphere Application Server V8.5 Fix Pack 2
8.0.0.6: WebSphere Application Server V8.0 Fix Pack 6
7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29
8.0.0.7: WebSphere Application Server V8.0 Fix Pack 7
8.0.0.8: WebSphere Application Server V8.0 Fix Pack 8
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
8.0.0.9: WebSphere Application Server V8.0 Fix Pack 9
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
8.0.0.10: WebSphere Application Server V8.0 Fix Pack 10
7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37
8.0.0.11: WebSphere Application Server V8.0 Fix Pack 11
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
8.0.0.12: WebSphere Application Server V8.0 Fix Pack 12
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
8.0.0.13: WebSphere Application Server V8.0 Fix Pack 13
7.0.0.43: WebSphere Application Server V7.0 Fix Pack 43
8.0.0.14: WebSphere Application Server V8.0 Fix Pack 14
7.0.0.45: WebSphere Application Server V7.0 Fix Pack 45
8.0.0.15: WebSphere Application Server V8.0 Fix Pack 15
7.0.0.29: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.45: Java SDK 1.6 SR16 FP60 Cumulative Fix for WebSphere Application Server
7.0.0.31: Java SDK 1.6 SR15 Cumulative Fix for WebSphere Application Server
7.0.0.35: Java SDK 1.6 SR16 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.37: Java SDK 1.6 SR16 FP3 Cumulative Fix for WebSphere Application Server
7.0.0.39: Java SDK 1.6 SR16 FP7 Cumulative Fix for WebSphere Application Server
7.0.0.41: Java SDK 1.6 SR16 FP20 Cumulative Fix for WebSphere Application Server
7.0.0.43: Java SDK 1.6 SR16 FP41 Cumulative Fix for WebSphere Application Server

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When a data source that is defined under a User-defined JDBC
    provider is configured, and a queryTimeout custom property
    exists for the data source, the following exception is thrown
    after upgrading to Fix Pack 21 (V7.0.0.21) for WebSphere
    Application Server V7.0.  The same problem may occur in Fix Pack
    23 or later Fix Packs that are released without the fix for
    this APAR.  The exception is thrown when the application does a
    JNDI lookup of the data source and the GenericDataStoreHelper
    class is being initialized:
    
    J2CA0036E: An exception occurred while invoking method
    setDataSourceProperties on
    com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl used by
    resource jdbc/myDataSource : com.ibm.ws.exception.WsException:
    DSRA8054W: DataStoreHelper,
    'com.ibm.websphere.rsadapter.GenericDataStoreHelper',
    constructor issued following exception:
    java.lang.NumberFormatException: For input string: "".
     at
    java.lang.NumberFormatException.forInputString(NumberFormatExcep
    tion.java:48)
     at java.lang.Integer.parseInt(Integer.java:470)
     at java.lang.Integer.parseInt(Integer.java:499)
     at
    com.ibm.websphere.rsadapter.GenericDataStoreHelper.<init>(Generi
    cDataStoreHelper.java:264)
     at
    sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
    Method)
     at
    sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCons
    tructorAccessorImpl.java:44)
     at
    sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delega
    tingConstructorAccessorImpl.java:27)
     at
    java.lang.reflect.Constructor.newInstance(Constructor.java:516)
     at
    com.ibm.ws.rsadapter.DSConfigurationHelper.createDataStoreHelper
    (DSConfigurationHelper.java:1517)
     at
    com.ibm.ws.rsadapter.spi.WSRdbDataSource.<init>(WSRdbDataSource.
    java:1251)
     at
    com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.setDataS
    ourceProperties(WSManagedConnectionFactoryImpl.java:2621)
    ...
    
    This appears to be related to APAR PM38864, which was included
    in V7.0.0.21, that allows a "webSphereDefaultQueryTimeout"
    property to be set on a data source to establish a default query
    timeout for statements that are created on connections that are
    obtained from the data source.
    

Local fix

  • Remove the queryTimeout custom property from the data source.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: With queryTimeout custom property set   *
    *                      on the datasource , the JNDI lookup     *
    *                      of the datasource fails.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The JNDI lookup fails with below exception:
    J2CA0036E: An exception occurred while invoking method
    setDataSourceProperties on
    com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl used by
    resource jdbc/myDataSource : com.ibm.ws.exception.WsException:
    DSRA8054W: DataStoreHelper,
    'com.ibm.websphere.rsadapter.GenericDataStoreHelper',
    constructor issued following exception:
    java.lang.NumberFormatException: For input string: "".
    at
    java.lang.NumberFormatException.forInputString(NumberFormatExcep
    tion.java:48)
    at java.lang.Integer.parseInt(Integer.java:470)
    at java.lang.Integer.parseInt(Integer.java:499
    

Problem conclusion

  • The code changes are made to validate empty space when parsing
    the property queryTimeout.
    
    The fix for this APAR is currently targeted for inclusion in
    fix packs 7.0.0.27, 8.0.0.6, and 8.5.0.2  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

    PM69245

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-19

  • Closed date

    2012-10-25

  • Last modified date

    2012-10-25

  • 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

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R700 PSY

       UP

  • R800 PSY

       UP

  • R850 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 7.0

Reference #: PM69245

Modified date: 25 October 2012