Skip to content

Releases: sranka/jdbcimage

Recognize local and exact timestamps, stabilize with E2E tests

17 Feb 06:40
bf57b39
Compare
Choose a tag to compare

This release adds end-to-end tests that help with fixes that make sure that the tool exports and imports the same common types in postgres, mariadb and mssql databases interchangeably. More specifically, it

  • disambiguates local and exact timestamps, fixes #19
  • adds serialization of UUID in postgres
  • export data files in a new format ("1.1") that has a better serialization of timestamps and mssql DATETIMEOFFSET
    • previously generated files ("1.0") remain supported on import
  • adds e2e tests for import/export on a table with common data types
    • all mssql, postgres, mariadb export/import combinations are tested
    • tests are run twice in different (emulated) timezones to verify that the stored timestamps are independent of the actual timezone
    • tests are run automatically by github (in master branches and pull requests)

What's Changed

Full Changelog: v0.9.2...v0.9.3

3rd-party libraries modernized

13 Feb 10:26
b673a96
Compare
Choose a tag to compare

What's Changed

Full Changelog: v0.9.1...v0.9.2

Support postgres OTHER types

12 Feb 12:19
e969402
Compare
Choose a tag to compare
  • adds support for postgres OTHER type, such as json and jsonb
    • requires stringtype=unspecified in connection string, these types are read/written as strings
  • ignores NULL (\0x00) characters in text fields during data import to postgres
  • upgrades commons-dbcp2 dependency to a compatible version without vulnerability
  • upgrades included postgres JDBC driver to the latest version
  • fix: SQL Server insert into identity column fails due to case insensitivity by @pagrawal40 in #22

Full Changelog: v0.9.0...v0.9.1

Refactor packages

11 Oct 09:39
Compare
Choose a tag to compare
v0.9.0

chore: version bump

Improve identity_insert in MSSQL

06 Sep 10:36
7dec4ec
Compare
Choose a tag to compare

Merge pull request #17 from sranka/16/mssql_identity_insert
fix(mssql): automatically set identity_insert only when inserting to identity column

Support composite foreign keys in PostreSQL

17 Oct 06:04
515a5a2
Compare
Choose a tag to compare
Merge pull request #14 from herbert-venancio/master

feat(postgres): implement export/import with composite foreign key constraints

Support MSSQL sql_variant and datatimeoffset

06 Oct 08:18
181ee1c
Compare
Choose a tag to compare

New MSSQL column types are supported during export/import/dump.

Repair jdbcimage.bat

30 Oct 06:24
49306b3
Compare
Choose a tag to compare
Repair jdbcimage.bat Pre-release
Pre-release
v0.8.2

Merge pull request #6 from jlundstedt/jlundstedt-fix-issue-5-update-b…

Update redistributed JDBC drivers

17 Oct 17:47
Compare
Choose a tag to compare
Pre-release
v0.8.1

update JDBC drivers

License and assembly generation improvements

17 Oct 08:31
Compare
Choose a tag to compare
v0.8

version bump to 0.8