[ http://issues.apache.org/jira/browse/JAMES-342?page=all ]
Norman Maurer resolved JAMES-342. --------------------------------- Resolution: Cannot Reproduce > 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]