From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Mark <bef5471(at)iperbole(dot)bologna(dot)it> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] jdbc fastpath error & Z error (URGENT NEED!!!) |
Date: | 2001-02-13 10:02:45 |
Message-ID: | 982058565.3a890645d1ceb@webmail.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-jdbc |
Quoting Mark <bef5471(at)iperbole(dot)bologna(dot)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(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-02-13 10:47:23 | Re: [ODBC] RE: 7.1 beta 3 Linux ODBC BEGINBehaviour |
Previous Message | Peter T Mount | 2001-02-13 10:00:03 | Re: Problem with JDBC driver: rs.next() is always null |
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond Chui | 2001-02-13 12:49:20 | Re: How to make PostgreSQL JDBC drive get PGTZ? |
Previous Message | Peter T Mount | 2001-02-13 09:34:02 | Re: How to make PostgreSQL JDBC drive get PGTZ? |