Releases: kestra-io/plugin-jdbc
Releases · kestra-io/plugin-jdbc
v0.20.2
Bug Fixes
- return size 0 for fetchOne (FETCH_ONE) when there is no result (#459) (Mathieu Gabelle)
Chores
- version v0.20.2 (Mathieu Gabelle)
v0.20.1
Bug Fixes
- jdbc: rollback to fetchType None #457 (Mathieu Gabelle)
Chores
- version v0.20.1 #457 (Mathieu Gabelle)
v0.20.0
Features
- Add a new Queries task to run multiple SQL with multiple outputs, parameter binding and transactions (#398) #398 (Mathieu Gabelle)
- implement queries for postgres (#402) #402 (Mathieu Gabelle)
- add db2 Queries task (#410) #410 (Mathieu Gabelle)
- add queries to sql server (#416) #416 (Mathieu Gabelle)
- add queries to oracle (#417) #417 (Mathieu Gabelle)
- add queries to arrow flight and as400 (#418) #418 (Mathieu Gabelle)
- add queries to clickhouse (#419) #419 (Mathieu Gabelle)
- add queries to dremio (#420) #420 (Mathieu Gabelle)
- add queries to druid (#421) #421 (Mathieu Gabelle)
- add queries to duckdb (#422) #422 (Mathieu Gabelle)
- add queries to pinot (#423) #423 (Mathieu Gabelle)
- add queries : redshift, snowflake, sybase, vectorwise, vertica (#424) #424 (Mathieu Gabelle)
- replace EachSequential with ForEach (#441) #441 (Shruti Mantri)
- storage now have a namespace parameter #442 (Loïc Mathieu)
Bug Fixes
- Prevent resource leak by closing the PreparedStatement (#390) #390 (Lucian Burja)
- druid: exclude Jackson libs as they are provided by Kestra #394 (Loïc Mathieu)
- triggers not working with deprecated properties (#399) #399 (Mathieu Gabelle)
- javadoc issue with lombok builder as parameter (#408) #408 (Mathieu Gabelle)
- deps: force slf4 dependency (#412) #412 (Mathieu Gabelle)
- clean up issue templates (Anna Geller)
- snowflake: Trigger not working when selecting warehouse (#438) #438 (Mathieu Gabelle)
- add missing .editorconfig (Ludovic DEHON)
- queries: remove exception when fetchType is NONE (#447) #447 (Mathieu Gabelle)
- queries: refactor regex for named parameters (#449) #449 (Mathieu Gabelle)
Tests
- queries: add additional tests (#440) #440 (Mathieu Gabelle)
Builds
- deps: bump rlespinasse/github-slug-action from 4 to 5 (Ludovic DEHON)
Chores
- version: update snapshot version 'v0.20.0-SNAPSHOT'. (brian.mulier)
- deps: bump up dependencies (#407) #407 (Mathieu Gabelle)
- cicd: use a non branch version for test artifact (Ludovic DEHON)
- cicd: fix jacoco xml report path (Ludovic DEHON)
- deps: bump up clickhouse to 0.7.1-patch1 (#439) #439 (Mathieu Gabelle)
- version: update to version 'v0.20.0'. (Florian Hussonnois)
Commits
v0.19.1
Bug Fixes
- triggers not working with deprecated properties (#399) (Mathieu Gabelle)
Chores
- version v0.19.1 (Mathieu Gabelle)
v0.19.0
Features
- automatically trigger CI every monday,wednesday and friday at 5am, notify if failed (YannC)
- examples: standardise id naming format in examples #351 (Shruti Mantri)
- use the new FileSerde.readAll() method that improve performance #354 (Loïc Mathieu)
- Improved the Batch tasks to not require an explicit columns specification (#358) #358 (Nikita Hrytsenko)
- Add support for postgres tsvector type (#361) #361 (Nikita Hrytsenko)
- Implement CLI task for ClickHouse (#370) #370 (Nikita Hrytsenko)
- docs: add full-examples for multiple jdbc tasks #362 (Shruti Mantri)
Bug Fixes
- missing dash on refresh dependencies options (YannC)
- example: correct the postgres copyin example #353 (Shruti Mantri)
- fetchOne error when no results #369 (Loïc Mathieu)
- docs: add full examples for multiple jdbc tasks (#378) #378 (Shruti Mantri)
- deps: add script as testImplementation to use ScriptOutput (brian.mulier)
- docs: remove the misplaced bracket #386 (Shruti Mantri)
Builds
- deps: remove jackson libs #352 (Florian Hussonnois)
Chores
- version: update snapshot version 'v0.19.0-SNAPSHOT'. (YannC)
- deps: bump gradle/actions from 3 to 4 #348 (dependabot[bot])
- deps: bump andrcuns/allure-publish-action from 2.6.0 to 2.7.1 #330 (dependabot[bot])
- dependencies upgrade #356 (Loïc Mathieu)
- deps: bump io.trino:trino-jdbc from 453 to 454 #359 (dependabot[bot])
- deps: bump org.xerial:sqlite-jdbc from 3.46.0.1 to 3.46.1.0 #360 (dependabot[bot])
- deps: update gradle wrapper (Ludovic DEHON)
- rockset: rockset shutdown (Ludovic DEHON)
- deps: update all deps (Ludovic DEHON)
- cicd: remove github discussions link (Ludovic DEHON)
- version: update to version 'v0.19.0'. (brian.mulier)
Commits
v0.18.1
v0.18.0
Features
- cicd: publish allure report (Ludovic DEHON)
- cicd: publish jacoco report (Ludovic DEHON)
- use a standard logger for unit test (Ludovic DEHON)
- new product overview video (Will Russell)
Bug Fixes
- transmit fetchSize from Trigger to Query #318 (Loïc Mathieu)
- cicd: don't run jacoco publish on failed (Ludovic DEHON)
- tests: introduce @KestraTest (linked to kestra-io/kestra#3948) (brian.mulier)
- tests: replace DefaultScheduler with JdbcScheduler & fix some queue.receive to work with JDBC (linked to kestra-io/kestra#3948) (brian.mulier)
- use RunContext storage object (Florian Hussonnois)
- tests: use RunContextFactory as RunContext is now abstract (brian.mulier)
- tests: don't lock db on queue.receive (brian.mulier)
- tests: larger startup timeout for druid (brian.mulier)
- deps: remove conditional on repositories for them to work (brian.mulier)
- tests: use TestsUtils.receive API instead of queue.receive (brian.mulier)
- docs: correct examples to use company.team namespace #322 (Shruti Mantri)
- enforce platform (Loïc Mathieu)
- use Jackson from the platform (Loïc Mathieu)
- examples: change the example to fetch multiple rows instead of one row #326 (Shruti Mantri)
- fs to core type (Will Russell)
- build: docker-compose is now docker compose (Ludovic DEHON)
Code Refactoring
- use runContext non-deprecated methods (Ludovic DEHON)
- core: remove RunnerUtils.typedInputs (Ludovic DEHON)
Chores
- version: update snapshot version 'v0.18.0-SNAPSHOT'. (YannC)
- use non-deprecated PluginUtilsService #318 (Loïc Mathieu)
- deps: update gradle-wrapper-validation (Ludovic DEHON)
- deps: fixed bouncycastle version (brian.mulier)
- deps: repositories have to all be at the root project build.gradle since we moved to allprojects directive (brian.mulier)
- deps: use new tests package (Ludovic DEHON)
- use Kestra Platform BOM (Loïc Mathieu)
- vertica: disable test to allows plugin to be built (#349) #349 (YannC)
- vertica: totally disabled Vertica tests (YannC)
- version: update to version 'v0.18.0'. (YannC)
v0.17.0
Features
- Mysql - Batch implementation (#293) #293 (Nikita Hrytsenko)
- Sqlite from a existing database file from the internal storage (#292) #292 (Nikita Hrytsenko)
- snowflake private key #308 (Loïc Mathieu)
- examples: update the examples to use 0.17.0 plugin names #312 (Shruti Mantri)
- cicd: allow skipping test (Ludovic DEHON)
Bug Fixes
- plugin-jdbc-as400: wrong package name #277 (Loïc Mathieu)
- disabling Sybase tests and service as it breaks the CI #282 (Loïc Mathieu)
- use currentColor on icons (Ludovic DEHON)
- docs: change the arrow flight sql and IBM as400 logo for dark background #302 (Shruti Mantri)
- force Jackson version (#307) #307 (Loïc Mathieu)
- snowflake: compilation (Loïc Mathieu)
- snowflake: compilation (Loïc Mathieu)
- plugin-jdbc-pinot: BigDecimal support #316 (Loïc Mathieu)
Code Refactoring
- migrate to Java ServiceLoader for plugin registration (Florian Hussonnois)
Chores
- deps: bump org.apache.arrow:flight-sql-jdbc-driver #288 (dependabot[bot])
- deps: bump io.trino:trino-jdbc from 444 to 445 #286 (dependabot[bot])
- deps: bump com.rockset:rockset-java from 0.12.1 to 0.13.0 #278 (dependabot[bot])
- deps: bump org.xerial:sqlite-jdbc from 3.45.2.0 to 3.45.3.0 #290 (dependabot[bot])
- deps: update most java deps (Ludovic DEHON)
- update runContext deprecated methods #303 (Florian Hussonnois)
- update runContext deprecated methods (Florian Hussonnois)
- deps: bump io.trino:trino-jdbc from 445 to 447 (#305) #305 (dependabot[bot])
- deps: bump com.amazon.redshift:redshift-jdbc42 #304 (dependabot[bot])
- uprade all dependencies (Loïc Mathieu)
- downgrade Oracle driver (Loïc Mathieu)
- version: update to version 'v0.17.0'. (YannC)
Commits
- 7eb6fbd: Implement sybase jdbc plugin (iNikitaGricenko) #282
- 2711320: Update plugin-jdbc-sybase/src/main/java/io/kestra/plugin/jdbc/sybase/Trigger.java (Loïc Mathieu) #282
- d50850b: Correct the url used in DuckDB query (Shruti Mantri) #301
- b96f36e: #268 allow duck db to use existing database file (#294) (Nikita Hrytsenko) #294
- 74c9d07: Update Query.java (Anna Geller)
v0.16.1
Bug Fixes
- plugin-jdbc-as400: wrong package name (Loïc Mathieu)
Chores
- version: update snapshot version 'v0.17.0-SNAPSHOT'. (YannC)
- upgrade to version 0.16.1 (Loïc Mathieu)
v0.16.0
Features
- core: add labels to triggers (Ludovic DEHON)
- Db2 plugin (#260) #260 (Nikita Hrytsenko)
- AS400 plugin #265 (Loïc Mathieu)
- add plugin icons for DB2 and AS400 (Loïc Mathieu)
Bug Fixes
- docs: correct vertica trigger example #261 (Shruti Mantri)
Chores
- version: update snapshot version 'v0.16.0-SNAPSHOT'. (YannC)
- version: update minimal kestra version to '0.16'. (YannC)
- test: fix worker api #264 (Florian Hussonnois)
- upgrade depdencies (Loïc Mathieu)
- deps: bump org.bouncycastle:bcpkix-jdk18on from 1.77 to 1.78 #275 (dependabot[bot])
- deps: bump com.vertica.jdbc:vertica-jdbc #249 (dependabot[bot])
- deps: bump org.apache.calcite.avatica:avatica-core #273 (dependabot[bot])
- deps: bump com.microsoft.sqlserver:mssql-jdbc #272 (dependabot[bot])
- disable Rockset tests if the env prop for its API KEY is missing (Loïc Mathieu)
- deps: bump org.bouncycastle:bcprov-jdk18on from 1.77 to 1.78 #274 (dependabot[bot])
- deps: bump net.snowflake:snowflake-jdbc from 3.15.0 to 3.15.1 #271 (dependabot[bot])
- deps: bump org.postgresql:postgresql from 42.7.2 to 42.7.3 #258 (dependabot[bot])
- deps: bump org.xerial:sqlite-jdbc from 3.45.1.0 to 3.45.2.0 #257 (dependabot[bot])
- deps: bump org.apache.arrow:flight-sql-jdbc-driver #256 (dependabot[bot])
- deps: bump com.rockset:rockset-java from 0.10.3 to 0.12.1 #254 (dependabot[bot])
- deps: bump org.apache.pinot:pinot-jdbc-client #263 (dependabot[bot])
- deps: bump io.trino:trino-jdbc from 439 to 444 #269 (dependabot[bot])
- version: update to version 'v0.16.0'. (YannC)