You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tSystem with MySqL connection
#1 2010-02-12 14:26:13
- rbaeza
- New member
- Registered: 2010-02-11
- Posts: 3
tSystem with MySqL connection
Hello! Im from South America, a Chilean guy, sorry for the poor english 
Well, this is my problem:
I have a table with URls in MySQL database (for example www.google.cl), and I need to read this entries and make a ping, I need to know is the page is up or down, if the page is down I save in a Log the error. When I make the command directly in the TSystem component
(for example: "cmd /c ping www.google.cl") Its works, but I need to register more Ping results!! and I dont know how to make more pings!
How can i make "cmd /c ping "and put here a the entry of MySQL table" "???
I have:
TmySQLInput--------------------------------> TSystem .... Its that ok?? or I need something like this:
TmySQLInput---------------> Tjava -----------------> TSystem ... and how can I pass the entry!! please Help!!
Where y define the context variable!
This is a Java project with TOS 3.2.3 on Windows XP System
Offline
#2 2010-02-12 16:31:01
- rbaeza
- New member
- Registered: 2010-02-11
- Posts: 3
Re: tSystem with MySqL connection
I solve this.. I only write in the TSystem : "cmd /c ping " + row1.url
Now I need to take all the pings result and save this in a log!
Tsystem properties:
standard and error output:
to global variable: data is passed on to an output variable linked to the tSystem component.
HOW Can I do it!!
HELPP!
Last edited by rbaeza (2010-02-12 16:46:48)
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tSystem with MySqL connection