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

-- 
I hooked up my accelerator pedal in my car to my brake lights.  I hit the gas,
people behind me stop, and I'm gone.  -- Steven Wright

_______________________________________________________________

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