Hi, I'm not an expert in this matter, maybe the ones in the know should comment on this.
We're been using PostgreSQL 7.2.1. For some reasons (i believe the new one is faster) we replaced the current jdbc driver (jdbc7.1-1.2.jar) with a new one (jdbc7.2dev-1.2.jar) and ran into troubles uploading images. It seems that in 7.2 PostgreSQL stores images in a different datatype (i learned this via Ricardo of IC&S who find it in www.dejanews.com searching for 'jdbc postgresql image 7.2' :-) >The behavior you are describing is correct for the 7.2 driver. In >7.2 the driver now uses the bytea datatype to store binary data (not >largeobjects as it did in 7.1 and earlier). This is documented in >the 7.2 documentation. Also in the doc is a description on how to >revert back to the old behavior. Look for: http://groups.google.com/groups?hl=en&lr=&ie=ISO-8859-1&q=jdbc+postgresql+image+7.2&btnG=Google+Search And: http://www.postgresql.org/idocs/index.php?datatype.html My questions now are the following: 1. Should the configuration file for PostgreSQL in MMBase in config/databases/postgresql71.xml be changed? Maybe into config/databases/postgresql72.xml? 2. And what exactly should i change? <type-mapping mmbase-type="BYTE">OID</type-mapping> into <type-mapping mmbase-type="BYTE">bytea</type-mapping> ? ---Cheers, Andr� -- Andr� van Toly CMS Developer for ilse media b.v. [EMAIL PROTECTED] +31-(0)20-8404559
