On Monday 26 April 2004 06:40 am, Noel J. Bergman wrote: > > I did not yet try to change table types, but i will do so as soon > > as i find the time. > > Thanks. >
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. 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. 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. 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? Greetings, AVee --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
