users@glassfish.java.net

Re: RE: How can I insert Blob data over 4000 byte with Toplink-Essential?

From: <glassfish_at_javadesktop.org>
Date: Sat, 02 Jun 2007 19:30:19 PDT

Hi Dave.

Thank you very much for your reply.

I have Oracle9i (9.2.0.6) and Oracle10g(10.2)

And I created a table like below.

SQL> create table Empimage ( id number, image blob);

Also, According to manual I already applied to Entity class like below .

@Entity
public class Empimage implements Serializable {
    ...
    @Lob
    @Basic(fetch=LAZY)
    @Column(name="IMAGE", columnDefinition="BLOB NOT NULL")
    private byte[] image ;

    public byte[] getImage() {
       return this.image ;
    }

   public void setImage( byte[] image )
       this.image = image ;
   }
    ...
}


I succeed in inserting image data under 4000 bytes.
But, I can't insert data over 4000 bytes.

I appreciate for you advice.
If do you have any sample, Would you like to send me it

Wildrose.
[Message sent by forum member 'wildrose' (wildrose)]

http://forums.java.net/jive/thread.jspa?messageID=220231