- FIX: the input plugin's prior behaviour of opening a new database connection for each scheduled run (removed in
v5.4.1
) is restored, ensuring that infrequently-run schedules do not hold open connections to their databases indefinitely, without reintroducing the leak #130
- Document
statement_retry_attempts
andstatement_retry_attempts_wait_time
options
- Feat: add support for SQL
DATE
columns to jdbc static and streaming filters #171
- Fixes an issue in which any one instance of a JDBC input plugin using
jdbc_default_timezone
changes the behaviour of plugin instances that do not usejdbc_default_timezone
, ensuring that timezone offsets remain consistent for each instance of the plugin as configured #151 - Fixes an exception that could occur while reloading
jdbc_static
databases when the underlying connection to the remote has been broken #165
- Adds retry mechanism when checkout Derby from SVN repository #158
- [DOC] add known limitations and settings for connection issue #167
- Fix Derby missed driver classes when built locally for version 10.15 #160
- Update Derby with locally built 10.15.2.1 version #155
- Update sequel version to >= 5.74.0. It fixes the generic jdbc adapter to properly handle disconnect errors #153
- Update sequel version to >= 5.73.0. The ibmdb and jdbc/db2 adapters were fixed to properly handle disconnect errors, removing the related connection from the pool #144
- Pin sequel to < 5.72.0 due to ruby/bigdecimal#169 #141
- Fix: adaptations for JRuby 9.4 #125
- Fix crash when metadata file can't be deleted after moving under path.data #136
- Doc: described default_hash and tag_on_default_use interaction filter plugin #122
- Added new settings
statement_retry_attempts
andstatement_retry_attempts_wait_time
for retry of failed sql statement execution #123
- Bugfix leak which happened in creating a new Database pool for every query. The pool is now crated on registration and closed on plugin's
stop
#119
- Ambiguous Timestamp Support #92
- FIX: when encountering an ambiguous timestamp, the JDBC Input no longer crashes
- Added support for disambiguating timestamps in daylight saving time (DST) overlap periods
- Refactor: start using scheduler mixin #110
- Fix: change default path of 'last_run_metadata_path' to be rooted in the LS data.path folder and not in $HOME #106
- Fix: do not execute more queries with debug logging #109
- Fix: compatibility with all (>= 3.0) rufus-scheduler versions #97
- Performance: avoid contention on scheduler execution #103
- Feat: name scheduler threads + redirect error logging #102
- Refactor: isolate paginated normal statement algorithm in a separate handler #101
- Added
jdbc_paging_mode
option to choose if useexplicit
pagination in statements and avoid the initial count query or useauto
to delegate to the underlying library #95
-
Refactor: to explicit Java (driver) class name loading #96, the change is expected to provide a more robust fix for the driver loading issue #83.
NOTE: a fatal driver error will no longer keep reloading the pipeline and now leads to a system exit.
-
Fix: regression due returning the Java driver class #98
- Refactor: to explicit Java (driver) class name loading #96, the change is expected to provide a more robust fix for the driver loading issue #83.
- Fix the blocking pipeline reload and shutdown when connectivity issues happen #85
- Normalize jdbc_driver_class loading to support any top-level java packages #86
- Fix, serialize the JDBC driver loading steps to avoid concurrency issues #84
- Refined ECS support #82
- Uses shared
target
guidance when ECS compatibility is enabled - Uses Logstash's EventFactory instead of instantiating events directly
- Uses shared
- [DOC] Update filter-jdbc_static doc to describe ECS compatibility #79
- Improve robustness when handling errors from
sequel
library in jdbc static and streaming filters #78
- Fix
prepared_statement_bind_values
in streaming filter to resolve nested event's fields #76
-
Added
target
option to JDBC input, allowing the row columns to target a specific field instead of being expanded at the root of the event. This allows the input to play nicer with the Elastic Common Schema when the input does not follow the schema. #69 -
Added
target
to JDBC filter staticlocal_lookups
to verify it's properly valued when ECS is enabled. #71
-
Feat: try hard to log Java cause (chain) #62
This allows seeing a full trace from the JDBC driver in case of connection errors.
-
Refactored Lookup used in jdbc_streaming and jdbc_static to avoid code duplication. #59
- DOC:Replaced plugin_header file with plugin_header-integration file. #40
- Fixed user sequel_opts not being passed down properly #37
- Refactored jdbc_streaming to share driver loading, so the fixes from the jdbc plugin also effect jdbc_streaming
- Fixed issue where JDBC Drivers that don't correctly register with Java's DriverManager fail to load (such as Sybase) #34
- Fixed issue where a lost connection to the database can cause errors when using prepared statements with the scheduler #25
- Fixed potential resource leak by ensuring scheduler is shutdown when a pipeline encounter an error during the running #28
- Fixed tracking_column regression with Postgresql Numeric types #17
- Fixed driver loading when file not accessible #15
- Initial Release of JDBC Integration Plugin, incorporating logstash-input-jdbc, logstash-filter-jdbc_streaming and logstash-filter-jdbc_static
- For Changelog of individual plugins, see: