Send Mail to Multiple Address

[Anonymous]

Someone can help me to use tSendMail if i would send one mail to multiple address?
How can I put multiple address in TO BOX of tsendMail component?

[Anonymous]

Hi,
I have made a testing and everything is OK. Could you please check your setting? (smtp host: "smail.test.com"
smtp port :300)
In addition that, please click on "post reply" (not through the quick post") to upload your screenshots into forum.
Pay close attention on the limitation(20 images per post, each image must be less then 1024x768 pixels and 200 KB, png is preferred)

Best regards
Sabrina

[Anonymous]

Hi
My requirement is from more than one mysql table i have to take the details of the student
like name|roll_no|marks|email_id
and i have to send a notification email to the student whose marks is less than 50.
i am using gmail as smtp server.
Please do the needful.
Regards,
Chandan Kumar Sah

[Anonymous]

Hi,
For your goal, you can use tfilterrow to filter the student whose marks is less than 50 then set email.
To make it clear, I have designed a simple demo job: tfileinputxxx-->tfilterrow-->filter-->tflowtoiterate-->tfixedflowInput-->tsendmail
-->reject-->tfileoutputxxx
See my screenshots for detail
Best regards
Sabrina

[jagadish_dasari]

Hi,
Please find the screenshots which are just samples of your requirements.
Hope this should get you started.
sorry, for images are not in order.
Thanks,
Jagadish.

[Anonymous]

Hi Chandan Kumar Sah,
Is it working for your current job requirement?
Best regards
Sabrina

[Anonymous]

Hi Xdshi,
In my job there is only one tsend mail component by which i am trying to send mail.
in which i am using my gmail id to send the mail.
gmail server setting is :
smtp server--- "smtp.gmail.com"
port- 465
ssl support- Checked
Need authentication-- checked
in which i have mentioned my gmail id and password
after running the job i am getting the below error
please do the needful.
Regards
Chandan
-----------------------------------------------------------------------------------------------------------------------------------
Exception in component tSendMail_1
javax.mail.MessagingException: Exception reading response;
nested exception is:
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1260)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
at javax.mail.Service.connect(Service.java:297)
at javax.mail.Service.connect(Service.java:156)
at javax.mail.Service.connect(Service.java:105)
at javax.mail.Transport.send0(Transport.java:168)
at javax.mail.Transport.send(Transport.java:98)
at orange_tsv.test_0_1.test.tSendMail_1Process(test.java:446)
at orange_tsv.test_0_1.test.runJobInTOS(test.java:664)
at orange_tsv.test_0_1.test.main(test.java:529)
Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
disconnected
at sun.security.ssl.Alerts.getSSLException(Unknown Source)
at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.ClientHandshaker.serverCertificate(Unknown Source)
at sun.security.ssl.ClientHandshaker.processMessage(Unknown Source)
at sun.security.ssl.Handshaker.processLoop(Unknown Source)
at sun.security.ssl.Handshaker.process_record(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
at sun.security.ssl.AppInputStream.read(Unknown Source)
at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:97)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:75)
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1440)
... 10 more
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.validator.PKIXValidator.doBuild(Unknown Source)
at sun.security.validator.PKIXValidator.engineValidate(Unknown Source)
at sun.security.validator.Validator.validate(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.validate(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.checkTrusted(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source)
... 23 more
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source)
at java.security.cert.CertPathBuilder.build(Unknown Source)
... 29 more

[Anonymous]

Hi Chandan,

javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

The error indicates that something wrong your certification(The server certification is expire or not to be trusted?).
Please check the related article http://stackoverflow.com/questions/6908948/java-sun-security-provider-certpath-suncertpathbuilderexc....
You can use TalendHelpCenter:tSetKeystore to import the certification.
Best regards
Sabrina

[Anonymous]

Hi Xdshi,
Thanks for your quick reply...
could you please elaborate the steps to solve this problem..

Thanks in advance...
Regards,
Chandan

[Anonymous]

Hi,
Firstly, you should understand how to create Keystore and Truststore file.
Please refer to article http://www.techbrainwave.com/?p=953.
Best regards
Sabrina

[Anonymous]

Hi Xdshi,
Sorry for the late reply...actually i was busy in other project..
my concern is when i am executing the job through internet dongle then the job is working fine but when i am executing the job through the secure LAN then it giving error
Exception in component tSendMail_1
javax.mail.MessagingException: Exception reading response;
nested exception is:
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1260)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
at javax.mail.Service.connect(Service.java:297)
at javax.mail.Service.connect(Service.java:156)
at javax.mail.Service.connect(Service.java:105)
at javax.mail.Transport.send0(Transport.java:168)
at javax.mail.Transport.send(Transport.java:98)
at orange_tsv.test_0_1.test.tSendMail_1Process(test.java:446)
at orange_tsv.test_0_1.test.runJobInTOS(test.java:664)
at orange_tsv.test_0_1.test.main(test.java:529)
Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
disconnected
at sun.security.ssl.Alerts.getSSLException(Unknown Source)
at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.ClientHandshaker.serverCertificate(Unknown Source)
at sun.security.ssl.ClientHandshaker.processMessage(Unknown Source)
at sun.security.ssl.Handshaker.processLoop(Unknown Source)
at sun.security.ssl.Handshaker.process_record(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
at sun.security.ssl.AppInputStream.read(Unknown Source)
at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:97)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:75)
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1440)
... 10 more
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.validator.PKIXValidator.doBuild(Unknown Source)
at sun.security.validator.PKIXValidator.engineValidate(Unknown Source)
at sun.security.validator.Validator.validate(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.validate(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.checkTrusted(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source)
... 23 more
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source)
at java.security.cert.CertPathBuilder.build(Unknown Source)
------------------------------------------------------------------------------------------------------------------------
Please let me know how can i avoid this error in the secure LAN.

Thanks in advance...
Regards,
Chandan kumar Sah