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

Re: Problems with truncated BLOB

From: Mike Cannon-Brookes <mike(at)atlassian(dot)com>
To: Mihael Vrbanec <miqster(at)gmx(dot)net>
Cc: Barry Lind <barry(at)xythos(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problems with truncated BLOB
Date: 2001-12-07 05:23:30
Message-ID: 1007702610.12772.52.camel@frodo.mikesroom (view raw or flat)
Thread:
Lists: pgsql-jdbc
Mihael / Barry,

I'm still struggling to make this work.

So far:
I've tried both scenarios

1) using a table with a bytea column (create table blobs(filename text,
data bytea)) and the latest development driver

2) using a table with a traditional oid column (create table
blobs2(filename text, data oid)) and the latest development driver, and
appending ?compatible=7.1 to the driver URI

In both scenarios uploading text files works perfectly.

ONLY in the second scenario does uploading binary files work. In the
first scenario they return truncated. I am using the BlobTest provided
by Barry.

My database version is 7.1.3 on RedHat 7.2 using Sun Linux JDK 1.3.1.

Where can I go from here? What can I test? I really need to get this
working - so I'm willing to try anything ;) 

Should I bother upgrading the whole DB to 7.2beta to see if it works?

-mike


Taking Mihael's advice I've managed to get the binary 
On Wed, 2001-11-28 at 00:51, Mihael Vrbanec wrote:
> Hi Mike,
> 
> > I'm definitely just using the new driver, here's my classpath:
> > 
> > /usr/java/jdk1.3.1/lib/tools.jar:.:/opt/orion/lib/jdbc7.2dev-1.2.jar
> > 
> > (downloaded the jdbc jar from jdbc.postgresql.org this morning)
> > 
> > Might I suggest it's something to do with bytea support from 7.1 to
> > 7.2b3? ;)
> 
> Well, I tried it some minutes ago with the new development-driver
> (jdbc7.2dev-1.2.jar) and my 7.1.3 database (using additional
> "?compatible=7.1" to the connect-url) and the lod oid-style. It seemed
> to work. I will make some more tests, but so far I did not experience
> any problem...
> 
> bxe Miq
> -- 
>  **       Mihael Vrbanec    ---   Uni Karlsruhe       **
> ***              eMail:   miqster(at)gmx(dot)net             ***
>  **       Homepage:  miqster.homeip.net/~miq/         **
>  
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
-- 
Cheers,
Mike

-- 
Mike Cannon-Brookes :: mike(at)atlassian(dot)com

Atlassian :: http://www.atlassian.com
     Supporting YOUR J2EE World



In response to

pgsql-jdbc by date

Next:From: Nicolas VergerDate: 2001-12-07 09:45:05
Subject: Patch : Re: JDBC improvements
Previous:From: Tim HollowayDate: 2001-12-07 01:39:34
Subject: Insert/Update that doesn't

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