TJDBCRow doesn't return JAVA Exception

[Anonymous]

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

[Anonymous]

Hello,

What's your Database?

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

Best regards

Sabrina

[Anonymous]

Hi,

Database is Oracle.

No, Die on error is not checked.

Regards,

Mickael

[Anonymous]

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