AW: BLOB and PostgreSQL

[Efftinge, Sven]

Ok I resolved it!
I have to use VARBINARY as JDBC-type.
Sven

> -----Ursprüngliche Nachricht-----
> Von: Efftinge, Sven [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 29. Januar 2003 09:49
> An: 'OJB Users List'
> Betreff: AW: BLOB and PostgreSQL
> 
> 
> I tried LONGVARBINARY as jdbc-type, also with no success.
> Has any one tried to store large objects with ojb in postgresql?
> 
> > -----Ursprüngliche Nachricht-----
> > Von: Efftinge, Sven [mailto:[EMAIL PROTECTED]]
> > Gesendet: Dienstag, 28. Januar 2003 16:24
> > An: 'OJB Users List'
> > Betreff: BLOB and PostgreSQL
> > 
> > 
> > Hi,
> > is there a way to use OJB (BrokerAPI) to store byte[] in a 
> > Postgresql DB?
> > My current config is:
> >     repository.xml :
> >             <class-descriptor
> >     class="my.package.name.Largeobject"
> >     table="largeobject"
> > >
> >     <field-descriptor 
> >             id="1"
> >             name="id"
> >         column="id"
> >             jdbc-type="INTEGER"
> >             primarykey="true"
> >             autoincrement="true"
> >     />
> > 
> >     <field-descriptor 
> >             id="2"
> >             name="binaries"
> >           column="binaries"
> >             jdbc-type="BLOB"
> >     />
> >     
> > </class-descriptor>
> > 
> > the Class looks like this:
> > 
> > public class Largeobject {
> >     protected java.lang.Integer id;
> >     protected byte[] binaries;
> > 
> >     public java.lang.Integer getId() {
> >             return id;
> >     }
> >     public byte[] getBinaries() {
> >             return binaries;
> >     }
> >     
> >     public void setId(java.lang.Integer aId) {
> >             id = aId;
> >     }
> > 
> >     public void setBinaries(byte[] _binaries) {
> >             binaries = _binaries;
> >     }
> > }
> > 
> > SQL like this:
> > CREATE TABLE "largeobject" (
> >             "id" INTEGER PRIMARY KEY ,
> >             "datei" bytea);
> > 
> > And the Error is :
> > [org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: 
> > SQLException during
> > the execution of the insert (for a
> > de.lohndirekt.ikarus.entities.dataobjects.Largeobject): 
> > Unbekannter Zieltyp
> > Unbekannter Zieltyp
> > Unbekannter Zieltyp
> >     at
> > org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(Abstract
> > Jdbc1Statement
> > .java:1392)
> >     at
> > org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(Abstract
> > Jdbc1Statement
> > .java:1398)
> > 
> > Any Ideas?
> > 
> > Sven
> > 
> > --
> > To unsubscribe, e-mail:   
> > <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail: 
> > <mailto:[EMAIL PROTECTED]>
> > 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]