james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olga Agady (JIRA)" <server-...@james.apache.org>
Subject [jira] Created: (JAMES-342) Running James and Oracle 9.2 on different machines
Date Fri, 31 Dec 2004 06:28:38 GMT
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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message