Hello, when adapting the RDBMSAdapter to Postgres 7.3, I run into serious trouble, so I would prefer to support only Postgres 7.4. Does anybody need support for older Postgres versions?
Problem with Postgres 7.2 and 7.3 is the content. There are two ways to store large binary data in Postgres, the bytea datatype and LargeObjects. Access to bytea using jdbc is very memory consuming for Postgres 7.3. Its unusable for data larger than approximately 4 MByte. This was a problem of the client/server protocol, which is fixed in 7.4. LargeObject works for much larger data. I tested it using files up to 100 MB. However it requires access to the LargeObject extensions of the JDBCDriver. Those are only available, if you cast the java.sql.Connection to a org.postgresql.PGConnection. But this is problematic, if you access the database through a connection pool. IIRC you could get a handle to the underlying connection in commons-dbcp, but that's a hack. I never used Postgres 6.x, but you glimpse into the mail archives makes me fear, things are even worse there. So I would prefer to support only Postgres 7.4 and use the bytea datatype. WDYT? Martin -- Martin Holz <[EMAIL PROTECTED]> Softwareentwicklung / Vernetztes Studium - Chemie FIZ CHEMIE Berlin Franklinstrasse 11 D-10587 Berlin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
