I like the new Copy-Data-to-Clipboard dialog (and get used to it).
However, I have severe problems to copy query results as SQL inserts.
I start the dialogue using the keyboard shortcut CTRL-Y.
I tested it with RedHat OpenJDK JRE 15.0.2.7.1 and 11.0.11.9.1.
The Java Memory is set to 4 GB.
Copying data as SQL insert works *once* for a smaller result set.
When I try to copy again it won't work.
Sometimes (not every time) an error message pops up saying "Array index out of range: 14".
When SQL Workbench is in this state I exit and restart the program...
When I copy smaller results sets containing less than 100 lines, I receive error messages.
In the clipboard I don't get the current results, but the results from the previous call...
It's all pretty strange.
I also tried the "Copy Data as SQL" dialogue from the data grid.
It also works only for smaller result sets.
When I try to copy a bigger result set (12000 row) there's a "busy spinner" in the result grid.
The copy process doesn't finish. In the clipboard there's still the old result.
On exiting the program it displays an out of index error again (only visible for a split second...).
BTW: "Copy as SQL -> Insert" doesn't really help me for my problem.
I want to quickly copy a table from an IBM i DB2 to an Oracle database.
However, the "Copy as SQL -> insert" creates DB2 syntax, which won't work in Oracle...
Which JRE do you use for testing?
I always use RedHat OpenJDK, but I can test another one...
Richard