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
