Waseem
Waseem

Waseem

View Profile
  • 0
Contributor
Asked: 2021-09-02T18:37:42+05:30

Java call terminated by uncaught Java exception:

  • 0

Dear Sir,

I am using oracle database 11gr2 to connect to gmail and read messages.

but I facing this error while connecting to gmail.

ORA-29532: Java call terminated by uncaught Java exception: javax.mail.MessagingException: Connect failed;
nested exception is:
java.io.IOException: Couldn't connect using "javax.net.ssl.SSLSocketFactory" socket factory to host, port: imap.gmail.com, -1; Exception: java.lang.reflect.InvocationTargetException
ORA-06512: at "IMAGE.MAIL_CLIENT", line 16
ORA-06512: at "IMAGE.MAIL_CLIENT", line 35
ORA-06512: at line 2

mail_client

1 Answer

  1. Vinish Kapoor

    Vinish Kapoor

    View Profile
    Enlightened

    You need to give permissions using dbms_java.grant_permission() method. Below is an example:

    Login as SYS or System, then execute the following PL/SQL block by making the changes according to your schema and hostname:

    Begin
dbms_java.grant_permission('YourSchema',
'java.net.SocketPermission',
'yourHostname',
'resolve');
commit;

dbms_java.grant_permission('YourSchema',
'java.util.PropertyPermission',
'*',
'read,write');
commit;
End;
    • 0

You must login to can add an answer.