You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Norman Maurer (JIRA)" <se...@james.apache.org> on 2006/09/10 11:32:23 UTC
[jira] Commented: (JAMES-342) Running James and Oracle 9.2 on
different machines
[ http://issues.apache.org/jira/browse/JAMES-342?page=comments#action_12433683 ]
Norman Maurer commented on JAMES-342:
-------------------------------------
What about this ? Anyone can confirm ?
> Running James and Oracle 9.2 on different machines
> --------------------------------------------------
>
> Key: JAMES-342
> URL: http://issues.apache.org/jira/browse/JAMES-342
> Project: James
> Issue Type: Bug
> Components: POP3Server
> Affects Versions: 2.2.0
> Reporter: Olga Agady
>
> I didn't copy all the exception I was getting during testing, but the bug I found I fixed, and I will try to describe it below:
> I am running James and Oracle 9.2 on different machines. When I limit the message size in the config file, I get the following exception in POP3Handler: SQLException "Illegal use of LONG type". I believe that this is an issue of running Oracle remotely (I found and article about dbms_lob.getlength() describing this issue). When I disable limiting the message size, I've got the IOException "Wrong column type". The exception is thrown at MimeMessageJDBCSource.getInputStream() at the lines:
> if (getBodyOption != null && getBodyOption.equalsIgnoreCase("useBlob")) {
> Blob b = rsRetrieveMessageStream.getBlob(1);
> headers = b.getBytes(1, (int)b.length());
> } else {
> headers = rsRetrieveMessageStream.getBytes(1);
> }
> I uncommented "if" statement and left only line:
> headers = rsRetrieveMessageStream.getBytes(1);
> Then I was able to get the messages from the inbox.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org