unimplemented or unreasonable request at ps.execute()

[Sidhu roy]

import java.io.*;
import java.sql.*;
import java.util.*;
class Pic3
{
   Statement s;
   Connection c;
   FileInputStream fis;
   PreparedStatement ps;
   File file;
   Pic3()
   {
    try
    {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     c=DriverManager.getConnection("Jdbc:Odbc:sidhu","system","system");
     s=c.createStatement();
     s.execute("Create table Img(Image_No number(5),Photo blob)");
    }
    catch(Exception e1)
    {
     e1.printStackTrace();
    }
    try
    {
     file=new File("f://sidhu//jdbc//image.jpeg");
     fis=new FileInputStream(file);
     String str="insert into Img values(?,?)";
     ps=c.prepareStatement(str);
     ps.setInt(1,(int)file.length());
     ps.setBinaryStream(2,fis,(int)file.length());
     //System.out.println("success");
     ps.execute();
     ps.close();
     c.close();
    }
    catch(SQLException e)
    {
     e.printStackTrace();
    }
    catch(Exception e1)
    {
     e1.printStackTrace();
    }
}
   public static void main(String args[])
   {
     Pic3 pic3=new Pic3();
   }
}

i am getting error as unimplemented or unreasonable request at ps.execute(). please help me

[Jeanne Boyarsky]

Does s.execute("Create table Img(Image_No number(5),Photo blob)"); run successfully? I ask because you catch the exception but then continue on. If that doesn't run, all bets are off for what happens later in the program.

The actual error is about a type conversion error. I don;t usually pass the length as a second parameter to setBinaryStream. You might try without that.

[Jeanne Boyarsky]

Also, what database are you using? Different databases support Blobs in different ways. (or not at all)

[Sidhu roy]

thank you Jeanne Boyarsky . ya i am using oracle 10g database and the table is created in the database , what you said is right. problem is with typecasting so, i tried ps.setBinaryStream(2,fis,(byte)file.length());
rather than
ps.setBinaryStream(2,fis,(int)file.length());
so, it worked properly. is it correct? can i approach in this way??

[Paul Clapham]

Jeanne Boyarsky wrote:Also, what database are you using? Different databases support Blobs in different ways. (or not at all)

The posted code uses the JDBC-ODBC bridge driver. I wouldn't be at all surprised to find out that it doesn't support blobs, even if the underlying database does.

[Sidhu roy]

thank you Paul Clapham, then what i should use??

[Sudheer Bhat]

Your best bet would be to use Oracle's JDBC drivers.

[Ashish Agre]

Well a bit off track answer from my side sorry for this... but i would rather suggest you to store the image path in the database instead of image itself.
So that either it is a web application or desktop application you only need to provide the path for the image to display. It may be Label component for desktop or img tag of the web-page.
The only thing you require to do is to save image file in some specific folder and store its path in the database and then retrieve it later to display.

Thankyou.