topic Re: Multipe queries are execute in sequential (or) parallel order? in Talend Studio

Multipe queries are execute in sequential (or) parallel order?

Anonymous — Wed, 27 Nov 2013 16:56:23 GMT

Hi all,
I have 3 update queries.I am doing 3 update on the same table.
I know tPostgresqlRow execute multiple queries.
In what order it is executing multiple queries.
1: sequential order (or)
2: parallel order
consider A,B,C queries.
query C depend on A,B.
if tPostgresqlRow execute multiple queries in sequential order.(one by one)
I get the what i am looking.
give me your valuable feedback.
Thanks
kumar.talend

Re: Multipe queries are execute in sequential (or) parallel order?

Anonymous — Wed, 27 Nov 2013 22:26:09 GMT

tPostgresqlRow executes exactly ONE statement and not a script. The only database which accept a script instead of one statement is MySQL.
I hope this is the valuable feedback your requested our majesty.

Re: Multipe queries are execute in sequential (or) parallel order?

Anonymous — Thu, 28 Nov 2013 11:43:23 GMT

Hi jlolling,
I checked tPostgresqlRow, it is executing multiple statement.
And it is executing multiple statement in sequential order.
Thank's for your valuable feedback.
Regards,
kumar.talend

Re: Multipe queries are execute in sequential (or) parallel order?

Anonymous — Thu, 05 Dec 2013 07:38:16 GMT

Hi Gurus,
i am new to talend and my query is to fetch the data from twitter API in talend open studio, i have created my application with all the credentials including token access.
My job include Tinputfilejson file as i/p and Toutputjson as target simply dumping the data into jsonfile but while running my job it failed and below is the error .
Starting job JsonExtracts at 23:21 04/12/2013.
connecting to socket on port 3872
connected
Exception in component tFileInputJSON_1
java.io.IOException: Server returned HTTP response code: 400 for URL: https://api.twitter.com/1.1/search/tweets.json?q=obama&s=typd&x=22&y=20
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(Unknown Source)
at tardis.jsonextracts_0_1.JsonExtracts.tFileInputJSON_1Process(JsonExtracts.java:522)
at tardis.jsonextracts_0_1.JsonExtracts.runJobInTOS(JsonExtracts.java:848)
at tardis.jsonextracts_0_1.JsonExtracts.main(JsonExtracts.java:713)
disconnected
Job JsonExtracts ended at 23:22 04/12/2013.
Could you all please suggest if i have to use Tsalesconnection or something for OAUTH in order to connect.
Regards,
Rituraj saxena