U

2 Messages

 • 

800 Points

Tuesday, November 5th, 2024 3:57 PM

connect to DB2 AS400iseries server using the Username and Password Connection Template from Edge Server

We are trying to connect to DB2 AS400iseries server using the Username and Password Connection Template and the following creds:

Username: abc

Password: xyz

DriverClass: com.ibm.as400.access.AS400JDBCDriver

Driver Jar: jt400.jar

String: jdbc:as400://Server:SecurePort/database

Error msg:

Test jdbc connection failed (SQL state: 08001, error code: -99999): SQLNonTransientConnectionException: The application requester cannot establish the connection. (Connection was dropped unexpectedly.)
com.collibra.edge.sdk.exceptions.JdbcConnectionException: Error occurred while connecting to 'jdbc:as400://server:secureport/database' with driver 'com.ibm.as400.access.AS400JDBCDriver'.

NB: The connection is successful if we do not add the port, here we use the connection string: 'jdbc:as400://server/database'

It has been suggested that for secure port connection we have to use SSL certificates.

We know that  Edge does not read certificates located in /etc/pki/ca-trust/extracted/java/cacerts

The question is, how does this work?

1. Do we upload the certificate file in the properties,

2. What is the SSL file version?

Any help will be most appreciated.

No Responses!
Loading...