[prev in list] [next in list] [prev in thread] [next in thread] 

List:       james-dev
Subject:    [jira] Created: (JAMES-342) Running James and Oracle 9.2 on different machines
From:       "Olga Agady (JIRA)" <server-dev () james ! apache ! org>
Date:       2004-12-31 6:28:38
Message-ID: 1420213870.1104474518207.JavaMail.apache () ajax ! apache ! org
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]