Preventive Service Planning
Abstract
To successfully configure a WebSphere Application Server Network Deployment v7 application to access data in an IBM iSeries database involves several steps.
*Obtain the JDBC Driver needed for IBM iSeries
*Configure the JDBC Provider / Data Source in the WebSphere Application Server
*Code the application client to utilize the Data Source
Content
- Obtain the JDBC Driver from the IBM® Toolbox for Java
- Configure the JDBC Provider / Data Source using the WebSphere Application Server Administrative Console
- Code the application client to utilize the Data Source
** If the following error message is seen in the WebSphere Application Server SystemOut log after following these steps, ensure the IBM® Toolbox for Java AS400 (jt400.jar) code is compatible with the current JDK being used by the WebSphere Application Server Network Deployment v7 environment.
[11/1/14 22:52:45:321 UTC] 00000057 SystemOut java.lang.ClassCastException: com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource incompatible with com.ibm.as400.access.AS400JDBCDataSource
Look up information and build versions for the IBM® Toolbox for Java.
[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"7.0","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSCKBL","label":"WebSphere Application Server Hypervisor Edition"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"7.0","Edition":"All Editions","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21572397