Running James and Oracle 9.2 on different machines
--------------------------------------------------

         Key: JAMES-342
         URL: http://issues.apache.org/jira/browse/JAMES-342
     Project: James
        Type: Bug
  Components: POP3Server  
    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
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to