DB_OUTPUT_TABLE not support unicode field name

hwhwhw

• March 18, 2009 00:00

• Answered

Follow

<Node id="DELIMITED_DATA_READER_0" type="DELIMITED_DATA_READER" fileURL="c:/test/lxr.txt" />

<Node id="DB_OUTPUT_TABLE_0" type="DB_OUTPUT_TABLE" dbConnection="mysql_133" sqlQuery="insert into t1 (c2) values ($名称)" />

<Edge id="TASK_EDGE_0" fromNode="DELIMITED_DATA_READER_0:0" toNode="DB_OUTPUT_TABLE_0:0" metadata="c:/test/a.fmt" />

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

a.fmt
<?xml version="1.0" encoding="gb2312"?>
<Record name="DB_OUTPUT_TABLE_0" type="delimited">
<Field name="名称" type="string" format="" nullable="true" default="" size="5" length="5" scale="0" delimiter="\n"/>
</Record>

=====================================
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.

• 

  hwhwhw

  • March 18, 2009 09:20

  0

  Comment actions Permalink

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

  avackova

  • March 18, 2009 10:16

  0

  Comment actions Permalink

  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.
• 

  hwhwhw

  • March 19, 2009 03:23

  0

  Comment actions Permalink

  But the configuration has not changed, I used the English field names on the successful implementation can, please re-check.
  ===============================================
  
  <Node id="DELIMITED_DATA_READER_0" type="DELIMITED_DATA_READER" fileURL="c:/test/lxr.txt" />
  
  <Node id="DB_OUTPUT_TABLE_0" type="DB_OUTPUT_TABLE" dbConnection="mysql_133" sqlQuery="insert into t1 (c2) values ($mc)" />
  
  <Edge id="TASK_EDGE_0" fromNode="DELIMITED_DATA_READER_0:0" toNode="DB_OUTPUT_TABLE_0:0" metadata="c:/test/a.fmt" />
  
  ===============================================
  
  a.fmt
  <?xml version="1.0" encoding="gb2312"?>
  <Record name="DB_OUTPUT_TABLE_0" type="delimited">
  <Field name="mc" type="string" format="" nullable="true" default="" size="5" length="5" scale="0" delimiter="\n"/>
  </Record>
  
  ===============================================
  
  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
• 

  hwhwhw

  • March 19, 2009 03:31

  0

  Comment actions Permalink

  1)
  AGGREGATE componentorg.jetel.component.aggregate.AggregateMappingParser.java
  
  2)
  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
• 

  avackova

  • March 19, 2009 08:44

  0

  Comment actions Permalink

  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.
• 

  hwhwhw

  • March 19, 2009 09:13

  0

  Comment actions Permalink

  Hope can be solved by modifying the questions below.
  
  <Node id="DELIMITED_DATA_READER_0" type="DELIMITED_DATA_READER" fileURL="c:/test/lxr.txt" />
  
  <Node id="DB_OUTPUT_TABLE_0" type="DB_OUTPUT_TABLE" dbConnection="mysql_133" sqlQuery="insert into t1 (c2) values ($名称)" />
  
  <Edge id="TASK_EDGE_0" fromNode="DELIMITED_DATA_READER_0:0" toNode="DB_OUTPUT_TABLE_0:0" metadata="c:/test/a.fmt" />

Please sign in to leave a comment.