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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-08-24 15:16:24 Re: JDBC
Previous Message Hanna Tapani 2004-08-24 14:50:38 JDBC