topic [resolved] insert data into MS Sql server in Talend Studio

[resolved] insert data into MS Sql server

Anonymous — Sat, 16 Nov 2024 13:40:45 GMT

Hello!
I get the follow error on trying to insert data into MS Sql Server

Exception in component tMSSqlOutput_1
java.sql.SQLException: Line 1: Length or precision specification 0 is invalid.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)

What is wrong?
Could you help me plese?
Gisella

Re: [resolved] insert data into MS Sql server

Anonymous — Wed, 18 Nov 2009 13:38:35 GMT

Check that the schema which is in use for the tMSSQLOutput_1 component has the appropriate data lengths included for all fields (under edit schema in the component).
I believe the lengths need to be included as part of the schema for validation purposes.

Re: [resolved] insert data into MS Sql server

Anonymous — Wed, 18 Nov 2009 13:48:30 GMT

Ok resolved!
See this topic
https://community.talend.com/t5/Design-and-Development/resolved-Metadata-Schema-quot-Guess-quot-ing-Length-for-fields/td-p/75840