View Issue Details

IDProjectCategoryView StatusLast Update
0005079SymmetricDSBugpublic2021-09-01 20:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.12.0 
Target Version3.12.12Fixed in Version3.12.12 
Summary0005079: Tibero bulk loader failing because table and columns quoted in control file
DescriptionTibero 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
Tagsdialect: tibero

Activities

pmarzullo

2021-09-01 18:57

developer   ~0002002

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.

Related Changesets

SymmetricDS: 3.12 075aa19e

2021-08-27 14:24:27

admin

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

pmarzullo

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

pmarzullo

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

Issue History

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