JDBC - Stored Procedure

Hi All,

Could you please let me know how to give stored procedure query in test connection and account aggregation field in JDBC?

Here I am trying with “Select * from user_table()” in test connection query and aggregation query. when I clicked test connection its getting failed with below error “java.lang.InterruptedException: Timeout waiting for response to message”.

any ideas please ?

Hi @Reddyp

Stored Procedure: To use stored procedure in Test connection/Account aggregation settings, select the Use Stored Procedure checkbox in Test Connection Query Settings /Account Query Settings Panel. For more details please refer JDBC configuration guide

Query: If you are using query then, in your test connection query, use “Select * from user_table” instead of “Select * from user_table()”

Error message : You are getting Timeout error which occurs when it is taking more time to establish the connection. You can increase timeout setting to a higher value (by default it is 30) & retry.
API & Syntax to increase timeout value:
URL:
PATCH /sources/{id}
[id} – External ID of the JDBC source

Header:
authorization: bearer token
Content-Type: application/json- patch +json

Request body:
[
{
“op”: “add”,
“path”: “/connectorAttributes/healthCheckTimeout”,
“value”: 60
}
]