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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html