Eight Stars

java.sql.SQLException Error

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?

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Ten Stars

Re: java.sql.SQLException Error

uncheck "Trun on Identity insert"

Francois Denis

Don't forget to tag when it's "solved"!

10 REPLIES
Ten Stars

Re: java.sql.SQLException Error

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

Francois Denis

Don't forget to tag when it's "solved"!

Eight Stars

Re: java.sql.SQLException Error

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

Tags (1)
Ten Stars

Re: java.sql.SQLException Error

in witch component : tXxxxx ?

Francois Denis

Don't forget to tag when it's "solved"!

Eight Stars

Re: java.sql.SQLException Error

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.

Ten Stars

Re: java.sql.SQLException Error

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

Francois Denis

Don't forget to tag when it's "solved"!

Eight Stars

Re: java.sql.SQLException Error

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

Ten Stars

Re: java.sql.SQLException Error

can you try with tMSSqlOutput

Francois Denis

Don't forget to tag when it's "solved"!

Eight Stars

Re: java.sql.SQLException Error

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

Ten Stars

Re: java.sql.SQLException Error

uncheck "Trun on Identity insert"

Francois Denis

Don't forget to tag when it's "solved"!

Eight Stars

Re: java.sql.SQLException Error

Thank you... it working fine now