Question Creating a mapping to write into a sheet

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

Hi
It seems to be related to the datatypes.
Can you please try to disable some columns in the mapping, in order to find which one is concerned by the error ? And then please tell me what are the source/target datatypes for this column.

Hi,

I did disable the columns one by one but it still doesn't work..
Same error, same message "com.indy.engine.common.exceptions.EngineExceptionI: Exception for source column 1 and target column 1"
I'm mapping Nvarchar type from source to Varchar type on the target, so I don't understand what I'm doing wrong

Oh, it seems strange and deserves a particular analysis.
Please send to the support team:
- your Designer version number
- your Runtime version number
- a copy of your mapping, metadata, and target Excel file

They will look into this