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

JDBC: HELP!!! Can't Upload BLOBS on 6.5.3

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: JDBC: HELP!!! Can't Upload BLOBS on 6.5.3
Date: 2000-10-03 05:25:46
Message-ID: 200010030525.e935PkV17699@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Angel Leon (anleon(at)ucab(dot)edu(dot)ve) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
JDBC: HELP!!! Can't Upload BLOBS on 6.5.3

Long Description
At First I tried the PreparedStatement "setBinaryStream" to upload a jpeg.. but it turned out to be, they hadn't implemented that method... then I tried using the "setBytes" method... They both worked on SQL Server 7.0... but the last one (setBytes) returns the following Exception:

FastPath protocol error: Z 
It just won't upload bytes... do I have to use the "lo_import" function within my SQL statement... I'm programming in Java I guess I  don't need dat. Is it that the driver is too old? Can I use a 7.x JDBC Driver?

PLEASE POSTGRESQL PEOPLE I NEED AN ANSWER!!! I COULD LOOSE MY JOB OVER THIS.

Sample Code
  /** This works perfectly on SQL Server JTurbo JDBC Driver...*/
  public boolean uploadImage(File file,int picId)
  {   
    try
    {
      FileInputStream fis = new FileInputStream(file);
      
      byte[] b = new byte[fis.available()];
      fis.read(b);
      
      PreparedStatement ps = rut._con.prepareStatement(
      "insert into PICS values (?,?)");
      ps.setInt(1,picId);
      ps.setBytes(2,b);
      ps.executeUpdate();
      ps.close();
      fis.close();  
    }
    catch(IOException ioexx)
    {
        System.out.println("=========IOException=================");
        System.out.println(ioexx + "//\n");
        out2.println(ioexx + "//\n");
        ioexx.toString();
        System.out.println("=====================================");
        return false;
    }    
    catch(SQLException e)
    {
      System.out.println("File Upload Exception: " + e.getMessage());
      out2.println("<font color=red>SQL Upload Exception:</font> " +  e.getMessage());
      return false;
    };
    return true;
  }

No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Jerome AletDate: 2000-10-03 07:22:39
Subject: Re: grant/revoke bug with delete/update
Previous:From: Tom LaneDate: 2000-10-03 04:51:07
Subject: Re: Strong feeling of something ugly lurking deeply within 7.0 ;-)

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