Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem getting Maildata with Mail_Client Package

Frank LehmannSep 26 2022

Hi helpers,
i am using the mail_client package from github since several years.
Now i have changed the database from 12c to 21c.
I have installed the package again and now i have a problem to receive mails.
If i use my own mailserver at mail.dashandwerk.net with port 993 (IMAP), i can read the mail content in the inbox.
But when using imap.gmx.net or outlook.office365.com with same port 993 it is not working.
I have a testcase to test, if the problem is the server itself, or the database.
The testcase is a java procedure which uses this classpath %ORACLE_HOME%/lib/javax.mail.jar
And when using other mailserver than my own i can not see any firewall listing either drop nor allow. Nothing.
The error message from the java call within the databse is
com.sun.mail.util.MailConnectException: Couldn't connect to host, port: imap.gmx.net, 993; timeout -1;
nested exception is:
java.net.SocketTimeoutException: Operation timed out
This behaviour i have posted to oracle support and created a service request. But it seems they haven't a solution and the SR is waiting over 20 days.
jvm_TestCase.zip (67.31 KB)

Comments

Processing

Post Details

Added on Sep 26 2022
0 comments
117 views