IBM Support

PM31508: DEFAULTDATASOURCE FROM IBM-EJB-BND.XML FAILS WITH JAVA.SQL.SQLNONTRANSIENTEXCEPTION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When some EJBs are initialized, the defaultDatasource from the
    ibm-ejb-bnd.xml file fails with a
    java.sql.SQLNonTransientException, "User ID length, 0, is not
    allowed." message.
    
    The option of using wsadmin to correct the binding file is not
    feasible. Once the empty string is written out as userid and
    password in the binding file, it will always be written out as
    empty string by wsadmin. The only option right now is to change
    the binding file manually to correct the problem, which is not a
    long-term solution.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server V7.0 managing applications with 1X   *
    *                  datasources using the administrative        *
    *                  console.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Usernameor password of empty string     *
    *                      can be written to xmi file if no        *
    *                      username or password is supplied and    *
    *                      the JNDI name is not a valid 1X         *
    *                      datasource.                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The console converts nulls to empty strings, but this causes
    problems with username or password which must remain null.
    

Problem conclusion

  • The username or password will now be null when written back to
    the application management code. This will prevent values of
    empty string from being set for username or password.
    
    The fix for this APAR is currently targeted for inclusion in
    fix pack 7.0.0.17.  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

    PM31508

  • 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

    2011-01-28

  • Closed date

    2011-02-23

  • Last modified date

    2011-02-23

  • 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

    WEBSPHERE APP S

  • Fixed component ID

    5724J0800

Applicable component levels

  • R700 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 7.0

Reference #: PM31508

Modified date: 23 February 2011