I tried changing the type from bytea to oid, PostgreSQL's blob type. This doesn't help much since James now failed to store the message to the spool.
Both JDBC drivers seem, from what I've read in the docs, to agree that the java blob type matches oid and that bytea is matched by byte array's. Looking at the code you can see that a blob is used to retrieve the message while a byte array is used to store it. For now my guess is that both blobs and byte arrays will work as long as the same thing for both storing and retrieving the message, wich is a good thing anyway i guess. The PostgreSQL driver might not be the only to treat these differently.
That sucks... would be nice if postgresql was usable.
The thing could be fixed easily by a try/catch construction wich first tries the blob and when it fails tries the byte array wich the old version used, but it's not really a very clean solution.
Yeah, I'd rather not customize James code for bad JDBC driver impls.
Another, somewhat related thing i noticed is the fact that Exceptions during mail storage are output to the mail session. This causes a multiline response in way that is irrc in violation of the SMTP rfc. Appart from the rfc violation it might be a good idea to hide these exceptions anyway.
That shouldn't be happening... you should just get a single error response line in SMTP and then the details get sent to a log.
Just out of curiosity, do you have any insight in what databases people use with james and wheter they are all tested with the RCs?
MySQL is the main. MS SQL and Oracle I know are also used (I used to use MS SQL until very recently and Oracle just had some patches come in). There's a sqlResources.xml file that shows how we have custom SQL statements for several databases... maybe SAP DB is another we support?
-- Serge Knystautas President Lokitech >> software . strategy . design >> http://www.lokitech.com p. 301.656.5501 e. [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
