insert problem in oracle

[visu Nekk]

package OrclDb;
 
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.*;
import com.oreilly.servlet.MultipartRequest;
 
public class Upload extends HttpServlet
{
  public void service(HttpServletRequest req,HttpServletResponse res)
      throws ServletException,IOException
  {
    PrintWriter out = res.getWriter();
    MultipartRequest multi = new MultipartRequest(req,"C:\\HR\\Resumes",5*1024*1024);
    String s1 = multi.getParameter("id");
       
    try
    {
      Class.forName("oracle.jdbc.driver.OracleDriver");
 
      Connection con = DriverManager.getConnection("jdbc  :-o	  racle:thin:@10.11.32.86:1521:Resumedb","scott","tiger");
      con.setAutoCommit(false);
      Statement stmt = con.createStatement();
 
      String sql = "insert into test values("+s1+",empty_blob())";
      stmt.execute(sql);
      BLOB blob;
      ResultSet rs = stmt.executeQuery("select resume from test where ID="+s1+" for update");
      rs.next();
      blob = ((OracleResultSet)rs).getBLOB(1);
      File binaryFile = multi.getFile("cv");
      System.out.println("s2 : " + binaryFile);
      System.out.println("file length = " + binaryFile.length());
      FileInputStream instream = new FileInputStream(binaryFile);
      OutputStream outstream = blob.getBinaryOutputStream();
      int size = blob.getBufferSize();
      byte[] buffer = new byte[size];
      int length = -1;
      while ((length = instream.read(buffer)) != -1)
      outstream.write(buffer, 0, length);
      instream.close();
      outstream.close();
     
    }catch(Exception e)
    {
      out.println(e);
    }
  }
}

Using the code above i tried to insert into oracle database.neither i am getting any error nor the data is going to the database.Can anyone help me out.

[added code tags]
[ October 03, 2005: Message edited by: Jeanne Boyarsky ]

[Jeanne Boyarsky]

Do the println statements display anything? Do you know that the select stmt returns something?

[dema rogatkin]

setAutoCommit to true, all do connection.commit when finish