DB_OUTPUT_TABLE not support unicode field name

CloverDX Platform
1

===============================================

a.fmt

<?xml version="1.0" encoding="gb2312"?>

=====================================
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node DB_OUTPUT_TABLE_0 finished with status: ERROR caused by: Maximum # of errors exceeded when inserting record. Exeption thrown by: insert into t1 (c2) values ($名称). Message: Parameter index out of range (1 > number of parameters, which is 0). with field 名称 caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). with field 名称
DEBUG [WatchDog] - Node DB_OUTPUT_TABLE_0 error details:
org.jetel.exception.JetelException: Maximum # of errors exceeded when inserting record. Exeption thrown by: insert into t1 (c2) values ($名称). Message: Parameter index out of range (1 > number of parameters, which is 0). with field 名称 caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). with field 名称
at org.jetel.component.DBOutputTable.runInNormalMode(DBOutputTable.java:654)
at org.jetel.component.DBOutputTable.execute(DBOutputTable.java:573)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). with field 名称
at org.jetel.connection.jdbc.CopySQLData.jetel2sql(CopySQLData.java:167)
at org.jetel.connection.jdbc.SQLCloverStatement.executeUpdate(SQLCloverStatement.java:305)
at org.jetel.component.DBOutputTable.runInNormalMode(DBOutputTable.java:617)
… 3 more

===============================================
The reason is that questions do not support unicode field name, can support? How to solve this.

2

Very much like to be able to support unicode field name encoding :slight_smile:

3

Hello, there is no problem with encoding here, but with the query that doesn’t have input parameters. Try to set query insert into t1 (c2) values (?) with data flowing on the edge or execute this query by DBExecute component.

4

But the configuration has not changed, I used the English field names on the successful implementation can, please re-check.
===============================================

===============================================

a.fmt

<?xml version="1.0" encoding="gb2312"?>

===============================================

At present, only use the $ symbol can achieve very good demand for the following.
And? Symbolic way Can not Satisfy.
http://forum.cloveretl.org/viewtopic.php?t=299

5

AGGREGATE componentorg.jetel.component.aggregate.AggregateMappingParser.java

org.jetel.metadata.DataRecordMetadata.java
org.jetel.metadata.DataFieldMetadata.java
org.jetel.util.string.StringUtils.java
private final static String OBJECT_NAME_PATTERN = “[_A-Za-z]+[_A-Za-z0-9]*”;

Did not consider the place a lot of unicode field name

6

Yes, that’s true: only Latin letters and digits can be used in field name. Different chars could cause problems when moving graphs between computers.

7

Hope can be solved by modifying the questions below.