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

I do not understand the exception

From: Jaap Bril <Jaap(dot)Bril(at)inter(dot)nl(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: I do not understand the exception
Date: 2004-08-24 10:02:31
Message-ID: 200408241202.31945.Jaap.Bril@inter.nl.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
I dont get the error here, 

the exception is
	SQLEXCEPTION:Storing thumbnail failed: 
	java.sql.SQLException: ERROR:  Bad int8 external representation
	"\377\330\377\340\  [.........]

The offending code is:
    private void storeThumbnail(ConnectionPool connectionPool, byte[] tn) {
        String thumbnail_insert = "INSERT INTO thumbnails VALUES (?)";
        try {
            dbConn = connectionPool.getConnection();
            dbConn.setAutoCommit(false);
            PreparedStatement ps = dbConn.prepareStatement(thumbnail_insert);
            ps.setBytes(1, tn);
            ps.executeUpdate();
            ps.close();
        }
        catch (SQLException e){
            System.out.println("SQLEX:Storing thumbnail failed: " + e );
        }
    }


       tn is a 
		ByteArrayOutputStream().toByteArray() filled with a
		JPEGCodec.createJPEGEncoder()


The table thumbnails has a bytea and a serial;

What can be wrong??

TIA
Jaap


Responses

pgsql-jdbc by date

Next:From: Hanna TapaniDate: 2004-08-24 14:50:38
Subject: JDBC
Previous:From: Barry LindDate: 2004-08-24 03:11:42
Subject: Re: types used for JDBC BLOB and CLOB?

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