store the image into database in netbeans

[chikku]

I have a image package consisting of images and they are displayed in a jlabel.I used the code below for that

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

Image im=new ImageIcon(this.getClass()
.getResource("/images/" + imageNames[index])).getImage();
ImageIcon iconLogo = new ImageIcon(im);
jLabel5.setIcon(iconLogo);
}
Now I want to store the image displayed in the jlabel into the database(oracle).From the above code I dont know how to get the absolute path of the images.can anyone help to store the image as blob datatype in the database.Created a table hard(name varchar2(10),img blob).Thank you.

[wsaryada]

Show us some code on what you have tried so far? We might be able to help.

[gimbal2]

There isn't necessarily an absolute path, the image is loaded from the classpath which might just be inside a jar or somewhere else "not directly on disc". You could create a ClassLoader that loads stuff from the internet if you'd want.

But that doesn't matter, you don't need an absolute path. Only an InputStream. And guess what: there is also a getResourceAsStream() method.

[chikku]

Sir,I searched a lot.But I didnt get a solution for this.See in the above code image object 'im' is displayed on the jlabel.By converting this 'im' into bytes I can store it into the database.But I have no idea about how to convert 'im' to bytes?

[chikku]

@gimbal2:I am taking the images from a image folder within the project.But I dont know how to convert the
Image im=new ImageIcon(this.getClass().getResource("/images/" + imageNames[index])).getImage();
into some other form to store into the db.

[gimbal2]

I can only conclude that you did not in fact write the code that you posted but you just copy/pasted it from somewhere, or else my earlier comment would have made sense to you.

this.getClass().getResource("/images/" + imageNames[index])

With this code you load the image from the classpath.

In this case you're using getResource(), but there is also a getResourceAsStream() which will provide you an InputStream with which you can load the image again so the bytes can be transmitted to the database. If you don't know how to do that, I suggest you get a good book on JDBC and to do some reading on how to use IO streams.

[chikku]

ok sir

[gimbal2]

Quite advanced stuff for someone who is very new. I'd start with the basics first if I were you, cutting corners is only going to make you confused and angry.

[JosAH]

I don't think the OP can manage; at least to me that blob interface works 'the other way around'; you get an OutputStream that is supposed to write content to the blob and an InputStream retrieves a value from an existing blob; I once managed to get the stuff working by using PipedOutputStreams and PipedInputStreams that encapsulated the other streams ... quite tricky and there is no 'command' as the OP might have hoped for, that does the trick ...

kind regards,

Jos