You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I have faced 2 issues with linked tables
1)
It looks like set autocommit on linked table has no affect on real connection and it's remain defaulted.
For insert 2-3K of rows to Oracle over linked table we can see partial results.
From code I can see that
It uses TableLinkConnection.setAutoCommit(boolean mode) {
this.autocommit= mode;
But conn property(which holds real connection) remain unaffected.
I'm not experienced java programmer , but for test I have added to
TableLinkConnection.setAutoCommit(boolean mode)
additional line of code
this.conn.setAutoCommit(mode);
The behavior was fixed , now but there is no possibility to commit the changes - COMMIT statement doesn't commit remote connection
when insert to linked table is executed it runs
LinkedIndex.add function , which builds TARGET sql string.
In case when value is null it appends NULL string .
So for table t1(c1 var,c2 var,c3 var) insert of rows if with null values in different columns will generate different sql and so multiple prepared statements. In our case tables has hundreds of columns and insert of 2-3K of rows generates hundreds of sqls/prepared statements
Thanks,
The text was updated successfully, but these errors were encountered:
Hello,
I have faced 2 issues with linked tables
1)
It looks like set autocommit on linked table has no affect on real connection and it's remain defaulted.
For insert 2-3K of rows to Oracle over linked table we can see partial results.
From code I can see that
It uses TableLinkConnection.setAutoCommit(boolean mode) {
this.autocommit= mode;
But conn property(which holds real connection) remain unaffected.
I'm not experienced java programmer , but for test I have added to
TableLinkConnection.setAutoCommit(boolean mode)
additional line of code
this.conn.setAutoCommit(mode);
The behavior was fixed , now but there is no possibility to commit the changes - COMMIT statement doesn't commit remote connection
LinkedIndex.add function , which builds TARGET sql string.
In case when value is null it appends NULL string .
So for table t1(c1 var,c2 var,c3 var) insert of rows if with null values in different columns will generate different sql and so multiple prepared statements. In our case tables has hundreds of columns and insert of 2-3K of rows generates hundreds of sqls/prepared statements
Thanks,
The text was updated successfully, but these errors were encountered: