Re: having prolems with CMP, PostgreSQL, and Serializable
I stand corrected. Last time I looked, which actually was longer ago than it seemed - time flies, the setBinaryStream() threw the exception directly. When people in our organization tried out new versions they informed me that the code had changed, but it still didn't work. My bad. /Marcus On Wed, 2001-11-21 at 22:55, Mike Cannon-Brookes wrote: > 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: > > > > > > > > > > > > > > > > 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.comICQ#: 4564879 > > > > > > > > > -- Marcus Ahnve email: [EMAIL PROTECTED] Lecando AB Office: +46-(0)8-634 94 18 Sweden Mobile: +46-(0)70-462 19 18 www.lecando.comICQ#: 4564879
Re: having prolems with CMP, PostgreSQL, and Serializable
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: > > > > > > > > > > > > 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.comICQ#: 4564879 > > >
Re: having prolems with CMP, PostgreSQL, and Serializable
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: > > > > > > > > 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.comICQ#: 4564879
Re: having prolems with CMP, PostgreSQL, and Serializable
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: > > > > 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/
having prolems with CMP, PostgreSQL, and Serializable
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: I am using postgres 7.1 and orion 1.5.2 I would appriciate any advice anyone had for me. thanks mike o'connor