Dain Sundstrom wrote: > I don't know. Did postgres add a new type for blobs? I can create a > new mapping for postgres 7.2. Can you do a little research into this?
The SQL type for blobs in postgres 7.2 is BYTEA (byte array I assume). I've already added a new mapping in the 3.0 branch and HEAD (both for JAWS and for jbosscmp-jdbc). I'll be porting that back to 2.4.x jaws soon. danch > > Thanks, > > -dain > > Simon Stewart wrote: > >> When trying to store BLOBs into a postgres database, the CMP engine >> attempts to create tables with column types of "oid". However, using >> the latest JDBC driver from the postgres site with Postgres 7.2.1 it >> appears to be impossible to store URLs (and I suspect other BLOBs >> though I've not tested) into the database. >> >> Manually changing the column type of the table from "oid" to "bytea" >> solves this problem. >> >> Is this a bug, or am I just not using either JBoss or Postgres right? >> >> Cheers, >> >> Simon >> >> > > _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
