PK58756: CREATE API TO DO DIRECT ORACLE CALLS WHEN USING ARRAY AS ARGUMENT TO MAKE ORACLE CALLS.

 Fixes are available

6.1.0.17 WebSphere Application Server V6.1 Fix Pack 17 for i5/OS
6.1.0.17: WebSphere Application Server V6.1 Fix Pack 17 for Linux
6.1.0.17: WebSphere Application Server V6.1 Fix Pack 17 for Solaris
6.1.0.17: WebSphere Application Server V6.1 Fix Pack 17 for HP-UX
6.1.0.17: WebSphere Application Server V6.1 Fix Pack 17 for Windows
6.1.0.17 WebSphere Application Server V6.1 Fix Pack 17 for AIX
6.0.2.29: WebSphere Application Server V6.0.2 Fix Pack 29 for AIX platforms
6.0.2.29: WebSphere Application Server V6.0.2 Fix Pack 29 for HP-UX platforms
6.0.2.29: WebSphere Application Server V6.0.2 Fix Pack 29 for Linux platforms
V6.0.2: Java SDK 1.4.2 SR11 Cumulative Fix for IBM WebSphere Application Server
6.0.2.29: WebSphere Application Server V6.0.2 Fix Pack 29 for Solaris
6.0.2.29: WebSphere Application Server V6.0.2 Fix Pack 29 for Windows platforms
6.1.0.19 WebSphere Application Server V6.1 Fix Pack 19 for AIX
6.1.0.19: WebSphere Application Server V6.1 Fix Pack 19 for HP-UX
6.1.0.19 WebSphere Application Server V6.1 Fix Pack 19 for i5/OS
6.1.0.19: WebSphere Application Server V6.1 Fix Pack 19 for Linux
6.1.0.19: WebSphere Application Server V6.1 Fix Pack 19 for Solaris
6.1.0.19: WebSphere Application Server V6.1 Fix Pack 19 for Windows
Java SDK 1.5 SR8 Cumulative Fix for WebSphere Application Server
6.1.0.21 WebSphere Application Server V6.1 Fix Pack 21 for AIX
6.0.2.31: WebSphere Application Server V6.0.2 Fix Pack 31 for AIX platforms
6.0.2.31: WebSphere Application Server V6.0.2 Fix Pack 31 for HP-UX platforms
6.0.2.31: WebSphere Application Server V6.0.2 Fix Pack 31 for OS/400 platform
6.0.2.31: WebSphere Application Server V6.0.2 Fix Pack 31 for Linux platforms
6.0.2.31: WebSphere Application Server V6.0.2 Fix Pack 31 for Solaris
6.0.2.31: WebSphere Application Server V6.0.2 Fix Pack 31 for Windows platforms
V6.0.2: Java SDK 1.4.2 SR11 Cumulative Fix for IBM WebSphere Application Server
6.1.0.21 WebSphere Application Server V6.1 Fix Pack 21 for i5/OS
6.1.0.21: WebSphere Application Server V6.1 Fix Pack 21 for Windows
6.1.0.21: WebSphere Application Server V6.1 Fix Pack 21 for Solaris
6.1.0.21: WebSphere Application Server V6.1 Fix Pack 21 for Linux
Java SDK 1.5 SR8 Cumulative Fix for WebSphere Application Server
6.1.0.21: WebSphere Application Server V6.1 Fix Pack 21 for HP-UX



APAR status
Closed as program error.

Error description
Need API to do direct connection with ORACLE database not usi
ng proprietary APIs because in this case, it is necessary to pas
s an argument in the form of an array.  This scenaro requires th
at an Oracle-specific call be made on the Oracle Connection.  At
 this point using standard connection pooling, WAS does not have
the ability to be able to exercise all of the ORACLE connectio
n's potential or functionality.
Local fix Problem summary
The resource records were left in checked-out state.
PROBLEM CONCLUSION:
The fix provided checks-in all the checked out records.

TEMPORARY FIX:
COMMENTS:
MODULES/MACROS:  
NONE
SRLS:     
* RECOMMENDATION:                                              *
****************************************************************
Currently the only API's that access native JDBC connections
are private, internal to the Relational Resource Adapter.
It is sometimes necessary for applications to have access to
the native JDBC connection to call database vendor specific
API's.
Problem conclusion
The following public API was added to the IBM RRA
WSCallHelper class under this APAR:


/**
* PK58756
* This method returns the underlying physical JDBC
* connection to the caller. Take caution when you use
* the underlying physical connections directly, because
* some important functions of the application server
* will be lost, such as the following:
* <LI> Tracing </LI>
* <LI> Deferred enlistment </LI>
* <LI> Transaction management </LI>
* <LI> Exception mapping </LI>
* <LI> Connection pooling </LI>
*
* Do not actually close the underlying physical
* connection; instead, close the connection handle from
* the application server. If you close the native
* connection , there will be failures the next time the
* application server uses the connection handle.
*
*
* @return a java.sql.Connection
**/
public static final java.sql.Connection getNativeConnection
(Object connection)  throws SQLException

The fix for this APAR is currently targeted for inclusion
in cumulative fix 5.1.1.19 and fix packs 6.0.2.29 and 6.1.0.19.
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 PK58756
Reported component name WEBSPHERE BASE
Reported component ID 5630A3600
Reported release 10S
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2008-01-02
Closed date 2008-03-31
Last modified date 2008-04-28

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Publications Referenced

Fix information
Fixed component name WEBSPHERE BASE
Fixed component ID 5630A3600

Applicable component levels
R003 PSY    UP
R00A PSY    UP
R00H PSY    UP
R00I PSY    UP
R00P PSY    UP
R00S PSY    UP
R00W PSY    UP
R103 PSY    UP
R10A PSY    UP
R10H PSY    UP
R10I PSY    UP
R10P PSY    UP
R10S PSY    UP
R10W PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 10S
Software edition:
Reference #: PK58756
IBM Group: Software Group
Modified date: Apr 28, 2008