View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005079 | SymmetricDS | Bug | public | 2021-08-27 14:13 | 2021-11-04 14:58 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.12 | Fixed in Version | 3.12.12 | ||
| Summary | 0005079: Tibero bulk loader failing because table and columns quoted in control file | ||||
| Description | Tibero bulk loader is failing with return code of 255. After enabling DEBUG logging, it can be seen that the control file can't be parsed. There are quotes around table and columns names in the control file, which is a feature inherited from the Oracle bulk loader but not supported with tbloader. 2021-08-27 11:16:58,871 INFO [client-1] [ManageIncomingBatchListener] [client-1-dataloader-1] Bulk loading failed for this batch 2139, falling back to default loading. (java.lang.RuntimeException: Process builder returned 255) 2021-08-27 11:16:58,872 INFO [client-1] [DataLoaderService] [client-1-dataloader-1] Bulk loader failed in class java.lang.RuntimeException with message: Process builder returned 255 | ||||
| Tags | dialect: tibero | ||||
|
|
It seems like the table can not be quoted, but the column names can be quoted. So, changing the code to quote the column names if db.delimited.identifier.mode parameter is true, but not quote the table name. Also adding the hard coded strings OPTIONALLY ENCLOSED BY '"' and ESCAPED BY '\\' to the control file. |
|
SymmetricDS: 3.12 075aa19e 2021-08-27 14:24:27 Details Diff |
0005079: Tibero bulk loader failing because table and columns quoted in control file |
Affected Issues 0005079 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/OracleBulkDatabaseWriter.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/TiberoBulkDatabaseWriter.java | Diff File | ||
|
SymmetricDS: 3.12 c1eb9ead 2021-09-01 19:01:24 Details Diff |
0005079: Tibero bulk loader failing because table and columns quoted in control file It seems like the table can not be quoted, but the column names can be quoted. So, changing the code to quote the column names if db.delimited.identifier.mode parameter is true, but not quote the table name. Also adding the hard coded strings OPTIONALLY ENCLOSED BY '"' and ESCAPED BY '\\' to the control file. |
Affected Issues 0005079 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/OracleBulkDatabaseWriter.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/TiberoBulkDatabaseWriter.java | Diff File | ||
|
SymmetricDS: 3.13 fd8f5e29 2021-09-01 19:01:24 Details Diff |
0005079: Tibero bulk loader failing because table and columns quoted in control file It seems like the table can not be quoted, but the column names can be quoted. So, changing the code to quote the column names if db.delimited.identifier.mode parameter is true, but not quote the table name. Also adding the hard coded strings OPTIONALLY ENCLOSED BY '"' and ESCAPED BY '\\' to the control file. # Conflicts: # symmetric-client/src/main/java/org/jumpmind/symmetric/io/OracleBulkDatabaseWriter.java |
Affected Issues 0005079 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/OracleBulkDatabaseWriter.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/TiberoBulkDatabaseWriter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-08-27 14:13 | elong | New Issue | |
| 2021-08-27 14:13 | elong | Status | new => assigned |
| 2021-08-27 14:13 | elong | Assigned To | => elong |
| 2021-08-27 14:13 | elong | Tag Attached: dialect: tibero | |
| 2021-08-27 14:24 | elong | Status | assigned => resolved |
| 2021-08-27 14:24 | elong | Resolution | open => fixed |
| 2021-08-27 14:24 | elong | Fixed in Version | => 3.12.12 |
| 2021-08-27 15:00 | admin | Changeset attached | => SymmetricDS 3.12 075aa19e |
| 2021-09-01 18:57 | pmarzullo | Note Added: 0002002 | |
| 2021-09-01 20:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 c1eb9ead |
| 2021-09-01 20:00 | pmarzullo | Changeset attached | => SymmetricDS 3.13 fd8f5e29 |
| 2021-11-04 14:58 | admin | Status | resolved => closed |