JDBC and LOB - Mailing list pgsql-general

From Gabriel López Millán
Subject JDBC and LOB
Date
Msg-id 3969A68F.C7DA777D@dif.um.es
Whole thread Raw
List pgsql-general
    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.



pgsql-general by date:

Previous
From: Holger Klawitter
Date:
Subject: Re: Counting affected rows
Next
From: Travis Bauer
Date:
Subject: SQL question