-
-
Notifications
You must be signed in to change notification settings - Fork 122
/
releasenotes.txt
1817 lines (1380 loc) · 62.6 KB
/
releasenotes.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
16.5.2
- The desktop overview view has been improved.
- Some JDBC drivers were updated.
16.5.1
- The color scheme of the links in the data browser is now controlled heuristically
so that the links that are currently of interest are highlighted.
Others then fade into the background.
16.5
- Menu navigation in the data browser has been simplified.
- The full-text search performance has been significantly improved for large amounts of data.
16.4.2
- Slight improvements to the user interface.
16.4.1
- The documentation has been updated.
- An error that occurred after a connection attempt fails in a new data browser has been fixed.
16.4
- Data can now also be exported as structured JSON and YAML files.
- Fix for Issue 116: "Saving the model files should be sorted"
https://github.com/Wisser/Jailer/issues/116
- Fix for Issue 117: "Missing parantheses causes problems with HSTOREs containing newlines"
https://github.com/Wisser/Jailer/issues/117
16.3.2
- Error messages were lost for errors that occur immediately on startup. (As the colour scheme of the new dark UI theme was initialized too late for this)
16.3.1
- Minor improvements to the color scheme of the new dark UI theme.
16.3
- A dark UI theme has been introduced that improves readability in low light environments.
16.2
- An error has been corrected that caused the quoting character of the
source and target database to be mixed. This could lead to problems if
an export is carried out to a target DBMS that differs from the source DBMS.
16.1.4
- DDL generation has been integrated into the SQL console.
16.1.3
- Enhancements of feature "Exporting SQL including creation of DB schema"
https://github.com/Wisser/Jailer/issues/111
- Simplification of the database connection dialogs.
16.1.2
- Fix for Issue 113: "Liquibase exception: Invalid string encoding on column.remarks."
https://github.com/Wisser/Jailer/issues/113
- The "Generate DDL" feature now also allows the optional generation of "Drop..." statements.
16.1
- Thanks to the integration of the Liquibase tool, DDL scripts can now be generated to create database objects.
This makes it possible to create subset databases from scratch using only on-board means.
15.8.4
- Added support for ClickHouse.
https://github.com/Wisser/Jailer/issues/110
15.8.3
- The tab button for creating new SQL consoles did not work properly.
15.8.2
- The dialog for entering the database credentials has been improved.
- Minor improvements to the user interface.
15.8.1
- After manually canceling a transaction in the SQL console, a misleading error message in some cases was displayed. This has been corrected.
15.8
- Problems regarding the performance of object bindings have been fixed.
- The semantics of the "fetchSize" property in "jaier.json" have been changed. It is now always relevant, not just when it is negative.
15.7
- The configuration file was changed from XML to Json in order to eliminate the dependency on JAXB
due to compatibility problems with JDK 11 or higher.
https://sourceforge.net/p/jailer/discussion/700500/thread/6cf3f6badb/
15.6
- Migration of the JAXB implementation to "org.glassfish.jaxb" due to incompatibilities with JDK 20 or above.
https://sourceforge.net/p/jailer/discussion/700500/thread/6cf3f6badb/
15.5.1
- Issue "QoL: Right click "check" in Model Migration view."
https://sourceforge.net/p/jailer/discussion/700498/thread/b64474f36f/
15.5
- Support of "identity" columns was added. (PostgreSQL, Microsoft SQL Server and DB/2)
- Fix for Issue 109: "Analyzing a Postgres DB with lots of partitioned tables creates separate tables for each partition"
https://github.com/Wisser/Jailer/issues/109
- Fix for Issue 101: "Ignore generated columns when export data"
https://github.com/Wisser/Jailer/issues/101
15.4
- Fix for: "Exporting a varchar field containing $2 as substring".
https://sourceforge.net/p/jailer/discussion/700499/thread/71f33f91b8
15.3.1
- A feature for exporting and importing data models and their database connections has been created.
15.3
- Database connections can now be assigned to a database type (Develop, Test, Staging and Production).
This improves the transparency of the various databases and encourages careful interaction of (near-)production systems.
- Readability of the generated DML has been improved.
- "orai18n"-jar has been added to the Oracle JDBC driver.
15.2.4
- The "Desktop Overview" view has been improved.
- Workaround for issue "Popup is not closed on click outside of area controlled by XWayland". https://bugs.openjdk.org/browse/JDK-8280993
15.2.3
- An error in handling "like" conditions in the "Condition Editor" has been fixed.
15.2.3
- The new "Tooltip Indicator" feature lets you see which user interface elements provide a tooltip.
- A rarely occurring "ConcurrentModificationException" issue was corrected.
15.2.2
- Automatic "Where" clause adjustment in SQL console did not work correctly for queries with an "Order by" clause, but no "Where".
This was corrected.
15.2.1
- Preserving the desktop view position after the maximization of a table browser.
15.2
- Support for "Infinity/-Infinity/NaN" for dates and floating point numbers.
See https://sourceforge.net/p/jailer/discussion/700499/thread/7741dc8aa3
- Canceling the execution of long scripts in the SQLConsole did not work reliably. This has been corrected.
- More minor improvements to the user interface.
15.1.5
- Improved some messy bits in the user interface with native-L&F.
15.1.4
- The desktop overview view has been improved.
15.1.3
- Selection of a single row in the data browser was made possible.
15.1.2
- (has never been published because of technical problems with uploading)
15.1.1
- The dynamic search of the data browser now supports columns of type "UUID".
15.1
- New menu item "Find by: ..." in context menu of the data browser allows to quickly narrow down the result by a column value.
- In the SQL console, statement blocks or the entire script can be executed transactionally. This allows a rollback in case of errors.
15.0.2
- Preserving manual changes of column width and position in the result view after a reload.
- More minor improvements to the user interface.
15.0.1
- SQL statement analysis in the console had problems with single-line comments in literals.
- In the desktop, tool-tips were not shown for cell contents if they were full-text search hits.
15.0
- Added support of PostgreSQL data types (small|big)serial.
- Text search feature in pop-up menus.
- Feature for searching complex paths between tables in big data models.
- Feature "Retry failed statements".
If a script or a block of multiple statements is executed in the SQL console and an error occurs in one of them,
the execution can still be continued. This can be repeated until all statements have run or no more progress can be made.
This is ideal for executing interdependent statements (drop, create table, etc.)
without first sorting them according to their dependencies.
14.7
- Fixed an issue that caused syntactically incorrect statements to be generated when using user-defined data types
across schema boundaries (in PostgreSQL).
14.6.2
- A memory leak has been fixed.
14.6.1
- The menu items "Create SQL ... (for all rows)" in the SQL console popup menu now refers to all selected rows, if available.
- The external library for displaying and editing the SQL console has been updated.
- More minor improvements to the user interface.
14.6
- The "row fetch size" related to database communication has been increased for more performance.
- Fix for "#50 Export liquibase is not usable when null elements are untyped."
https://sourceforge.net/p/jailer/bugs/50/
- Fix for "#51 Liquibase export a wrong Timestamp format"
https://sourceforge.net/p/jailer/bugs/51/
- Fix for "#72 Make liquibase changeSet id dynamic."
https://sourceforge.net/p/jailer/feature-requests/72/
- UI blocking occurred in rare cases when database metadata acquisition took a long time. This has been corrected.
- Other minor improvements to the UI.
14.5
- Both the in-place editor and the search condition dialog now support columns of type "enum".
14.4.2
- The maximum possible memory usage has been increased.
- Minor improvements to the user interface.
14.4.1
- In rare cases, the user interface was blocked for a short time when establishing a connection. This has been corrected.
14.4
- Missing dependencies for Java 11 and above have been added.
- Improved support for CHAR/NCHAR columns.
14.3.4
- Auto-completion in the "where" condition section has been improved.
- Check for uniqueness now already takes place when collecting the rows to be exported.
- Leading and trailing white spaces are now rendered visibly in the data browser.
14.3.3
- Added support for PostgreSQL Range/Multirange Operators.
14.3.2
- The estimation of table sizes could be significantly improved by using row counts from statements and queries.
- The table sizes are now displayed in a better quality.
14.3.1
- When a column filter is defined in the SQL query results window,
the query in the console is augmented with the corresponding "where" condition.
14.3
- In rare cases, an error message appeared after exporting, indicating an alleged discrepancy
between the number of exported rows and the collected ones (false positive).
This error has been corrected.
14.2.1
- Added a context menu to the database connection navigation tree.
- Using "New Window" menu item now restores table-arrangement of original browser.
- Improved responsiveness of the user interface.
14.2
- Fix for "Ignore generated columns when export data". https://github.com/Wisser/Jailer/issues/101
- Fix for "liquibase.exception.MigrationFailedException when importing generated XML files with dates". https://github.com/Wisser/Jailer/issues/100
14.1.1
- A potential connection leak has been fixed.
- Some UI improvements.
14.1
- Database connection navigation has been introduced in the Data Bowser
to allow easy and fast switching between data models and/or database connections.
- The links between related rows between the selected table browsers are now rendered highlighted.
This increases clarity in complex table networks.
- Fixed "Postgres SQL Export File Not Casting to Enum Type On Enum Column Export",
https://sourceforge.net/p/jailer/discussion/700499/thread/92389c5a0f
12.8.4
- A bug in metadata acquisition could cause the GUI to freeze for a short time.
12.8.3
- The new "Extended Copy" feature allows table data to be copied in a variety of ways,
both as plain text and as formatted text.
- Some improvements to the user interface of the data browser.
12.8.2 (Removed because of a bug in the "Extended Copy" feature)
12.8.1
- The new Extraction Model Wizzard simplifies the creation of new models.
- Feature "HTML Renderer - Fetch Database Comments #97".
https://github.com/Wisser/Jailer/issues/97
- Feature "Copying column name, column value, whole row to clipboard".
https://sourceforge.net/p/jailer/feature-requests/71/
12.8
- Support for non-encodable characters (in the default charset) that occur in database metadata.
- Fixed "Some panels cannot display non ASCII characters correctly". https://github.com/Wisser/Jailer/issues/98
12.7.4
- Third party libraries upgrade.
- Minor UI improvements.
12.7.3
- Fixed an issue with the full text search.
- Fixed an issue with the DML generator in the SQL console.
12.7.2
- Issue "Laggy SQL Console". https://github.com/Wisser/Jailer/issues/95
- Issue "Liquibase export of Oracle RAW-columns fails", https://github.com/Wisser/Jailer/issues/96
- SQL Autocompletion has been significantly improved.
12.7.1
- FlatLAF has been updated to version 2.5.
- Minor improvements to the GUI.
12.7
- Full text search with wildcards.
- Vertical toolbar for table windows.
12.6.4
- Issues related to metadata acquisition in the SQL console have been corrected.
12.6.3
- Updated SQL keyword catalog for identifier quoting.
12.6.2
- Minor improvements to the GUI of the data browser.
12.6.1
- Extensive internal refactoring. Improvement of code quality.
- Issue #91, "Open Table popover stuck on screen". https://github.com/Wisser/Jailer/issues/91
- Issue #92, "Database tab - Schema Mapping should alter expanded table list". https://github.com/Wisser/Jailer/issues/92
- NullPointerException in SQL console when no default schema is present was fixed.
12.5.3
- Error "Streaming result set is still active", could occur when table metadata has to be reloaded after a query in the SQL console. (MySQL)
12.5.1
- Consideration of encoding and compression when loading SQL scripts into console or file viewer.
12.5
- SQL Console and desktop improvements
- Queries are now subjected to intensive analysis,
which makes it possible to detect primary and foreign keys and display them accordingly,
as well as the origin table of each column.
- Number data is now formatted and right-aligned.
- Faster metadata acquisition with Oracle DBMS.
- Fixed a bug that caused exports to hang when local database was used for the working tables.
12.4.4
- Reset" button in the dialog for the connection settings.
- When changing the Look&Feel, confirmation dialog appears after restart.
12.4.3
- Release was rolled back because it introduced a new bug related to MySQL in the SQL console.
12.4.2
- The temporary files for the local database were not always cleared away in case of an error. This has been corrected.
- The dialog for database connection parameter entry has been improved.
12.4.1
- The location of the local database files is now configurable.
This prevents disk space problems when there is not enough space available in the system's tmp directory.
12.4
- Update of the local H2 database to version 2.1.212.
- Single launch configuration for both tools.
12.3.1
- FlatLAF has been updated to version 2.2.
- Minor fixes.
12.3
- Logging has been migrated to SLF4J, with log4j2 2.17.2 as the logging framework.
12.2.3
- With releases 12.2.1 and 12.2.2, the user interface may freeze when using the extraction model editor. This has been fixed.
12.2.2
- This release includes some minor fixes and improvements.
12.2.1
- Issue "Desktop window scroll/zoom behaviour", https://github.com/Wisser/Jailer/issues/86
- Issue "Rendering artifacts on native decorated windows on HiDPI", https://github.com/JFormDesigner/FlatLaf/issues/477
12.2
- Full text search over the whole content in the display of a query result.
12.1.3
- Bug fixes:
- The condition editor had problems with string literals containing non-ascii characters.
- In the SQL console, the filter conditions set by the user were lost after a "reload" in the results panel.
- The pseudo variables "$DISTANCE" and "$IS_SUBJECT" were not taken into account by the SQL formatter.
12.1.2
- Moving the split-pane in the data browser and SQL console was not possible in rare cases. This has been corrected.
12.1.1
- Minor user interface improvements and bug fixes.
12.0
- Comprehensive redesign and modernization of the entire user interface.
- "FlatLaf" Look&Feel is now the default. https://github.com/JFormDesigner/FlatLaf
11.2.7
- Fix for "Lack of navigation arrows #74".
https://github.com/Wisser/Jailer/issues/74
- The subsetting results can now be opened directly
in the SQL console of the data browser or as a separate window.
11.2.6
- Automatic and transparent persistence of SQL console content.
- Obfuscation of database credentials.
https://sourceforge.net/p/jailer/feature-requests/70/
11.2.5
- Button to toggle Link on Hover/Link on Select for Details Panel #66. https://github.com/Wisser/Jailer/issues/66
- The SQL filter editor of the data browser had problems with complex RHS expressions. This has been corrected.
- Minor cosmetics to the UI.
11.2.4
- Fixed "Invisible combo box items." https://github.com/JFormDesigner/FlatLaf/issues/426
11.2.3
- Improved filtering of ad-hoc queries in the SQL console.
- Fixed for "User-defined DataTypes (MS SQL Server)". See https://sourceforge.net/p/jailer/discussion/700498/thread/3ed408eb/
11.2
- New and modern user interface look and feel.
11.1.5
- Improved user experience when browsing data.
11.1.4
- Fixed NPE in data browser.
11.1.3
- Minor bug fixes.
11.1.2
- Minor bug fixes.
11.1.1
- Database-side filtering of ad hoc queries in SQL Console.
10.6.1
- An error in creating NVARCHAR literals for MS-SQL Server was corrected.
10.6
- The new "Go Back"/"Go Forward" feature allows to go back and forth
to any state ever reached while navigating through the database.
- The layout auto-rearrangement can now be turned off.
See https://sourceforge.net/p/jailer/discussion/700499/thread/255ca45c7b
10.5.10
- The user interface of the data browser and SQL console has been made a bit more appealing.
10.5.8
- The connection dialog has been improved.
- Database-specific logos are now displayed in the connection dialog and in the status bar.
- The condition editor now also displays the number of rows that are "null" or "not null".
10.5.7
- An error in the validation of database connections that have not been used for a long time has been corrected.
10.5.6
- Increased initial responsiveness of the Data Browser.
10.5.5
- Performance issues with autocomplete have been fixed.
10.5.4
- Fixed an error when rearranging table windows.
- Added a "welcome" dialog for new users.
10.5.3
- Improved automatic arrangement of table windows in the data browser.
- Minor fixes and improved error reporting mechanism.
10.5.1
- The new "Where Condition" Editor allows quick and easy narrowing of table contents to the relevant data.
- Code completion feature has been significantly improved.
10.4.9
- Fix for bug "Exported enum names are truncated in lookup table definitions".
https://sourceforge.net/p/jailer/discussion/700499/thread/69ccdee460
10.4.8
- An error in the autocompletion of "*" in "Insert into... Select..." statements has been corrected.
- Working with multiple browser windows has been made clearer.
10.4.7
- Inplace editors for PostgreSQL data types "hstore", "ghstore", "json", "jsonb" and "boolean".
- Prevention of the "Streaming result set is still active." error with mysql.
10.4.5
- Sessions can be restored from the history of recent sessions.
- The automatic initial naming of database connections has been greatly improved.
10.4.4
- The detail view dialog has been made non-modal, allowing a smoother workflow.
- Rows can now also be edited via the detail view dialog.
10.4.3
- Improved rendering quality on HiDPI environments.
- Many icons have been improved and increased in resolution.
- Mac keyboard shortcuts are now also used with Nimbus-LAF.
- The GUI has been simplified in some places and made clearer.
10.4.2
- Further desktop improvements
- Single-row views are now directly editable. It is also possible to search for columns within them.
- The metadata view has been simplified and made clearer.
- rowid/tid pseudo columns are used to identify a row when the table has no primary key.
- An error in the row count query has been corrected.
10.4.1
- Fixed "(Minor) Dropdown menu disabling inconsistency #40" https://github.com/Wisser/Jailer/issues/40
- Fixed "Parameters not working when using complex filters #41" https://github.com/Wisser/Jailer/issues/41
- New logo.
- Minor fixes and improvements.
10.3.5
- Detection and renewal of invalid database connections (further improvements).
- The inplace editor in the data browser now also supports fields of the "boolean" data type.
10.3.4
- Detection and renewal of invalid database connections.
- With nullable (virtual) primary key columns, errors could occur in the generated SQL statements. This has been fixed.
10.3.3
- The wording of the dialog for analyzing a scheme has been made more understandable.
- Sorting columns in the result of a query in SQL Console did not work
if a column did not have an explicit name. This bug was fixed.
- The error message of the primary key checker tool is now more readable.
- Feature request 67 "Export as imagemap", https://sourceforge.net/p/jailer/feature-requests/67/
10.3.2
- The SQL formatting algorithm has been improved.
- Increased responsiveness of the SQL console.
10.3.1
- The data browser has been revised and improved.
In particular, an overview panel for the desktop was developed,
which simplifies orientation in complex data views.
10.2.7
- Workaround for "Parser hangs in some queries #1013"
- Internal refactoring measures
10.2.6
- If a foreign key is nullable, rows can now be exported with no parents without violating the integrity
by setting the foreign key to null instead. In the same way parents can be deleted without their children.
- Support of CLOB/BLOB in MS SQL
10.2.4
- When working with PostgreSQL, you can use the "ctid" pseudo columns instead of primary keys
for row identification. See https://github.com/Wisser/Jailer/issues/36
- Under rare circumstances SQL statements were generated that could not be processed by Sybase database systems.
This has been corrected.
- The performance of the working table scope "local database" was improved. Especially with embedded usage (API).
- If the subsetter is used via API, access to the working tables is synchronized
so that different extraction models can be used concurrently.
10.2.2
- Error "Streaming result set is still active" when a limit is defined on the subject was fixed (MySQL)
10.2.1
- The response time in case of errors has been improved by immediately terminating all running SQL statements.
10.2
- Support for the MS SQL data type "hierarchyid".
- Severe error in log file creation was fixed.
10.1.2
- Automatic download of JDBC drivers.
- Workaround for bug "JDK-8215200 : IllegalArgumentException in sun.lwawt.macosx.CPlatformWindow"
https://github.com/AdoptOpenJDK/openjdk-jdk11/issues/10
https://bugs.java.com/bugdatabase/view_bug.do?bug_id=8215200
https://bugs.openjdk.java.net/browse/JDK-8215200
10.0
- Java 7 support was dropped in favor of reduced development overheads.
- Third party libraries and JDBC drivers have been upgraded accordingly.
9.5.6
- New CLI tool for printing the closure of subject tables.
https://github.com/Wisser/Jailer/issues/34
- The command line interface has been cleaned up and simplified.
- An error in the HTML rendering of a data model was corrected.
9.5.5
- Fix for "Need help understanding delete script"
https://sourceforge.net/p/jailer/discussion/700499/thread/b3685a49/
(A further release was necessary, as this was not completely corrected at first)
- improved CSV-handling
9.5.4
- Deactivated dependencies had no effect on topological sorting. This was corrected.
https://sourceforge.net/p/jailer/discussion/700499/thread/b3685a49
- Fix for "NoClassDefFoundError was not logged, Jailer failed without showing reason #33"
https://github.com/Wisser/Jailer/issues/33
9.5.3
- Improved Connection Settings Wizard.
- Some diagnostic means have been added.
- Minor fixes.
9.5.2
- Fix for "[Bug] firebird database - No suitable Inline-View Style known #32"
https://github.com/Wisser/Jailer/issues/32
- Fix for "Delete Reduction is not deleting rows"
https://sourceforge.net/p/jailer/discussion/700499/thread/3d16e17980/
9.5.1
- Fix for "[jailer:bugs] #43 PostgreSQL: Export of inet and interval"
https://sourceforge.net/p/jailer/bugs/43/
- Fix for "[jailer:bugs] #44 not a proxy instance if WorkingTableScope.LOCAL_DATABASEand Tomcat jdbc pool"
https://sourceforge.net/p/jailer/bugs/44/
9.5
- Increased initial responsiveness of the Data Browser.
- Extensive internal redesigns since the last major release.
9.4.3
- Fixed issue "Error when running sql script" https://sourceforge.net/p/jailer/discussion/700499/thread/90600d12b6
9.4.2
- Improved database metadata management.
9.4.1
- The new "Degree view" allows quick and easy editing of the associations of tables with the highest connectivity.
9.3.6
- "#66 Avoid plain text passwords on the command line"
https://sourceforge.net/p/jailer/feature-requests/66/
- Minor improvements to GUI of the data browser.
9.3.5
- Minor improvements to the GUI of the SQL console.
- Increased responsiveness and performance of the SQL Console.
9.3.4
- Instant visualization of the contents of the row under the mouse pointer in the data browser.
9.3.3
- Fixed: Characters in bookmark names that are not valid in file names caused errors when saving the bookmarks.
- Minor improvements to the GUI of the data-browser.
9.3.2
- Fixed "Conditions with () have leading and trailing parans removed" https://github.com/Wisser/Jailer/issues/28
- Fetching results from MySQL/MariaDB is now based on a cursor. This prevents out-of-memory errors with large amounts of data.
9.3.1
- Fixed "Syntax error creating tables in PostgreSQL" https://github.com/Wisser/Jailer/issues/27
- Modifications to the connection properties in the "Connection" dialog were sometimes retained after a "cancel".
- "About" dialog now also shows system properties.
9.3
- The number of rows of a subject table to be exported can now be limited
taking into account a possible column order.
- Nullable primary key columns could lead to incorrect results under certain circumstances.
- In the data browser, the user interface sometimes blocked when the acquisition of database metadata took a long time.
9.2.2
- When deleting rows, an IllegalStateException sometimes occurred incorrectly.
- Improved performance of deletion script generation.
- Progress dialog for exporting is no longer modal.
9.2.1
- Support for nullable primary key columns.
This simplifies the definition of pseudo-primary keys for tables without keys.
- "Limit" parameter as a safeguard for exports. https://github.com/Wisser/Jailer/issues/24
9.1.8
- Fixed https://github.com/Wisser/Jailer/issues/22
- Updated the SQLite JDBC driver.
- A new wizard for JDBC URL settings has been created.
9.1.7
- Fixed NullPointerException in Data Browser.
9.1.6
- Support for data type datetime2 in MS SQL.
https://github.com/Wisser/Jailer/issues/20
- The -schemamapping option was not used correctly for the statements of a delete script.
https://github.com/Wisser/Jailer/issues/21
- Formatting of dates/timestamps during export no longer takes place synchronized.
This improves performance when multiple threads are used.
- Minor improvements to the "Export Data" dialog.
9.1.4
- Deadlock prevention in PostgreSQL.
- Support for PostgreSQL type "bpchar".
9.1.3
- Improved display of errors in the data browser.
- More robustness if primary keys are not specified correctly.
9.1.2
- Fetching results from PostgreSQL is now based on a cursor. This prevents out-of-memory errors with large amounts of data.
9.1.1
- Performance improvements.
- The animation of the data model view in the desktop did not work.
- When the DDL is generated for a table, it is also generated for the indexes.
- HiDPI display support.
9.1
- Hover & See function in the data browser to easily see which row is related to which other rows.
- Added configuration information for MariaDB.
- Fix for Issue "Gui: NPE after renaming model file (*.jm)"
https://github.com/Wisser/Jailer/issues/16
- The initial base folder of the data models was incorrect if the installer was used on Windows.
- The minimum requirement for the number of available database connections has been reduced to a single one.
- Extensive internal redesigns since the last major release.
8.8.8
- Avoid NPE if there is no default scheme.
- Import filters did not work correctly when a foreign key column with a filter was exported,
but not the corresponding primary key column.
- In the condition editor, scalar subqueries for columns of adjacent tables can now be generated.
- Minor fixes.
8.8.7
- Upsert statements in PostgreSQL format could fail due to missing explicit conversion of bytea literals.
- The data model editor is now more robust against errors in the data model files.
- Minor improvements to the GUI and bug fixes.
8.8.6
- https://github.com/Wisser/Jailer/issues/14
"[new feature] add command line options to bypass the data model selection dialog"
- https://github.com/Wisser/Jailer/issues/13
"Multiple table selection"
- The model selection dialog has been improved. Recently used connections/sessions/bookmarks can be reopened with a single click.
- The sorting settings of table browsers in bookmarks are recorded and restored.
- New feature "Find Column..." of the data browser makes it easy to find a column in a wide table.
8.8.4
- Fixed a bug that caused a Liquibase export not to work for Postgres TEXT columns.
- SQL Console didn't work with SQLite.
- Improved validation of CLI arguments.
- The "Upsert" statements are generated for more compact.
- Feature Request 65. https://sourceforge.net/p/jailer/feature-requests/65/
- Importing C/BLOBs did not work without write permission on the working directory.
8.8.2
- The layout optimizer of the export progress dialog has been improved.
- The tutorial has been improved.
- Minor fixes and improvements.
8.8.1
- New feature "Check Primary Keys" makes it possible to check the user-defined primary keys for uniqueness.
- A warning message appears if the number of collected rows differs from the number of exported ones.
- The performance of the preparation for the subsetting-process has been improved.
- Extraction models can now be loaded from the "Data Model Manager" dialog.
- It was not possible to pass user / password via cli when it starts with '-'
- Updated local database to H2 1.4.199.
- The fonts selection in the GUI has been standardized.
- Improved error handling in the data browser.
If the same error occurs multiple times because it affects multiple table browsers,
it will be displayed only once.
8.7.8
- Fixed a bug that caused the creation of a delete script to generate syntactically incorrect SQL statements when a table without a primary key exists.
8.7.5
- Fix for ticket 39 "Oracle queries are going failed". https://sourceforge.net/p/jailer/bugs/39/
- Minor bug fixes.
8.7.3
- Fix: the working table scope "local" did not work correctly with PostgreSQL.
- Cursor-based result sets have been activated under PostgreSQL.
Retrieving the entire ResultSet at once led to out-of-memory errors.
8.7.2
- Selected tables are automatically scrolled into the visible area of the display.
- Fix: not all associations between two visible tables were always visible.
8.7.1
- SQL Console is now robust against outdated metadata.
- Fixed: Associations between visible tables were not always visible.
8.7
- Modal dialogues were replaced by non-modal ones.
- Creation of the data model files has been revised.
- Execution plans for DB2 LUW.
- Fixed "ERROR: failed to find conversion function from unknown to text"
that could occur with PostgreSQL in connection with the "local database" scope.
8.6
- The data browser automatically reconnects when the connection is lost.
- Minor bug fixes.
8.5.4
- The table from which the navigation starts can now be changed at any time in the data browser.
- Improved data browser performance.
8.5.3
- Column order in the display can be defined not only globally but also for each table.
8.5.2
- Minor bug fixes.
8.5.1
- Undo/Redo functionality.
- improved HiDPI Support.
8.4.1
- Transactional import did not roll back the transaction in case of an error.
- Fixed an error in the analysis of views.
- Minor bug fixes.
8.3.1
- New "Model Migration Tool" allows you to easily find and edit the newly added associations
if the data model has been extended after the last change to this extraction model.
8.2.6
- Fixed "#37 PostreSQL: transactional execution"
- Fixed "#36 Data Export Dialog: Some settings are 'lost' between Exports"
- FR "#62 subsequent Analyze database, new links fate", only the new "parent-> detail" relationships will be disabled.
- FR "#61 Information about exported rows"
- Issue 10, "Export to SQLite - Boolean values", https://github.com/Wisser/Jailer/issues/10
8.2.5
- Improved livelock prevention.
- [feature-requests:#61] "Information about exported rows"
- [bugs:#36] "Data Export Dialog: Some settings are 'lost' between Exports"
- Fixed NPE in "explain" feature.
- Minor bug fixes.
8.2.4
- Implemented "#57 Analyze database convenience". UPK is formed exclusively for the tables related to the subjects.
- Implemented "#58 receipt += times"
- Fixed "#34 Possible Performance-Improvement in CellContentConverter.toSql"
- Fixed "#59 Retry Deadlock?"
- Automatic adjustment of the number of database connections.
- Improved error handling.
- URL of forum and manual pages on sourceforge have been corrected.
8.2.1
- Intra-database export: automatic fallback to MERGE on tables without PK has been removed.
- Increased SQL import performance + progress bar also for compressed files.
- Logging did not work if the working directory is read-only.
- Improved error handling.
8.2
- Fixed "SQLite JDBC: inconsistent internal state" during database analysis.
- Fixed "#32 SQL analyzer: duplicate associations".
- Implemented "#51 Reduce transaction sizes"
- Implemented "#54 Number thousand separators"
- New option to set the isolation level.
- Bookmark feature in data browser.
8.1.5
- New export option "check primary keys" allows checking the validity of manually defined primary keys.
- New export option "limit transaction sizes" reduces transaction sizes. (Feature request 51)
- Improved indexing of working tables.
- JSQLParser has been updated to version 1.3.
- Fix for bug 32 "SQL analyzer: duplicate associations"
8.1.1
- Increased initial responsiveness of the SQL Console.
- SQL-Console: all requests are now executed in the same connection.
- Feature Request "#47 Add additional tables adds too much"
https://sourceforge.net/p/jailer/feature-requests/47/
- Feature Request "#44 MSSQL export to another DB in same instance"
https://sourceforge.net/p/jailer/feature-requests/44/
- Feature Request "#49 Mac shortcuts"
https://sourceforge.net/p/jailer/feature-requests/49/
- Feature Request "#50 Option to not to delete too much from entities"
https://sourceforge.net/p/jailer/feature-requests/50/
- Improved Cycle Finder component.
8.0.2
- Increased responsiveness and performance of the SQL Console.
8.0.1
- Foreign key columns can be set to null if parent row is not exported.
- Increased responsiveness and performance of the data browser GUI.
8.0
- The new "PathFinder" feature allows elaborate finding
of association paths between tables in complex data models.
7.11.1
- Closing a root table did not work properly in the data browser.
- Minor bug fixes.
7.11
- Database analysis not only finds primary keys and foreign keys for tables,
but also for views and synonyms by analyzing the underlying tables.
- Fixed a memory leak in data browser.
7.10.8
- Data browser improvements
- New layout feature: "align table horizontally with predecessor"
- Improved layout strategy in the data browser.
- Improved row-to-row-link rendering performance.
- Feature Request "Improve the usability of the Data Model Editor" (partially). see https://sourceforge.net/p/jailer/feature-requests/43/
7.10.7
- Zoom in / out using the mouse wheel in the data browser
7.10.6
- Minor bug fixes.
7.10.5
- Animated desktop layout in the data browser.
- Improved row-link rendering quality and performance.
7.10.4
- The estimated number of rows of the tables is displayed.
- Limited fetch size of statements to prevent an OOM exception when the default fetch size is too large (MySQL).
- Updated H2 DBMS from version 1.3.160 to 1.3.175
7.10.3
- Fix for "Can't connect to SOCKS proxy:http" https://github.com/Wisser/Jailer/issues/8
7.10.2
- Added context menu to columns view of results table.
7.10
- Comprehensive usability improvements of the data browser.
- Animated row-to-row links.
- Increased rendering quality of row-to-row link.
- Automatic layouting of data browser desktop.
- Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks.
- Update of SQL keyword catalog to SQL 2003 standard.
7.9.3
- Data browser: prevented that context menu automatically gets closed if the item doesn't have the focus.
7.9.2
- Feature to define the rendering position of a column.
- Rendering of row-to-row links as bezier curves.
7.9.1
- Fixed statement leak.
- Minor GUI Improvements and bug fixes.
7.9
- Comprehensive usability improvements of the data browser.
- Fix for "#25 Invalid SQL when exporting for H2 dialect"
https://sourceforge.net/p/jailer/bugs/25/?limit=25#49d4
- Minor bug fixes.
7.8.2
- The new feature "Analyze SQL" analyzes SQL statements and proposes association definitions.
This allows to reverse-engineer the data model based on existing SQL queries.
- Improved render quality on high resolution screens.
7.7.3
- incremental SQL formatting.
- Minor GUI Improvements and bug fixes.
7.7.2
- SQL-Console
- new "Toggle Line Continuation" context menu item.
- "Substitute Variables" context menu item.
- Loading/Saving of SQL Script Files (with Drag & Drop support)
7.6.8
- SQL-Console: added support for substitution variables.
- Fixed a bug concerning SQL outline rendering.
7.6.6
- Improved SQL Outline rendering.
7.6.5
- Minor GUI Improvements and bug fixes.
7.6.4
- Improved table meta data rendering.
7.6.3
- Asynchronous meta data loading.
7.6.2
- Added "Columns", "Text" and "Meta" views to SQLConsole.
- Added "Functions", "Packages" and "Triggers" views to Data Browser.
- Added "Copy toClipboard" context menu item.
- New feature "Explain Plan" in SQLConsole.
7.6.1
- JDBC driver updates.
- Minor GUI Improvements and bug fixes.
7.6.0
- Constraint checking tool.
- Fix for "#23 Bugs when exporting timestamps and JSON", https://sourceforge.net/p/jailer/bugs/23/
- Minor GUI Improvements and bug fixes.
7.5.10
- SQLConsole: added outline-view for SQL statements.
7.5.8
- SQLConsole: added ability to execute SQL fragments.
- DDL view for tables.
7.5.7
- Minor GUI improvements.
7.5.5
- data browser improvements
- In-place editing of query results.
- Column filtering in data browser.
- Improved table search feature.
7.5.3
- Performance and GUI improvements.
7.5.2
- https://github.com/Wisser/Jailer/pull/5 "Include the column names in the first statement to avoid ORA-00918: column ambiguously defined"
- Table search feature.
- Minor GUI improvements.
7.5
- Full featured SQL Console with code completion, syntax highlighting
and database schema visualization.
7.4.2
- Improved data model merging.
- Added ability to change the data model base folder.
- Metadata views in data browser.
7.4.1
- Minor GUI Improvements.