[resolved] Store log in a Databases

[Anonymous]

Hello,
Is it possible with talend to store the logs of insertion, updates and deletion in a table?
I try but i don't know what tools to use!
I used twarn, trowGenerator, tLogCatcher like in the tutorial, it works but i want to apply this in a java application!
For example, when a user add data or update data, the logs of this operation is stored in a table!

[Anonymous]

Your talend job would write to database about the logs...
Create another job to read the database table related to error log and if there are any records, read those records and sent it via email using tSendMail component.
Vaibhav

[Anonymous]

Your talend job would write to database about the logs...
Create another job to read the database table related to error log and if there are any records, read those records and sent it via email using tSendMail component.
Vaibhav

Ok i'll try it
G47

[Anonymous]

Hey i've try to make it like this, can you give me advice?

[Anonymous]

Good, this would work. In addition to the error logs, there are two more components, tstatcatcher and tmetercatcher... better you have a look at those. These component may help you to get more details.
In addition to this, tlogcatcher would not provide you with the console trace. You need to make use of some java component in tpreJob to capture complete stack trace for your job execution inside the file. This will help you.
Check couple of blogs for your reference
http://helicaltech.com/logging-using-talend/
http://helicaltech.com/redirecting-talend-console-logs/
You will get some idea based on above logs.
Thanks
Vaibhav

[Anonymous]

Good, this would work. In addition to the error logs, there are two more components, tstatcatcher and tmetercatcher... better you have a look at those. These component may help you to get more details.
In addition to this, tlogcatcher would not provide you with the console trace. You need to make use of some java component in tpreJob to capture complete stack trace for your job execution inside the file. This will help you.
Check couple of blogs for your reference
http://helicaltech.com/logging-using-talend/
http://helicaltech.com/redirecting-talend-console-logs/
You will get some idea based on above logs.
Thanks
Vaibhav

Thanks for your help,
But how do i integrate it into an application. For example: when a user insert/update or delete into a table and when a error appear, the software works in background as a daemon application.

[Anonymous]

Little bit disappointing....
But, In order for this to work, you need to embed your application inside this job and not otherwise... These logs are captured for current jvm session of talend job and not for another...
Redirecting talend console logs are applicable or starts from main job and includes anything till the end of job.
Vaibhav

[Anonymous]

Little bit disappointing....
But, In order for this to work, you need to embed your application inside this job and not otherwise... These logs are captured for current jvm session of talend job and not for another...
Redirecting talend console logs are applicable or starts from main job and includes anything till the end of job.
Vaibhav

OK then
can you help me to do this?
TRowGenerator generates data and insert them into a table, how to say to talend: "i want user insert data with a form then do the job"?
Best regards,
G47

[Anonymous]

"i want user insert data with a form then do the job"?
then do the job"
>>
Which job?
Any other application is inserting data to table? Form is related to what?
what is the role of tRowGenerator?
Please explain.
vaibhav

[Anonymous]

"i want user insert data with a form then do the job"?
then do the job"
>>
Which job?
Any other application is inserting data to table? Form is related to what?
what is the role of tRowGenerator?
Please explain.
vaibhav

The user inserts with a form (for example in php).
I want my job sends me an email when there is a problem with the insertion

[Anonymous]

php is front end...
whether you are capturing and inserting error info into database, then it is possible. Else, let us know how talend would know about an error which is executing at server side?
Thanks
vaibhav