What Are The Different Connection Parameters That Can Be Configured W

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.

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.