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

“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.

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