Releases: sranka/jdbcimage
Releases · sranka/jdbcimage
Recognize local and exact timestamps, stabilize with E2E tests
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
Support postgres OTHER types
- adds support for postgres OTHER type, such as json and jsonb
- requires
stringtype=unspecified
in connection string, these types are read/written as strings
- requires
- 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
v0.9.0 chore: version bump
Improve identity_insert in MSSQL
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
Merge pull request #14 from herbert-venancio/master feat(postgres): implement export/import with composite foreign key constraints
Support MSSQL sql_variant and datatimeoffset
New MSSQL column types are supported during export/import/dump.
Repair jdbcimage.bat
v0.8.2 Merge pull request #6 from jlundstedt/jlundstedt-fix-issue-5-update-b…
Update redistributed JDBC drivers
v0.8.1 update JDBC drivers
License and assembly generation improvements
v0.8 version bump to 0.8