JDBC Adapter connection to AS400 failed

, ,
1

Hello,

When trying to enable JDBC Adapter connection I’m getting following error:

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource …
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection … after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “com.ibm.as400.access.AS400JDBCDataSource”.
Communication link failure. (A remote host did not respond within the timeout period.)

This worked for a couple of weeks but since yesterday the error above occured.

JDBC Adapter (v6.5) setup:
Connection Properties - Transaction Type = NO_TRANSACTION
DataSource Class = com.ibm.as400.access.AS400JDBCDataSource
Other Properties = translate binary=true;errors=full;prompt=false;naming=sql;transactionIsolation = 2
Enable Connection Pooling = true
Minimum Pool Size = 0
Maximum Pool Size = 60
Pool Increment Size = 1
Block Timeout (msec) = 5000
Expire Timeout (msec) = 60000
Startup Retry Count 0 =
Startup Backoff Timeout (sec) = 5

Any idea what went wrong? Ping and ftp to AS400 worked, but not for JDBC?
What’s the default port for JDBC Connections to AS400?

Thanks and regards,
Tom

2

“Unable to enable connection resource …”
“Unable to start connection … after 1 attempt(s).”

What are you connecting to? it is supposed to be “Unable to enable connection resource (RESOURCE NAME)”

“Unable to start connection (RESOURCE NAME) after 1 attempt(s)”

This is mostly a configuration issue.

3

Hi,
Did you check your userid and password on the AS400 ? (disabled ??)
Do you have a userid and password in your JDBC adapter settings ??
My settings :
Connection Type JDBC Adapter Connection
Package Name PSFT_JDBCAdapterServices
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.ibm.as400.access.AS400JDBCDataSource
serverName PHOBOS1
user JDEWSGPY
password ******
databaseName
portNumber
networkProtocol
Other Properties TranslateBinary=True
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 1
Startup Backoff Timeout (sec) 10