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

Re: I do not understand the exception

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jaap Bril <Jaap(dot)Bril(at)inter(dot)nl(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: I do not understand the exception
Date: 2004-08-24 15:07:02
Message-ID: Pine.BSO.4.56.0408241005450.2585@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Tue, 24 Aug 2004, Jaap Bril wrote:

> the exception is
> 	SQLEXCEPTION:Storing thumbnail failed: 
> 	java.sql.SQLException: ERROR:  Bad int8 external representation
> 	"\377\330\377\340\  [.........]
> 
>         String thumbnail_insert = "INSERT INTO thumbnails VALUES (?)";

You are trying to put the byte array into your serial column.  You need to 
explicitly name the column you want in your insert statement.

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-08-24 15:16:24
Subject: Re: JDBC
Previous:From: Hanna TapaniDate: 2004-08-24 14:50:38
Subject: JDBC

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