Symptom
- Connection from Datasphere via the CamelJdbcAdapter (called "Generic JDBC" in Datasphere UI) to DB2 AS400 database is not working.
- Error message in framework.trc:
- [ERROR] [] JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to query schemas. org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The application requester cannot establish the connection. (<URL>.COM ))
[ERROR] [] DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: <ID> on ExchangeId: <ID>). Exhausted after delivery attempt: 1 caught: Cannot create PoolableConnectionFactory (The application requester cannot establish the connection. (<URL>.COM ))
- [ERROR] [] JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to query schemas. org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The application requester cannot establish the connection. (<URL>.COM ))
Read more...
Environment
SAP HANA smart data integration 2.0
Product
SAP HANA smart data integration 2.0
Keywords
SAP HANA smart data integration, DB2, JDBC, connection issue, remote tables, connection string, connection error , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.