On Friday 20 June 2003 11:20 am, Peter Reitsma wrote: > I am experiencing problems inserting BLOB's into Postgresql 7.3.2: > > module.database.support.PostgreSQL71 - SQL : INSERT INTO cpb_images > (number, otype, owner, title, description, handle, itype, popup, notitie) VALUES (?, > ?, ?, ?, ?, ?, ?, ?, ?) > module.database.support.PostgreSQL71 - SQLState : null > module.database.support.PostgreSQL71 - ErrorCode: 0 > module.database.support.PostgreSQL71 - Message : ERROR: oidin: error in > "\377\330\377\340\000 > > I am a bit puzzled why the PostgreSQL71 class is used here for this BLOB insert. I > would expect the PostgreSQL72 class since handling of blobs changed in 7.2. Anyway, > I am using Postgresql 7.3.2 and things don't work. > Would this work properly on PostgreSQL7.2 ? Would it be hard for me to make the > appropriate code changes in the PostgreSQL class ? I am quite experienced in JDBC > programming. > >
change the OID to BYTEA in the postgress configuration
