BLOB and PostgreSQL

[Efftinge, Sven]

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(AbstractJdbc1Statement
.java:1392)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement
.java:1398)

Any Ideas?

Sven

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