Storing a image into DB

See more:

Java

Oracle

Hi all,

Am trying a sample application in java using Spring framework. The task
is to store am image into Database a byte array. For this am declaring the image field type as BLOB (in Oracle).

And in the java am executing following code to convert image to byte array.

File file = new File(path);
	        byte[] bFile = new byte[(int) file.length()];

	        try {

	        	FileInputStream fis=new FileInputStream(path);
	    		bFile = new byte[fis.available()+1];
	        } catch (Exception e) {
	            e.printStackTrace();
	        }
	        user.setImage(bFile);
			getHibernateTemplate().save(user);

where "path" is the path to the image.

But when I try to see the data in the table am getting an error saying:

ORA-00932: inconsistent datatypes: expected NUMBER got BLOB

Can you provide any suggestion or solution to solve this issue?


Thanks
Yashwanth.