From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Craig Jarman <cjarman(at)source(dot)com(dot)au> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: SQLException: ERROR: oidin: when loading GIF file |
Date: | 2001-11-11 19:22:31 |
Message-ID: | 200111111922.fABJMW901760@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I recommend you get our newer jdbc driver from jdbc.postgresql.org.
---------------------------------------------------------------------------
> Hi
>
> Has anyone run into difficulties uploading a blob to postgres?
>
> I am unable to load an image file into postgres using the jdbc7.1-1.3.jar driver.
>
> Application server runs on NT, Postgres on Linux 7.1
>
> Error received:
>
> java.sql.SQLException: ERROR: oidin: error in "GIF89a1.....
>
> Code:
>
> Class.forName("org.postgresql.Driver");
> Connection conn = DriverManager.getConnection("jdbc:postgresql://192.168.0.50:5432/ezweb","administrator","password");
> File file = new File("d:/Temp/testimage.gif");
> FileInputStream fis = new FileInputStream(file);
>
> PreparedStatement ps = conn.prepareStatement("INSERT INTO IMAGES VALUES (?, ?)");
> ps.setString(1, file.getName());
>
> Long length = new Long(file.length());
> ps.setBinaryStream(2, fis,length.intValue());
> ps.executeUpdate();
> ps.close();
> fis.close();
>
> Any pointers to what "oiden" refers to would be much appreciated.
>
> ______________________________
>
> Craig Jarman
> Source IT
> Ph: 612 9974 1480
> Fx: 612 9974 1280
> cjarman(at)source(dot)com(dot)au
> ______________________________
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-11-11 19:23:04 | Re: SQLException: ERROR: oidin: when loading GIF file |
Previous Message | Rene Pijlman | 2001-11-11 13:08:40 | Re: GCJ and JDBC Driver |