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]