2

I am trying to configure JavaMail in my Oracle 11g XE(11.2.0.2.0) database, which requires loadjava utility. But after some research I came to know that XE version of Oracle doesn't provide Java/JVM as some restriction in Free version of database.

I can not install Licence Version of Database, but want to install/configure Java service in my XE database if possible.

I was following this post How To Install Oracle JVM, but not able to locate /javavm/install/initjvm.sql in my oracle directory.

if anyone knows some solution, help would be appreciable.

2

No way how to do that. XE version does not support Java Stored Procedures. You have to upgrade at least to "Standard Edition One" or "Oracle Personal Edition".

See edition comparsion.

| improve this answer | |
  • Kindly mark the answer as correct so that others with the same problem can find an answer. – Vérace May 18 '15 at 18:20
1

Not supported.

If you want to send e-mails (JavaMail?) from the database, you do not need Java in the database for that, just use the UTL_MAIL package, available in XE as well.

| improve this answer | |
  • thanks for your response, I was actually using UTL_MAIL only, but clients were getting some emails after 8 minuts, and sometimes after half day, even I am pushing mail queue each time. also we want to send Authenticated Mail, so I am trying to configure JavaMail (FYI, I am using Oracle APEX) – 124 May 18 '15 at 13:19
  • 1
    OT: if you want investigate problems with email you should set SMTP_SERVER to localhost on your DB server. Then Oracle will imediatelly handover email to Sendmail/Postfix and then it's MTAs problem. In the /var/log/maillog you will find a reason why email delivery was postponed. And Unix admins usualy know what to do in these cases. – ibre5041 May 18 '15 at 13:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.