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

Reply via email to