Thread: JDBC and LOB

JDBC and LOB

From
Gabriel López Millán
Date:
    Hi, I try to run  this example:

     String query = "INSERT INTO requestTable VALUES (?,?);";
     int i = 1;

     PreparedStatement ps =
(PreparedStatement)connection.prepareStatement(query);
     ps.setInt(1,i);
     ByteArrayInputStream bis = new ByteArrayInputStream(b);
     ps.setBinaryStream(2,bis,bis.available());
     ps.executeUpdate();        // execute the insert statement
     System.out.println("ejecuta");
     ps.close();                // close the prepared statement
     bis.close();

     where de segundo parameter is a oid type.

    The response is:


    SQL Exception: InputStream as parameter not supported

    What tipes of InputStream are supported?
    Where can I find more information?

    Thanks, Gabi.