Creating SQL Table based on File

[Mr_Pancake]

Hi,

I've got a very simple testing pipeline:

In row generator I have just TalendDataGenerator.getFirstName() and

TalendDataGenerator.getLastName(). I want to create table like "on the fly" based on scheme provided in

tMap.

The problem is, all the VARCHAR columns length in MySQL is set to 0 what throws this kind of error:

Exception in component tDBOutput_1 (contactTest)

java.sql.BatchUpdateException: Data truncation: Data too long for column 'firstName' at row 1 ...

What can I do to make Talend configure a new SQL table with a proper length of string columns?

Thanks in advance!

[Anonymous · Accepted solution]

Hello

The create table statement is defined based on the schema of tDBOutput component, so open the schema and set the length property of each field.

Regards

Shong