image storing and retriving

[sreekanth malineni]

i write a code storing image into databse ,but its not working..
i take the fields in table is
Table :temp(id varchar2(10),image blob )
the id is inserted but the image storing is failed....

 
package imagestore;
import java.sql.*;
import java.io.*;
 
public class imagestore {
 
/**
 * @param args
 */
public static void main(String[] args) {
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc  :-o	  racle:thin:@ipoghome:1521  :-o	  rcl","scott","tiger");
System.out.println("connected");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select max(id) from temp");int i=0;

if(rs.next())
{
i=rs.getInt(1);
}
i++;
PreparedStatement pstmt=con.prepareStatement("insert into temp values(?,?)");
File f=new File("F:/hib/hib/WebRoot/MyJsp.jsp");
FileInputStream fis=new FileInputStream(f);
System.out.println(i);
pstmt.setInt(1,i);
byte[] b= new byte[fis.available()+1]; 
fis.read(b); 
pstmt.setBytes(2,b); 
//pstmt.setBinaryStream(2,fis,(int)f.length());
System.out.println("connected22222222222");
boolean ff=pstmt.execute();
if(ff)
System.out.println("The Image Sucessfully Stored");
else
System.out.println("The Image insertion Failed");
}
catch (Exception e)
{
e.printStackTrace();
}
 
}
 
}

[BPSouther: Added code tags]
[ December 01, 2008: Message edited by: Ben Souther ]

[Ben Souther]

sreekanth malineni,

This doesn't appear to be a servlet issue.
I'm going to move this thread to our JDBC forum where it will probably get a better answer.

[Suman Sharma]

I think the line should be:

    
      boolean ff = pstmt.executeUpdate();