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> | Using this solution I get an OutOfMemory Exception form my Container Managed Bean when I am tying to write a binary file larger than 1 Mbyte. In order to make some tests I developed a standalone java-client to access the DB using the jdbc driver. Also the same exception occurs in this scenario. But using the second configuration in the database and the org.postgresql.largeobject.LargeObject API form the jdbc I was able to read/write blobs form the database using the standalone java client ! Does anyone has any idea how we can configure JBOSS to access the DB using this API ??? Thanks in advance George View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839530#3839530 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839530 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
