Hi all,
I am using JBOSS3.2.3 & Postgresql 7.4 and I am facing a problem wirting blobs ...
Using the postgres jdbc driver there are 2 ways for writing/reading blobs
1) using in the database a column type 'bytea' to store the binary file
2) using in the database a column type 'oid' to store the binary file and the
org.postgresql.largeobject.LargeObject API from the psql jdbc driver
In the standardjbosscmp-jdbc.xml exists only the mapping for the first solution :
<mapping> <java-type>java.lang.Object</java-type> <jdbc-type>VARBINARY</jdbc-type> <sql-type>BYTEA</sql-type> </mapping>
solution outofmemory jboss