SAP Knowledge Base Article - Preview

3442964 - [CamelJDBCAdapter] Remote source connection to a Snowflake DB times out - SAP HANA Smart Data Integration

Symptom

  • Creating a Remote Source Connection with CamelJDBCAdapter (in Datasphere: Generic JDBC connection) to a Snowflake database receives a connection timeout.
  • The framework.trc file contains errors as below:

    • <SessionID> JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to query schemas. org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to <Snowflake_JDBC_URL> failed: connect timed out (local port <Port> to address <DP_Agent_host>, remote port 443 to address <Snowflake_host>).) (...)


Read more...

Environment

SAP HANA smart data integration 2.0

Product

SAP HANA smart data integration 2.0

Keywords

SDI, Camel JDBC, CamelJDBC, CamelJDBCAdapter, Generic JDBC, GenericJDBC, Snowflake, proxy, JDBC URL, remote source, connection, timeout , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem

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.