topic Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters in Talend Studio

Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

mra802003 — Wed, 04 Oct 2017 20:35:10 GMT

Hi,

tFixedFlowInput -> tJDBCSP ->tJava.

Stored procedure performs simple update on a table based on matching condition. It has three input parameters and no output parameter.

I have attached the details of the components.

I am getting the following error while executing the above scenario involving stored procedure.

Exception in component tJDBCSP_3
java.lang.NullPointerException
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.tFixedFlowInput_3Process(MMXFeed_Solution.java:858)
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.runJobInTOS(MMXFeed_Solution.java:1780)
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.main(MMXFeed_Solution.java:1570)
[statistics] disconnected

Any help in this regard is much appreciated.

Regards

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

mra802003 — Wed, 04 Oct 2017 21:30:12 GMT

Can anyone help in this regard?

Regards

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

wangbinlxx — Thu, 05 Oct 2017 04:24:12 GMT

Click Code

=> Open with notepad++ (or whatever editor you prefer)

=> Check what are code in line 858/1570/1780 .

at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.tFixedFlowInput_3Process(MMXFeed_Solution.java:858)
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.runJobInTOS(MMXFeed_Solution.java:1780)
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.main(MMXFeed_Solution.java:1570)

This could help, or you can post those lines here.

Cheers,

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

mra802003 — Thu, 05 Oct 2017 17:35:12 GMT

Thanks. I was able to figure the issue. I was using tDie component in my design which was throwing this error. After removing that component, I was able to execute this successfully.

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

Anonymous — Fri, 20 Oct 2017 10:23:17 GMT

Hello,

Thanks for posting your solution here. We have accepted your solution, which allows others to see what has worked.

Best regards

Sabrina