I am using jboss seam …and richfaces .. for file upload..

I used bytea for storing image into daatabase … in postgres 8.3
I got exception

is of type bytea but expression is of type Integer…
Then i change to OID datatype same as bolb in oracle…. .

This is my java class :

private byte[] brandingLogo;

@Column(name = “branding_logo” ;)
@Lob
public byte[] getBrandingLogo() {
return this.brandingLogo;
}

public void setBrandingLogo(byte[] brandingLogo) {
this.brandingLogo = brandingLogo;
}

public void fileUploadListener(UploadEvent event) throws Exception{

upload = event.getUploadItem();
if (upload.isTempFile()) {
file = upload.getFile();
} else {
ByteArrayOutputStream b = new ByteArrayOutputStream();
b.write(upload.getData());
}
}

public UploadItem getUpload() {
return upload;
}

public void setUpload(UploadItem upload) {
this.upload = upload;
}

public File getFile() {
return file;
}

public void setFile(File file) {
this.file = file;
}

But when i store it…
id | branding_logo
—+—————
1 | 206533
2 | 206534
3 | 206535
9 | 206543
7 | 206537

How can i identify that is store the image… in database..
I guess it store sequence number…

Please help me…
shashi

Hi,



Well, you can just write the code to read the data from the database again. Alternatively you can use some SQL commands to verify the data. See http://www.postgresql.org/docs/8.1/static/lo-funcs.html.

--Hardy