topic Re: Database row component response in Talend Studio

Database row component response

cterenzi — Tue, 23 May 2017 21:58:25 GMT

Is there a way to retrieve database response messages when using a database row component (in my case, tPostgresqlRow) to do complex updates? When I run the statement in a database session, I see a response like "UPDATE 0 420" and I'd like to be able to catch that when running the same statement in Talend.

Re: Database row component response

vapukov — Sun, 28 May 2017 04:09:18 GMT

sure direct answer - No 🙂

but may be try to found other way? what are You try to do in database?

Re: Database row component response

cterenzi — Mon, 29 May 2017 02:15:29 GMT

I insert some data into a table and then create records in a mapping table where a mapping record does not exist. The SQL works fine in my dbRow component, but I was hoping to capture the response with number of rows inserted.

I could retrieve both tables and look for missing keys, but running it in the database takes seconds instead of minutes.

Re: Database row component response

vapukov — Mon, 29 May 2017 05:48:22 GMT

is it work slow?:

SELECT count(*) as cnt FROM table1 WHERE NOT EXISTS (SELECT id FROM table2 WHERE table2.id != table1.id)