IBM WebSphere Adapter for JDBC, version 7.5.0.5_IF09 Notes

This document contains the following sections:
Enhancements and fixes
New and modified connector properties
Upgrade notes

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF09.
Enhancements
#CRAPARTitleDetails
There are no enhancements in this interim fix.
Fixes
#CRAPARTitleDetails
1JR54368ORA-01400 is not handled as IntegrityConstraintViolation by JDBC Adapter.
Symptom: JDBC Adapter does not throw Integrity Constraint Business Fault Message if the Column Name not null and SQL query tries to insert data with Null value for that Column.
Resolution: Added not null constraint error code to handle Integrity Constraint Violation fault.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF08.
Enhancements
#CRAPARTitleDetails
There are no enhancements in this interim fix.
Fixes
#CRAPARTitleDetails
1Forward Fit JR46764TableNameEnv property does not work when application security is disabled at the invoking component like a web service.
Symptom: When the adapter gets invoked through other components like Web Service and the application security is disabled this would result into an exception - ADMN0022E: Access is denied for the expandVariable operation on AdminOepration MBean because of insufficient or empty credentials
Resolution: Security context is now set on the adapter thread.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF07.
Enhancements
#CRAPARTitleDetails
There are no enhancements in this interim fix.
Fixes
#CRAPARTitleDetails
1Forward Fit JR40904Implicit conversion from VARCHAR to NUMERIC not supported in Sybase Database.
Symptom: Updating/Deleting the Event id field of Event table causes conversion exceptions.
Resolution: Event Id field of the Event Table should be addressed by BigDecimal rather than a String in the Adapter. BigDecimal is the standard Java type for JDBC type mapping w.r.t Numeric types.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF06.
Enhancements
#CRAPARTitleDetails
There are no enhancements in this interim fix.
Fixes
#CRAPARTitleDetails
There are no fixes in this interim fix of JDBC adapter.This IFix for JDBC adapter is being released to consume the Adapter foundation classes Ifix version 7.5.0.5_IF06. Please refer AFC Readme file for fix details.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF05.
Enhancements
#CRAPARTitleDetails
There are no enhancements in this interim fix.
Fixes
#CRAPARTitleDetails
There are no fixes in this interim fix of JDBC adapter.This IFix for JDBC adapter is being released to consume the Adapter foundation classes Ifix version 7.5.0.5_IF05. Please refer AFC Readme file for fix details.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF04.
Enhancements
#CRAPARTitleDetails
There are no enhancements in this interim fix.
Fixes
#CRAPARTitleDetails
There are no fixes in this interim fix of JDBC adapter.This IFix for JDBC adapter is being released to consume the Adapter foundation classes Ifix version 7.5.0.5_IF04. Please refer AFC Readme file for fix details.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF03.
Enhancements
#CRAPARTitleDetails
There are no enhancements in this interim fix.
Fixes
#CRAPARTitleDetails
There are no fixes in this interim fix of JDBC adapter.This IFix for JDBC adapter is being released to consume the Adapter foundation classes Ifix version 7.5.0.5_IF03. Please refer AFC Readme file for fix details.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF02.
Enhancements
#CRAPARTitleDetails
There are no enhancements in this interim fix.
Fixes
#CRAPARTitleDetails
There are no fixes in this interim fix of JDBC adapter.This IFix for JDBC adapter is being released to consume the Adapter foundation classes Ifix version 7.5.0.5_IF02. Please refer AFC Readme file for fix details.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.5_IF01
Enhancements
#CRAPARTitleDetails
There are no enhancements
Fixes
#CRAPARTitleDetails
1JR46720RetrieveAll Operation throws ResourceException when the DatabaseVendor property is not set in MCF.
Symptom: ResourceException: "Resource Adapter instance is null" is thrown when DatabaseVendor property is not specified in the mcf.
Resolution: The Database name is retrieveed from connection object metaData. The issue has been fixed in the interim fix 7.5.0.5_IF01.

This table lists the fixes in WebSphere Adapter for JDBC 7.5.0.3.
Enhancements
#CRAPARTitleDetails
There are no enhancements
Fixes
#CRAPARTitleDetails
18276JR43535StoredFunction for Custom Query in adapter inbound fails with SQL Exception.
Symptom: Missing IN or OUT Parameters at index:: 2"
Resolution: Corrected missing condition for Stored functions.
27062JR43239Inconsistency in standard and custom event table while using custom event query.
Symptom: During the execution of custom event query(stored procedure) if there is an exception, standard and custom event tables are out of sync."
Resolution: Update call for custom and standard queries are executed under a single transaction.

This table lists new and modified connector properties
#VersionAdded or ModifiedPropertyLocation
There is no new connector property introduced/modified for this version of fix pack.


To upgrade to the fix pack version 7.5.0.5_IF04, do the following.
1. Ensure that you have followed the "Installation Instructions" section in the download link before proceeding.
2. If you need to use the Interim Fix for EMD, delete the connector project in WebSphere Integration Developer, import the new RAR file, and apply the enterprise information system (EIS) specific dependency files.
   a. Open the Java build path for the SCA module and remove the Connector project that is selected on Projects tab.
   b. Open the dependency editor and remove the connector project.
   c. Delete the connector project from the workspace.
   d. Import the new RAR file. Add any dependency files from EIS specific application-specific information as needed.
   e. Open the Java build path for the SCA module and select the Connector project that is selected on the Projects tab.
   f. Open the dependency editor and add the connector project if it is not already present and select Deploy with Module.
3. If you need to update deployed applications on WebSphere Process Server, do the following:
   a. Stop the deployed application.
   b. Select Update for the corresponding application on the WebSphere Process Server administrative console.
   c. Select Replace or add a single file with a relative path as name of the RAR file - CWYBC_JDBC.rar.
   d. Click Browse on the local file system to select the updated RAR file that has the changes.
   e. Select the default values in the remaining steps and click Finish. This will ensure that existing configurations, for example, are not changed and that only JAR files will be updated.
   f. Start the application again.


Sep 24th, 2015 6:00 PM
(C) 2014 IBM Corporation. Proprietary and Confidential. All Rights Reserved.