Mihael / Barry,
I'm still struggling to make this work.
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
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?
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?
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 Verger||Date: 2001-12-07 09:45:05|
|Subject: Patch : Re: JDBC improvements|
|Previous:||From: Tim Holloway||Date: 2001-12-07 01:39:34|
|Subject: Insert/Update that doesn't|