| From: | tjm2(at)mail(dot)ikasths(dot)dk (Troels Jegbjaerg Moerch) |
|---|---|
| To: | <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | JDBC Interface Using Large Objects |
| Date: | 2000-09-28 07:54:21 |
| Message-ID: | 002901c02921$500af990$97bfedd4@pc4151 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
Hi
I am using the JDBC 7.0-1.2 driver, PostgreSQL 7.02 Database and JDK 1.3 on Linux Red Hat 7.0. Almost everything works great. But when I am trying to insert a file into my postgresql database I get this error:
SQLException: InputStream as parameter not supported
Here is my code:
File file = new File(theFile);
FileInputStream fis = new FileInputStream(file);
PreparedStatement ps = con.prepareStatement("insert into music(ID,
BinaryData) values (?,?)");
ps.setString(1,1);
ps.setBinaryStream(2,fis,(int)file.length());
ps.execute();
ps.close();
fis.close();
The exception is thrown in this line:
ps.setBinaryStream(2,fis,(int)file.length());
Anybody know what is wrong?
TJM
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jens Carlberg | 2000-09-28 09:21:03 | Re: Newlines in String inserts with JDBC |
| Previous Message | Friedman, Eric | 2000-09-28 00:33:58 | RE: Newlines in String inserts with JDBC |