When configuring JDBC plugins, logstash-input-jdbc and logstash-filter-jdbc_streaming allow for "advanced settings" to configure the connections using the sequel_opts configuration setting, which allows a user to configure settings, such as connection timeouts and the maximum number of connections allowed in a connection pool for each of their database connections.

The JDBC static filter does not provide these options, either for connections to query the internal Derby database, or to query the source(s) of the data that populate that database. This means that users of the plugin are stuck with the defaults from the sequel library, which reduces the ability for users to tweak settings to improve performance.

Functionality should be added to enable users to set per-connection advanced settings for "internal" and "external" database queries