Hi,
I am trying to insert data in an Excel sheet.
I have a really simple Mapping with two objects:
- In source : a SQL Server table
- In target : an Excel sheet (from an excel file I reversed)
I followed the "Getting started with Stambia's JDBC Excel Driver", and did everything mentioned in the tutorial, but when I execute the mapping, I get an error during the Integration part (Load of data) :
com.indy.engine.common.exceptions.EngineExceptionI: Exception for source column 1 and target column 1
at com.indy.engine.actionCodes.JdbcActionCodeI.a(SourceFile:598)
at com.indy.engine.actionCodes.JdbcActionCodeI.executeTrgDirectBindedInsert(SourceFile:695)
at com.indy.engine.actionCodes.JdbcActionCodeI.executeDirectBindedFetch(SourceFile:1005)
at com.indy.engine.action.common.ActionCodeTypeI.executeDirectBindedCode(SourceFile:1399)
at com.indy.engine.action.common.ActionCodeTypeI.executeBindedCode(SourceFile:1565)
at com.indy.engine.action.common.ActionCodeTypeI.executeCode(SourceFile:1630)
at com.indy.engine.action.common.ActionCodeTypeI.run(SourceFile:1805)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.UnsupportedOperationException
at com.stambia.jdbc.driver.xls.xls.XlsPrepareStatement.setNString(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setNString(DelegatingPreparedStatement.java:238)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setNString(DelegatingPreparedStatement.java:238)
at com.indy.engine.actionCodes.convert.JdbcConverter.convertString(JdbcConverter.java:110)
at com.indy.engine.actionCodes.convert.JdbcConverter$4.write(JdbcConverter.java:709)
at com.indy.engine.actionCodes.convert.JdbcConverter$4.write(JdbcConverter.java:1)
at com.indy.engine.actionCodes.loader.a.a(SourceFile:113)
at com.indy.engine.actionCodes.JdbcActionCodeI.a(SourceFile:586)
... 7 more
The "Load of data" generated code is :
insert into "ErrorFichierRetourMAJadmin"."Feuil1$"
(
"file_name",
"date_creation",
"type_enregistrement",
"ref_externe",
"num_ordre_dem",
"donnees"
)
values
(
:{L1_file_name}:,
:{L2_date_creation}:,
:{L3_type_enregistrement}:,
:{L4_ref_externe}:,
:{L5_num_ordre_dem}:,
:{L6_donnees}:
)
I could not find a way to resolve it, do you have any idea?
Thx