setBlob() method fro preparedstatement

[rakesh kadulkar]

Hi,
I am trying to insert a video into oracle database using setBlob() mwthod of the PreparedStatement interface.
My code is compiling sucesfully but i am getting a runtime error.

My code is:

    
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.sql.rowset.serial.*;

public class Blob {
  
  public static void main(String[] args) throws Exception, IOException, SQLException {

	Class.forName("oracle.jdbc.OracleDriver");
    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@saraswati:1521:oracle9","scott","tiger");
    String INSERT_PICTURE = "insert into blob1 values (?)";

    FileInputStream fis = null;
    PreparedStatement ps = null;
    try {
      conn.setAutoCommit(false);
      File file = new File("1.wma");
      fis = new FileInputStream(file);
	  byte b[] = new byte[(int)file.length()];
	  fis.read(b);
	  System.out.println(b.length);
	  java.sql.Blob b2 = new SerialBlob(b);
      ps = conn.prepareStatement(INSERT_PICTURE);
      ps.setBlob(1,b2);
      ps.executeUpdate();
      conn.commit();
	  System.out.println("Record inserted successfully");
    } catch(Exception ex){
		ex.printStackTrace();
		throw ex;
	}
	finally {
      ps.close();
      fis.close();
    }
}
}

The error is:
AbstractMethodError
oracle.jdbc.driver.OraclePreparedStatement .setBlob() at line 29

please help

[Tim McGuire]

check out the docs for preparedStatement:
http://java.sun.com/javase/6/docs/api/java/sql/PreparedStatement.html

Use setBinaryStream instead of setBlob as the changes below :

    
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.sql.rowset.serial.*;

public class Blob {
  
  public static void main(String[] args) throws Exception, IOException, SQLException {

	Class.forName("oracle.jdbc.OracleDriver");
    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@saraswati:1521:oracle9","scott","tiger");
    String INSERT_PICTURE = "insert into blob1 values (?)";

    FileInputStream fis = null;
    PreparedStatement ps = null;
    try {
      conn.setAutoCommit(false);
      File file = new File("1.wma");
      fis = new FileInputStream(file);
      ps = conn.prepareStatement(INSERT_PICTURE);
       

       ////////////
      //     
      //ps.setBlob(1,b2);
      // 
      ////////////////

 // instead of setBlob use setBinaryStream :
      ps.setBinaryStream(1,fis,fis.available();
      ps.executeUpdate();
      conn.commit();
	  System.out.println("Record inserted successfully");
    } catch(Exception ex){
		ex.printStackTrace();
		throw ex;
	}
	finally {
      ps.close();
      fis.close();
    }
}
}