Handling exceptions in JDBC lookup function

[deepak_shah]

Hi Experts,

We are doing JDBC lookup using standard JDBC lookup function in mapping. It works fine.

However when there is any issue in JDBC lookup channel then JDBC lookup function raised exception in message trace as information message only. And due to this the mapping is not failing.

We want to fail the mapping when JDBC channel is in error. Is there any way to handle this in mapping?

Regards,

Deepak

[rajasekhar_reddy14]

Write simple UDF and check the repsonse ad raise mappinge exception(in UDF thow exception saying like JDBC response not correct or with some other user message).

[deepak_shah]

Hi Raja,

Thanks for the response.

We have written UDF but how do we catch the exception raised by JDBCLookup function.

In display queue of Lookup the context is shown as "<null>".

Thanks,

Deepak

[Shabarish_Nair]

check the return parameter to be null or empty and then fail the UDF

[Former Member]

Did you tried using a BPM

Although this is an alternative approach to the way you are looking at solution

Create a transformation step in BPM followed by a synch send. Here you have to add an control step to catrch the exception