topic Re: Empty result with tELTOracleInput->tELTOracleMap->tELTOracleOutput in Talend Studio

Empty result with tELTOracleInput->tELTOracleMap->tELTOracleOutput

Anonymous — Sat, 16 Nov 2024 12:34:34 GMT

I design a very simple test job which basically filter out some columns from source table and then insert into a target table. Both source and target table are in the same database. After run job, it appears as completed successfully. However, the target table is empty. I also tried to link tOracleCommit after tELTOracleOutput, but result is still empty. Any idea what went wrong?
The message from Run Job shows:
----------------------------------------------------------------------------
Starting job CreateEventTemp at 21:23 09/11/2011.
connecting to socket on port 3987
connected
Inserting with :
INSERT INTO DBI.FP_TEMP_EVENT(EVENT_ID,EVENT_STATUS_TYPE_ID,CREATED) (SELECT DBI.EVENT_STATUS.EVENT_ID, DBI.EVENT_STATUS.EVENT_STATUS_TYPE_ID, DBI.EVENT_STATUS.CREATED FROM DBI.EVENT_STATUS)
--> 17730 rows inserted.
disconnected
Job CreateEventTemp ended at 21:23 09/11/2011.
----------------------------------------------------------------------------

Re: Empty result with tELTOracleInput->tELTOracleMap->tELTOracleOutput

Anonymous — Thu, 10 Nov 2011 07:41:16 GMT

Hi
Can you upload a screenshot of job?
Best regards
Shong

Re: Empty result with tELTOracleInput->tELTOracleMap->tELTOracleOutput

Anonymous — Thu, 10 Nov 2011 19:17:45 GMT

Never tried upload img. Hope this works. Thanks!

Re: Empty result with tELTOracleInput->tELTOracleMap->tELTOracleOutput

Anonymous — Thu, 10 Nov 2011 19:27:55 GMT

I copied a block of code generated for tELTOracleMap_1Process() here:
-> System.out.println("Inserting with : \n" + insertQuery + "\n");
-> nb_line_inserted_tELTOracleOutput_3 = pstmt_tELTOracleOutput_3.executeUpdate();
-> System.out.println("--> "+ nb_line_inserted_tELTOracleOutput_3+ " rows inserted. \n");
-> pstmt_tELTOracleOutput_3.close();
---- many lines of code here -----
-> tOracleCommit_1Process(globalMap);
I wondered what does pstmt_tELTOracleOutput_3.close() do? Will it close the db connection? The commit happened afterwards.

Re: Empty result with tELTOracleInput->tELTOracleMap->tELTOracleOutput

Anonymous — Fri, 11 Nov 2011 00:42:57 GMT

Hi
There is no a tOracleConnection to create a db connection in the job, so the tOracleCommit will not commit the changes and close the connection. The job design looks like:
tOracleConnection
|
onsubjobok
|
tELTOracleInput->tELTOracleMap->tELTOracleOutput
|
onsubjobok
|
tOracleCommit
on tELTOracleMap, check the option 'using existing connection'.
Best regards
Shong