Thx to Noel J. Bergman,
as You said (I used oracle), :) 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>
Then I try to restart James, send an email (this works, coz I can see
that message is in a table named inbox), but then I try to retrieve that
email use outlook, an error occur at outlook like this :
An unknown error has occurred. Account: 'red', Server: 'localhost',
Protocol: POP3, Server Response: '-ERR', Port: 110, Secure(SSL): No,
Server Error: 0x800CCC90, Error Number: 0x800CCC93
Looks like, that James respons an -ERR msg, I was thinking that the
above sql statement not supported by oracle or there are other setup
must be done.
What is actually the purpose that James retrieveMessageBodySize ? in
fact that this is optional.
Whats going on again (especially to Noel J. Bergman) ? thx be4 :)
Can I just turn off the retrieveMessageBodySize in James so it doesn't
echoes "no SQL statement to find size" again ?
-----Original Message-----
From: Noel J. Bergman
Sent: Kamis 17/07/2003 9:32
To: James Users List
Cc:
Subject: RE: no SQL statement to find size
James only has retrieveMessageBodySizeSQL support for mssql,
mysql, hypersonic and postgresql. If you are using something else,
e.g., Oracle, you'll need to insert a statement into sqlResouces.xml.
Feel free to submit a patch.
--- Noel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
