2 Replies Latest reply: Oct 20, 2012 11:38 AM by Subramanian Meyyappan RSS

    Mail sending

    Subramanian Meyyappan
      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-Oracle
          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
            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 :)