Re: Problems with truncated BLOB - Mailing list pgsql-jdbc

From Mike Cannon-Brookes
Subject Re: Problems with truncated BLOB
Date
Msg-id 1007702610.12772.52.camel@frodo.mikesroom
Whole thread Raw
In response to Re: Problems with truncated BLOB  (Mihael Vrbanec <miqster@gmx.net>)
List 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@gmx.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@atlassian.com

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



pgsql-jdbc by date:

Previous
From: Marko Kreen
Date:
Subject: Re: JDBC build
Next
From: Ned Wolpert
Date:
Subject: Bug with caching SQLTypes in Connection:getSQLType(oid)