Actually the Postgres driver does support blobs in a number of ways. The 7.1 driver supports BLOBs using OIDs (a postgres specific measure) and the latest driver from CVS (due out with 7.2 shortly) supports bytea datatypes (which is a long byte array up to 1 gig in size) which is much nicer than an OID.
The problem is indeed Orion not setting autocommit=false which is needed by the Postgres driver. However the overhead involved in using a CMP bean with a large object is not a good idea IMHO, I'd create a simple session bean which persists your large object via JDBC and retrives it again. -mike On Thu, 2001-11-22 at 02:19, Marcus Ahnve wrote: > A _very_ late answer I know, but it is my firm belief that the reason > for this is that Postgresql JDBC driver does not support BLOB:s, it is > simply not implemented, hence the message. Check out the WebCVS and see > for yourselves. > > /Marcus > > On Fri, 2001-06-22 at 20:42, Phillip Ross wrote: > > Your problem is stemming from the fact that the Postgresql JDBC driver wants > > auto commit flag set to false before it can use setBinaryStream() method which > > is used to store the stream. Orion's entity bean wrapper seems to leave the > > flag alone and not set it to false explicitly. So, basicly, that's what causes > > it... but the proper solution to workaround or fix it is still something I'm > > playing around with. > > > > - Phillip > > > > > > --- [EMAIL PROTECTED] wrote: > > > I am trying to port an application that was running on JBOSS to > > > orion. All my Entity beans are using CMP. Whenever I try to create a > > > bean that has CMP field of type java.io.Serialazable i get the > > > following exception: > > > > > > javax.ejb.CreateException: Error creating EntityBean: InputStream as > > > parameter not supported > > > > > > here is the mapping from orion/config/database-schemas that I am > > > using: > > > > > > <type-mapping type="java.io.Serializable" name="oid" /> > > > > > > I am using postgres 7.1 and orion 1.5.2 > > > > > > I would appriciate any advice anyone had for me. > > > > > > thanks > > > > > > mike o'connor > > > > > > > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Get personalized email addresses from Yahoo! Mail > > http://personal.mail.yahoo.com/ > > > -- > Marcus Ahnve email: [EMAIL PROTECTED] > Lecando AB Office: +46-(0)8-634 94 18 > Sweden Mobile: +46-(0)70-462 19 18 > www.lecando.com ICQ#: 4564879 > > >
