Skip site navigation (1) Skip section navigation (2)

Re: SQLException: ERROR: oidin: when loading GIF file

From: Barry Lind <barry(at)xythos(dot)com>
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-12 17:30:45
Message-ID: 3BF00745.70305@xythos.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Craig,

oidin is the input function for a column of datatype oid.  My guess as 
to your problem is that your table definition is incorrect.  What does 
your images table look like?

thanks,
--Barry


Craig Jarman wrote:

> 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 <mailto:cjarman(at)source(dot)com(dot)au>
> ______________________________
> 



In response to

pgsql-jdbc by date

Next:From: Robert DownDate: 2001-11-12 18:53:45
Subject: absolute() error with jdbc7.1-1.2
Previous:From: Thomas T. ThaiDate: 2001-11-12 15:28:59
Subject: Re: Storing a tree

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group