This discussion is archived
2 Replies Latest reply: Oct 20, 2012 9:38 AM by Subramanian Meyyappan RSS

Mail sending

Subramanian Meyyappan Expert
Currently Being Moderated
hi Folks,

first fall i would like to say thanks for these kind of forums for sharing/grasping/ helping the peoples.

ok. am farily new to send mail through out the program(oracle/java).

before i creating thread. i search out lot of docs/blogs/threads. for sending mail through out the program(oracle/java).

here i want summarizse what i did?

Note:
i pick out some of the code snippets of java program for sending mail across one domain to another domain.
say as example. x.gmail.com to y.mycompanydomain.com

it's working fine. i tested out.

my testcase
if am going with same program make it java stored procedure means call through out db function means
most common error i having
tls command enable first.
if am enable tls means next error message is popuping up say as no provider for smtp.
while am googling for these error they says two of jar file should be placed in your class path.
in which class path they are saying i cant get them

am using oracle db 10g
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
my problem is :
if am x.gmail.com to y.mycompanydomain.com mail are not sending.

one good news is:
if am x.mycompanydomain.com to y.mycompanydomain.com means mail are sending.

how do i solve my problem.
  • 1. Re: Mail sending
    bshannon Pro
    Currently Being Moderated
    There's a lot of confusion in your message...

    First, let me say that I'm not an expert in the use of Java in the Oracle database,
    so if your problem is related to that you may need to get help in a different forum.
    I would strongly suggest that you get everything working with a simple test program
    that runs outside of the database, then move the working JavaMail code and
    configuration into the database program.

    As for your problem...

    Enabling TLS shouldn't change whether or not it correctly finds the "smtp" provider.

    Since you can send mail within your company, but not send mail outside your
    company, most likely your mail server is refusing to send mail outside your company
    without knowing who you are, which means you need to be sure to authenticate to the
    server before sending. This JavaMail FAQ entry tells you how to do that:
    http://www.oracle.com/technetwork/java/javamail/faq/index.html#smtpauth

    If that's still not working, turn on Session debugging (see the FAQ) and post the
    debugging out.
  • 2. Re: Mail sending
    Subramanian Meyyappan Expert
    Currently Being Moderated
    Since you can send mail within your company, but not send mail outside your
    company, most likely your mail server is refusing to send mail outside your company
    without knowing who you are, which means you need to be sure to authenticate to the
    server before sending.
    Perfect. you get me. :)

    thanks :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points