PK58756: CREATE API TO DO DIRECT ORACLE CALLS WHEN USING ARRAY AS ARGUMENT TO MAKE ORACLE CALLS. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() 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=swg27004980Temporary fix Comments
APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros Publications Referenced
|
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
(C) Copyright IBM Corporation 2000, 2008. All Rights Reserved.