PushbackInputStream

本文通过一个具体的Java示例介绍了如何使用PushbackInputStream类来区分文件中的ASCII与BIG5编码字符。该示例展示了如何逐个字节读取文件内容,并依据字符编码范围将ASCII字符与BIG5中文字符分离。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

1. java.io.PushbackInputStream拥有一个PushBack缓冲区,从PushbackInputStream读出数据后,只要PushBack缓冲区没有满,就可以使用unread()将数据推回流的前端。

2. 假设一个文本文件中同时存储有ASCII码范围的英文字符与BIG5范围的中文字符。想要判断那些位置是ASCII而哪些位置是BIG5中文字符,BIG5中文字符使用两个字节来表示一个中文字,而ASCII只使用一个字节来表示英文字符。

3. Big5中文为了与ASCII兼容,低字节范围内0xA4-0xF9,而高字节为0x40--0x7E以及0xA1--0xFE。存储时低字节先存,再存高字节,所以读取时只要先读到字节是在0xA4--0xF9,就表示它可能是一个中文字符的前半数据。

4. 下面的范例说明PushbackInputStream的功能,一次从文件中读取两个字节,并检查两个字节合并后的整数值是否在0xA440--0xFFFF之间,这样可以简单地判断其两个字节合并后是否为BIG码。如果是BIG5码则使用这两个字节产生String实例以显示汉字字符;如果不在这个范围之内,则可能是个ASCII范围内的字符,您可以显示第一个字节的字符表示,并将第二个字节推回流,以待下一次可以重新读取。

Java代码


1.package ysu.hxy;
2.
3.import java.io.*;
4.
5.public class PushbackInputStreamDemo
6.{
7. public static void main(String[] args)
8. {
9. try
10. {
11. PushbackInputStream pushbackInputStream =
12. new PushbackInputStream(new FileInputStream(args[0]));
13.
14. byte[] array = new byte[2];
15.
16. int tmp = 0;
17. int count = 0;
18.
19. while((count = pushbackInputStream.read(array))!=-1)
20. {
21. //两个字节转换为整数
22. tmp = (short)((array[0] << 8) | (array[1] & 0xff));
23. tmp = tmp & 0xFFFF;
24.
25. //判断是否为BIG5,如果是则显示BIG5中文字
26. if(tmp >= 0xA440 && tmp < 0xFFFF)
27. {
28. System.out.println("BIG5:" + new String(array));
29. }
30. else
31. {
32. //将第二个字节推回流
33. pushbackInputStream.unread(array,1,1);
34. //显示ASCII范围的字符
35. System.out.println("ASCII: " + (char)array[0]);
36. }
37. }
38. pushbackInputStream.close();
39. }
40. catch(ArrayIndexOutOfBoundsException e)
41. {
42. System.out.println("请指定文件名称");
43. }
44. catch(IOException e)
45. {
46. e.printStackTrace();
47. }
48. }
49.}


[/code]
package ysu.hxy;

import java.io.*;

public class PushbackInputStreamDemo
{
public static void main(String[] args)
{
try
{
PushbackInputStream pushbackInputStream =
new PushbackInputStream(new FileInputStream(args[0]));

byte[] array = new byte[2];

int tmp = 0;
int count = 0;

while((count = pushbackInputStream.read(array))!=-1)
{
//两个字节转换为整数
tmp = (short)((array[0] << 8) | (array[1] & 0xff));
tmp = tmp & 0xFFFF;

//判断是否为BIG5,如果是则显示BIG5中文字
if(tmp >= 0xA440 && tmp < 0xFFFF)
{
System.out.println("BIG5:" + new String(array));
}
else
{
//将第二个字节推回流
pushbackInputStream.unread(array,1,1);
//显示ASCII范围的字符
System.out.println("ASCII: " + (char)array[0]);
}
}
pushbackInputStream.close();
}
catch(ArrayIndexOutOfBoundsException e)
{
System.out.println("请指定文件名称");
}
catch(IOException e)
{
e.printStackTrace();
}
}
}
[/code]
不过这段代码好象有问题:当test.txt里面内容是:a这y是c 时,运行结果如下:

ASCII: a
BIG5: 这
ASCII: y
BIG5: 是
ASCII: c
BIG5: 乔
如果最后一个不是英文的,而是一个汉字,显示是正确的。没找到原因。
{"failed":true,"code":"JSON parse error: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n'); nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n')\n at [Source: (PushbackInputStream); line: 1, column: 1]","message":"JSON parse error: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n'); nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n')\n at [Source: (PushbackInputStream); line: 1, column: 1]","type":"warn","exception":"JSON parse error: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n'); nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n')\n at [Source: (PushbackInputStream); line: 1, column: 1]"}
07-25
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值