> I thought I can simply add the oracle retrieveMessageBodySizeSQL like this :
> <sql name="retrieveMessageBodySizeSQL" db="oracle">
> SELECT length(message_body) FROM ${table}
> WHERE message_name = ? AND repository_name = ?
> </sql>
> I try to retrieve that email use outlook, an error occur at outlook
Check the logs, but length() doesn't appear to be defined by Oracle to work on long
raw columns. Find out what does. Also, if you are using newer versions of Oracle,
they recommend converting long raw to BLOB. I don't use Oracle, but hopefully you can
find an Oracle DBA to help you out. :-)
> What is actually the purpose that James retrieveMessageBodySize ? in
> fact that this is optional.
It just lets the POP3 handler tell the client how big the message will be, which is
why it is optional.
--- Noel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
