topic Re: TJDBCRow doesn't return JAVA Exception in Talend Studio

TJDBCRow doesn't return JAVA Exception

Anonymous — Sat, 16 Nov 2024 04:52:27 GMT

Hi all,

I have a simple issue.

I run a tJDBCRow with a LOCK TABLE query.

In my case, the table may be already locked when this query is executed on the database, that's why I want to catch the error message.

Unfortunately, the tJDBC doesn't return a JAVA exception despite an oracle error message, so the ((String)globalMap.get("tJDBCRow_1_ERROR_MESSAGE")) is null.

I did a lot of research in vain.

Could you help me ?

Thanks,

Mickael

Re: TJDBCRow doesn't return JAVA Exception

Anonymous — Wed, 28 Aug 2019 07:49:12 GMT

Hello,

What's your Database?

Did you have "die on error" option checked in tJDBCRow component?

Best regards

Sabrina

Re: TJDBCRow doesn't return JAVA Exception

Anonymous — Thu, 29 Aug 2019 09:24:02 GMT

Hi,

Database is Oracle.

No, Die on error is not checked.

Regards,

Mickael

Re: TJDBCRow doesn't return JAVA Exception

Anonymous — Thu, 29 Aug 2019 10:52:47 GMT

Hello,

Have you tried to check "die on error" option in tJDBCRow component to see if there is error message printed on console?

Best regards

Sabrina