Re: [JBoss-user] Postgresql URL mapping

2002-05-14 Thread danch
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

Re: [JBoss-user] Postgresql URL mapping

2002-05-14 Thread Simon Stewart
On Tue, May 14, 2002 at 03:00:12PM +0100, 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 impossi

Re: [JBoss-user] Postgresql URL mapping

2002-05-14 Thread Dain Sundstrom
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? Thanks, -dain Simon Stewart wrote: > When trying to store BLOBs into a postgres database, the CMP engine > attempts to create tables with column types o

[JBoss-user] Postgresql URL mapping

2002-05-14 Thread Simon Stewart
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) in