Добрый день(если день)
Вопрос по сабжу.
Есть класс SendMail (код ниже)
В 10 оракле все работает .
Перешли на 11 и при обращении к тому же SMTP серверу получаем

javax.mail.SendFailedException: Sending failed;
nested exception is:
javax.mail.MessagingException: SMTP can only send RFC822 messages
javax.mail.MessagingException: SMTP can only send RFC822 messages

падает на строчке
Transport.send(msg);

В чем грабли? Я стащил javax.mail.jar с https://java.net/projects/javamail/pages/Home#Download_JavaMail_1.5.2_Release
просто, чтобы проверить свой класс.
Проверил класс в Eclipse - работает , а из под базы - не работает
Я не знаю какой mail.jar находится в самой базе(кстати, как узнать какие jar стандартные в базе загружены?)

----------------------------------------------------------------------------------------
create or replace and compile java source named "SendMail" as
import java.util.*;
import java.io.*;
import javax.mail.*;
import javax.mail.internet.*;
import javax.activation.*;
public class SendMail {
// Sender, Recipient, CCRecipient, and BccRecipient are comma-separated lists of addresses.
// Body can span multiple CR/LF-separated lines.
// Attachments is a ///-separated list of file names.

public static int Send(String SMTPServer,
String Sender,
String Recipient,
String CcRecipient,
String BccRecipient,
String Subject,
String Body,
int BodyType,
String ErrorMessage[],
String Attachments) {
// Error status;
int ErrorStatus = 0;

Properties props = System.getProperties();
props.put("тратата", SMTPServer);

props.setProperty("mail.transport.protocol", "smpt");
props.setProperty("mail.host", SMTPServer);
props.setProperty("mail.user", "");
props.setProperty("mail.password", "");

Session session = Session.getDefaultInstance(props, null);

try {
// Create a message.
MimeMessage msg = new MimeMessage(session);

// extracts the senders and adds them to the message.
// Sender is a comma-separated list of e-mail addresses as per RFC822.
{
InternetAddress[] TheAddresses = InternetAddress.parse(Sender);
msg.addFrom(TheAddresses);
}

// Extract the recipients and assign them to the message.
// Recipient is a comma-separated list of e-mail addresses as per RFC822.
{
InternetAddress[] TheAddresses = InternetAddress.parse(Recipient);
msg.addRecipients(Message.RecipientType.TO,TheAddresses);
}

// Extract the Cc-recipients and assign them to the message;
// CcRecipient is a comma-separated list of e-mail addresses as per RFC822
if (null != CcRecipient) {
InternetAddress[] TheAddresses = InternetAddress.parse(CcRecipient);
msg.addRecipients(Message.RecipientType.CC,TheAddresses);
}

// Extract the Bcc-recipients and assign them to the message;
// BccRecipient is a comma-separated list of e-mail addresses as per RFC822
if (null != BccRecipient) {
InternetAddress[] TheAddresses = InternetAddress.parse(BccRecipient);
msg.addRecipients(Message.RecipientType.BCC,TheAddresses);
}

// Subject field
msg.setSubject(Subject);

// Create the Multipart to be added the parts to
Multipart mp = new MimeMultipart();

// Create and fill the first message part
{
MimeBodyPart mbp = new MimeBodyPart();

if (BodyType == 1)
mbp.setContent(Body, "text/html;\n charset=\"UTF-8\"");
else
mbp.setText(Body);

// Attach the part to the multipart;
mp.addBodyPart(mbp);
}

// Attach the files to the message
if (null != Attachments) {
int StartIndex = 0, PosIndex = 0;
while (-1 != (PosIndex = Attachments.indexOf("///",StartIndex))) {
// Create and fill other message parts;
MimeBodyPart mbp = new MimeBodyPart();
FileDataSource fds =
new FileDataSource(Attachments.substring(StartIndex,PosIndex));
mbp.setDataHandler(new DataHandler(fds));
mbp.setFileName(fds.getName());
mp.addBodyPart(mbp);
PosIndex += 3;
StartIndex = PosIndex;
}
// Last, or only, attachment file;
if (StartIndex < Attachments.length()) {
MimeBodyPart mbp = new MimeBodyPart();
FileDataSource fds = new FileDataSource(Attachments.substring(StartIndex));
mbp.setDataHandler(new DataHandler(fds));
mbp.setFileName(fds.getName());
mp.addBodyPart(mbp);
}
}

// Add the Multipart to the message
msg.setContent(mp);

// Set the Date: header
msg.setSentDate(new Date());

// Send the message;

Transport.send(msg);
} catch (MessagingException MsgException) {
ErrorMessage[0] = MsgException.toString();
Exception TheException = null;
if ((TheException = MsgException.getNextException()) != null)
ErrorMessage[0] = ErrorMessage[0] + "\n" + TheException.toString();
ErrorStatus = 1;
}
return ErrorStatus;
} // End Send Class
} // End of public class SendMail
/
----------------------------------------------------------------------------------------
create or replace FUNCTION JSendMail(SMTPServerName IN STRING,
Sender IN STRING,
Recipient IN STRING,
CcRecipient IN STRING,
BccRecipient IN STRING,
Subject IN STRING,
Body IN STRING,
BodyType IN NUMBER,
ErrorMessage OUT STRING,
Attachments IN STRING) RETURN NUMBER IS
LANGUAGE JAVA
NAME 'SendMail.Send(java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
int,
java.lang.String[],
java.lang.String) return int';
/
------------------------------------------------------------------------------------
create or replace FUNCTION SendMail(Sender IN STRING,
Recipient IN STRING,
CcRecipient IN STRING,
BccRecipient IN STRING,
Subject IN STRING DEFAULT ' ',
Body IN STRING DEFAULT ' ',
BodyType IN NUMBER DEFAULT 0,
ErrorMessage OUT STRING,
Attachments IN STRING) RETURN NUMBER IS
v_mail_server мфксрфк2(2000);
BEGIN
select mail_server into v_mail_server from my_servers
if v_mail_server is null then
ErrorMessage := 'Mail Server is not defined';
RETURN(1);
else
RETURN JSendMail(v_mail_server,
Sender,
Recipient,
CcRecipient,
BccRecipient,
Subject,
Body,
BodyType,
ErrorMessage,
Attachments);
DBMS_OUTPUT.PUT_LINE('ErrorMessage is '|| ErrorMessage);
DBMS_OUTPUT.PUT_LINE('After JSendMail');
end if;
END SendMail;
/
-----------------------------------------------------------------------------------------------

Я нашел,как это лечится.
Не понимаю, почему именно это, нашел на каком то немецком сайте, по теме с этим не связанной, но факт - помогает.
После строчек
// Set the Date: header
msg.setSentDate(new Date());

нужно добавить

msg.saveChanges();

После этого мы начали получать другой стек ошибок, и вот это уже лечится путем
loadjava –r –v –f -u a/a@a mail-1.4.jar

mail-1.4.jar мы download с OTN.

видимо, в нашей версии
Oracle Database 11g Release 11.2.0.4.0 неправильный mail.jar