Talend community forum / about tMSSqlSP

bedurand · 2008-01-08 16:08:46

Tags: [java, mssql, stored procedure, tos2.2.3]

Hi all,

I want to use a tMSSqlSP with a function using 3 parameters and returning an integer.

If I use output components, I get a java Exception else it works. See the attached file for more details.

How does this components work please ?

I'm using Talend 2.2.3 with java.

Regards

Ben

Uploaded Images

shong · 2008-01-10 03:45:56

Hi

You should add the 'sk' column in parameters box and its type is out/record set.

Best regards

shong

bedurand · 2008-01-10 10:42:21

If I add sk in OUT, I obtain

Exception in component tMSSqlSP_1
java.sql.SQLException: Trop d'arguments sont spécifiés pour la procédure ou la fonction ps_giveme_SKTechLoad.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)

and in Record Set :

Exception in component tMSSqlSP_1
java.sql.SQLException: Output parameters have not yet been processed. Call getMoreResults().
at net.sourceforge.jtds.jdbc.ParamInfo.getOutValue(ParamInfo.java:159)
at

Regards

rrvieira · 2008-01-11 20:47:52

I'm getting the same behavior with tMSSqlSP and a procedure with output parameters:

Exception in component tMSSqlSP_1
java.sql.SQLException: Output parameters have not yet been processed. Call getMoreResults().
at net.sourceforge.jtds.jdbc.ParamInfo.getOutValue(ParamInfo.java:159)

Is this a bug???

Regards,

MC

rrvieira · 2008-01-11 20:55:45

Issue reported.

http://www.talendforge.org/bugs/view.php?id=2777

Regards

MC

Announcement

Unanswered posts

#1 2008-01-08 16:08:46

about tMSSqlSP

#2 2008-01-10 03:45:56

Re: about tMSSqlSP

#3 2008-01-10 10:42:21

Re: about tMSSqlSP

#4 2008-01-11 20:47:52

Re: about tMSSqlSP

#5 2008-01-11 20:55:45

Re: about tMSSqlSP

Board footer