[drill-site] branch master updated: Add info about setting JDBC driver connection props in storage-jdbc.

[dz...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

dzamo pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git


The following commit(s) were added to refs/heads/master by this push:
     new 50d36184b Add info about setting JDBC driver connection props in storage-jdbc.
50d36184b is described below

commit 50d36184b9d24d40aee8191a4326e433284e19b6
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Thu Oct 27 16:02:03 2022 +0200

    Add info about setting JDBC driver connection props in storage-jdbc.
---
 _docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

diff --git a/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md b/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
index 43000b26d..8d879fcba 100644
--- a/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
+++ b/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
@@ -21,7 +21,12 @@ Drill is designed to work with any relational datastore that provides a JDBC dri
 
 **Introduced in release:** 1.18
 
-A JDBC storage plugin configuration property `sourceParameters` was introduced to allow setting data source parameters described in [HikariCP](https://github.com/brettwooldridge/HikariCP#configuration-knobs-baby).  Parameters names with incorrect naming and parameter values which are of incorrect data type or illegal will cause the storage plugin to fail to start.  See the [Example of PostgreSQL Configuration with `sourceParameters` configuration property](#example-of-postgres-configurat [...]
+A JDBC storage plugin configuration property `sourceParameters` was introduced to allow setting data source parameters [supported by HikariCP](https://github.com/brettwooldridge/HikariCP#configuration-knobs-baby).  Parameters names with incorrect naming and parameter values which are of incorrect data type or illegal will cause the storage plugin to fail to start.  See the [Example of PostgreSQL Configuration with `sourceParameters` configuration property](#example-of-postgres-configurat [...]
+
+From release 1.20 onwards, the default `sourceParameters` set on the JDBC storage plugin are set to make the initiation of outbound connections lazy rather than eager, where eager means at the time of storage config enablement.  Additionally, the JDBC connection pool is now allowed by default to shrink back down to empty if all of its connections are idle.  These new settings are visible in the `rdbms` storage config template and may be overridden to reinstate Drill's earlier behaviour.
+
+It is also possible to set JDBC driver connection properties (which are distinct from HikariCP's own properties) using `sourceParameters` by prepending the property name with `dataSource.`. For example, to set the connection property `S3OutputLocation`, which is supported by the AWS Athena JDBC driver, add a property named `dataSource.S3OutputLocation` to `sourceParameters`. Refer to the [HikariCP docs](https://github.com/brettwooldridge/HikariCP#rocket-initialization) for more detail.
+
 
 ### Example: Working with MySQL