2 Messages
•
800 Points
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!