topic Re: java.sql.SQLException Error in Talend Studio

java.sql.SQLException Error

Anonymous — Thu, 14 Jun 2018 10:00:27 GMT

Error is this

Identity column 'MRNNo' must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, unencrypted, and constrained to be nonnullable.

Input field MRNNo is a string, how to handle this?

Re: java.sql.SQLException Error

fdenis — Thu, 14 Jun 2018 10:02:22 GMT

it's defined somewhere as Identity column so it's not a string.
check your metadata

Re: java.sql.SQLException Error

Anonymous — Thu, 14 Jun 2018 10:04:40 GMT

Talend forced me to select the option "Specify Identity field". How can i ignore this? OR What to do for a successful transmission

Re: java.sql.SQLException Error

fdenis — Thu, 14 Jun 2018 10:08:03 GMT

in witch component : tXxxxx ?

Re: java.sql.SQLException Error

Anonymous — Thu, 14 Jun 2018 10:10:18 GMT

I am exporting data from Excel to MSSQL DB

This option comes in tDBOutput.

MRNNo is alphanumeric, hence i cant select INT. MRNNo is string in both source and destination.

Re: java.sql.SQLException Error

fdenis — Thu, 14 Jun 2018 10:22:56 GMT

are you inserting or updating data?
you canuse tMSSqlOutput for MSSQL DB!

Re: java.sql.SQLException Error

Anonymous — Thu, 14 Jun 2018 10:27:28 GMT

There too, if i select Create table then this option "Specify Identity field" pops up

Re: java.sql.SQLException Error

fdenis — Thu, 14 Jun 2018 10:29:38 GMT

can you try with tMSSqlOutput

Re: java.sql.SQLException Error

Anonymous — Thu, 14 Jun 2018 10:31:15 GMT

I was saying about tMSSqlOutput only. "Specify Identity field" option is there if i select create table.

Re: java.sql.SQLException Error

fdenis — Thu, 14 Jun 2018 10:34:34 GMT

uncheck "Trun on Identity insert"

Re: java.sql.SQLException Error

Anonymous — Thu, 14 Jun 2018 10:39:18 GMT

Thank you... it working fine now