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

Re: Problems with truncated BLOB

From: Barry Lind <barry(at)xythos(dot)com>
To: Mihael Vrbanec <miqster(at)gmx(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problems with truncated BLOB
Date: 2001-11-26 02:02:18
Message-ID: 3C01A2AA.2030902@xythos.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Mihael,

Could you send a test case that demonstrates the problem?  Ideally a 
sample java program that will upload one of the problem files, and then 
another program that tries to download the file showing the problem you 
have having.

Also, which version of the jdbc driver are you using?  (the version that 
came with 7.1, or something newer)

thanks,
--Barry


Mihael Vrbanec wrote:

> Hi,
> 
> I am trying to store different binary files as blobs in the database but
> when I retrieve anything other than a text-file I get only a part of the
> stored file.
> The percentage of data I get out of the database varies from file to
> file (68bytes of a 370k .doc-file, ~300k of a ~900k .bmp-file) but stays
> constant for each individual file.
> I am not using the postgres-extensions to the JDBC-API. Is this a know
> issue or am I doing something wrong (large text-files seem to work
> perfectly)??
> 
> I am using:
> Linux 2.4
> jdk 1.3.1
> postgres 7.1.2/3
> 
> Thanx for you help!!
> 
> bxe Miq
> 



In response to

pgsql-jdbc by date

Next:From: Mark MuffettDate: 2001-11-26 15:01:53
Subject: Storing / Retrieving Large Objects
Previous:From: Mihael VrbanecDate: 2001-11-26 01:25:48
Subject: Problems with truncated BLOBs

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