Re: [INTERFACES] jdbc fastpath error & Z error (URGENT NEED!!!) - Mailing list pgsql-jdbc

From Peter T Mount
Subject Re: [INTERFACES] jdbc fastpath error & Z error (URGENT NEED!!!)
Date
Msg-id 982058565.3a890645d1ceb@webmail.retep.org.uk
Whole thread Raw
List pgsql-jdbc
Quoting Mark <bef5471@iperbole.bologna.it>:

redirecting to jdbc list...

> Hy, Postgresql community!
>
> I'm using:
> Linux RedHat6.2,
> PostgreSql6.5.3+jdbc6.5-1.2,
> jdk1.2.2
> (AND I CAN'T CHANGE THIS "KIT")

Tricky. It's fixed in 7.0. The only thing I can advise is to use the web
frontend of cvs, and see what changed between 6.5.2 and 7.0 in
org.postgresql.Connection (mainly the ExecSQL method) and the
org.postgresql.fastpath.* classes and put those changes in there.

Peter

>
> I've got the below java program and when I type:
> # javac PicImmitter.java , it's all ok.
> But my problem occours when I run:
> #java PicImmitter
> ..........and this is the error output:
>
> "FastPath protocol error: Z
>  at postgresql.fastpath.Fastpath.fastpath(Fastpath.java:159)
>  at postgresql.fastpath.Fastpath.fastpath(Fastpath.java:188)
>  at postgresql.fastpath.Fastpath.getInteger(Fastpath.java:200)
>  at
> postgresql.largeobject.LargeObjectManager.create(LargeObjectManager.java:162
> )
>  at
> postgresql.jdbc2.PreparedStatement.setBytes(PreparedStatement.java:298)
>  at ProvaPicIn.<init>(ProvaPicIn.java:48)
>  at ProvaPicIn.main(ProvaPicIn.java:11) "
>
> What can I do, exactly? My Program is:
>
> import java.awt.*;
> import java.io.*;
> import java.io.FileInputStream;
> import java.sql.*;
> import postgresql.largeobject.*;
> import java.io.IOException;
>
> public class PicImmitter extends Frame{
>  public static void main(String args[])
>  {
>      PicImmitter app = new PicImmitter();
>     System.exit(0);
>  }
>
>  public PicImmitter()
>   try{
>     Class.forName("postgresql.Driver");
>     Connection conn=DriverManager.getConnection("jdbc:postgresql:best",
>                                   "Myuser","Mypwd");
>     FileInputStream fis = new FileInputStream("015.jpg");
>     int nBytes = fis.available();
>     byte [] buff= new byte[nBytes];
>     int bytesPhoto = fis.read(buff,0,nBytes);
>     String photo = new String(buff);
>
>     conn.setAutoCommit(false);
>     PreparedStatement ps = conn.prepareStatement("update players set
>                                          image = ? where playercode=?
> ");
>     ps.setBytes(1,photo.getBytes());
>     ps.setInt(2,15);
>     ps.executeUpdate();
>
>     fis.close();
>     ps.close();
>     conn.setAutoCommit(true);
>     conn.close();
>   }catch(Exception ex){
>       ex.printStackTrace();
>   }
>  }
> }
>
> THANK'S A LOT
> MARCO FROM ITALY
>
>
>
>
>
>
>
>
>
>
>



--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: [GENERAL] How to make PostgreSQL JDBC drive get PGTZ?
Next
From: Brice Ruth
Date:
Subject: Re: [GENERAL] Re: (Update) Implicit smallint to boolean conversion?