Creating SQL Table based on File

Mr_Pancake — Fri, 15 Nov 2024 21:48:29 GMT

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!

Re: Creating SQL Table based on File

Anonymous — Mon, 15 May 2023 10:46:20 GMT

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