James and PostgreSQL 7.4.1

[Russ Ochsner]

I am unable to get James < 3.0 to work out of the box with Postgresql 
7.4.1 on Win2k (current Cygwin port) or MacOS X (JDBC v3 build 213) 
using Java 1.4.0 and 1.4.2 respectively.

I receive errors such as: spoolmanager.root: Exception calling 
RelayLimit: Unable to parse headers from stream: 
org.postgresql.util.PSQLException: Bad Integer Return-Path:...

I'm not sure if this is unique to my situation or if I am just 
overlooking something in the documentation, perhaps sqlResources.xml 
file?

In order for me to use PostgreSQL I had to modify 
org.apache.james.mailrepository.JDBCMailRepository.java and 
org.apache.james.mailrepository.MimeMessageJDBCSource.java. It appears 
that the PostgreSQL JDBC driver's Blob class does not support a bytea 
data type.



PostgreSQL works ok with these changes:

827,828c827
<                             Blob b = rsMessageAttr.getBlob(1);
<                             byte[] serialized_attr = b.getBytes(1, (int)b.length());
---
>                             byte[] serialized_attr = rsMessageAttr.getBytes(1); 
141,142c141,142
<             Blob b = rsRetrieveMessageStream.getBlob(1);
<             headers = b.getBytes(1, (int)b.length());
---
>             headers = rsRetrieveMessageStream.getBytes(1);
>             


I don't recall this as a problem with James v3.0 however.

Anyone have any comments?

Thanks,
Russ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]