Last updated on MARCH 08, 2017
Applies to:Oracle Containers for J2EE - Version: 10.1.3.5.0
Information in this document applies to any platform.
JDeveloper was set up by adding the needed jar (jt400.jar) in %JDEVHOME%/jdbc/lib with no errors, and table definitions and data can be viewed.
After setting up a connection pool on the application server by adding jt400.jar to $ORACLE_HOME/j2ee/OC4J_1/applib and restarting the instance, the connection pool was created, but testing the connection pool in Application Server Control gives the error:
Unable to establish connection to "myNewPool" for one or more OC4J instances in the group.
Below are the results for each OC4J instance:
Failed due to error: "Exception occurred testing connection. Exception: java.awt.HeadlessException."
The toolbox jar was added and setup the connection pool using:
Connection factory class: com.ibm.as400.access.AS400JDBCConnectionPoolDataSource
JDBC URL: jdbc:as400://ouras400hostname
The below FAQ document was usd to configure a connection pool using the IBM Toolbox for Java driver :
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms