What are the different connection parameters that can be configured wh

1.	What are the different connection parameters that can be configured while using Query with SQL as data source?
Answer» Connection Pool Mode: To keep connection active Pool timeout: Time duration to keep connection active in minutes. Array Fetch Size: to determine number of rows to fetch from target database. Array Bind Size: Larger bind array, more number of rows will be fetched. Login Timeout: Time before a connection attempts a timeout. JDBC Driver Properties

What are the different connection parameters that can be configured while using Query with SQL as data source?

Answer»

Connection Pool Mode: To keep connection active

Pool timeout: Time duration to keep connection active in minutes.

Array Fetch Size: to determine number of rows to fetch from target database.

Array Bind Size: Larger bind array, more number of rows will be fetched.

JDBC Driver Properties