topic Re: Response SQL errors in ESB API in Talend Studio

Response SQL errors in ESB API

patrickkahle — Tue, 28 Jan 2025 11:29:25 GMT

Hi,

i created a Rest-Call for adding data into a database.

My problem is that I don't realize when the SQL command encounters an error. This can be, for example, when fields are missing. In this case, I still send back a 200. How can I send the SQL error as a response body and a corresponding status code?

Best Regards

Patrick

Re: Response SQL errors in ESB API

Dave_Simo — Tue, 28 Jan 2025 14:48:34 GMT

Hello @patrickkahle ,

In your web services add this and you can also check the die on error in your tDBOutput.

Example during a ko connection the web service will see this again :

Best Regards

Re: Response SQL errors in ESB API

patrickkahle — Wed, 29 Jan 2025 05:15:23 GMT

@Dave_Simo,

actually, thats not working for me.

It seems that the log catcher is not triggered. When I send a request with postman, I get a 200 back in response to my request.

But in Talend i get an error

Best Regards

Re: Response SQL errors in ESB API

Dave_Simo — Wed, 29 Jan 2025 08:33:39 GMT

Hello @patrickkahle ,

Strange, did you check die on error in the tDBOutput component ?

Best Regards

Re: Response SQL errors in ESB API

patrickkahle — Sat, 01 Mar 2025 09:11:59 GMT

hey @Dave_Simo ,

even with this checked checkbox, i can't get an error as response

Best regards

Re: Response SQL errors in ESB API

Dave_Simo — Sat, 01 Mar 2025 16:46:54 GMT

Hello @patrickkahle

Hmm weird you configured your tRESTResponse like below.

Best Regards

Re: Response SQL errors in ESB API

patrickkahle — Sat, 01 Mar 2025 21:46:19 GMT

It doesn't work with the setting either. For whatever reason, it continues with the row settings even though an error occurs. What would exception handling look like for routes?

Greetings

Re: Response SQL errors in ESB API

Dave_Simo — Sun, 02 Mar 2025 13:56:48 GMT

@patrickkahle

For routes you can use the cErrorHandler and cOneException components to catch errors on your web services.

https://help.qlik.com/talend/fr-FR/mediation-components/8.0/mediation-logs-and-errors/cerrorhandler

Otherwise for your web services developed with tRESTRequest, I think you need to make a small modification to the design of your job as below to catch the exception during the error in tDBOUput.

Best Regards