Re: BLOBS : how to remove them totally

Thanx for ur suggestion... But I face a new problem
now...

connection.setAutoCommit works well with postgresql
7.3 .. but with postgresql 7.4 I am getting the
error...
Error in connection == ERROR: SET AUTOCOMMIT TO OFF
is no longer supported

I have tried pg73jdbc1.jar and pg73jdbc3.jar .. both
gave the same error....

But in psql (7.4) the command \set AUTOCOMMIT off is
working. Strangely \set AUTOCOMMIT off is actually
changing the value of AUTOCOMMIT internal variable...
If I type \set autocommit off .. there will create
another variable 'autocommit' and set it to 'off'...
But this wont change the autocommit mode to off.. (The
documentation doesnot tell us of any such caps/small
behaviour!)

Regards
N Banerjee

--- Kris Jurka <books(at)ejurka(dot)com> wrote: >
>
> On Sat, 20 Dec 2003, [iso-8859-1] Nilabhra Banerjee
> wrote:
>
> > But unfortunately I could not extract this data to
> > frontend thru java... I tried in two ways but got
> the
> > same error...after getting the data in Blob or
> Large
> > Object.
> >
> > Error in connection == FastPath call returned
> ERROR:
> > invalid large-object descriptor: 0
>
> This is usually a symptom of not being in a
> transaction. Large objects
> need to be done inside a transaction. Try adding
> connection.setAutoCommit(false) somewhere in your
> code.
>
> Kris Jurka

________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html