Thanks a lot for the clue... Now I am comfortably
handling the Lrge Objects thru SQL...
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
1) Process One
Blob myBlob = null;
Then for resultset rs
myBlob=rs.getBlob(1);
The error is returned in any statement which processes
the Blob object like,
long myLength = myBlob.length();
2) Process Two
FIRST the largeobject manager
LargeObjectManager lobj =
((org.postgresql.PGConnection)conn).getLargeObject API();
THEN in the while rs.next() loop
LargeObject obj = lobj.open(oid,
LargeObjectManager.READ);
AND THEN
InputStream input = new
BufferedInputStream(largeobj.getInputStream());
THe Error is returned in any statement that processes
the input like writing in a ouputstream
int b = -1;
while ((b = input.read()) != -1)
outputStream.write(b);
I AM PUZZLED... WHERE IS THE WRONG ? THE CODE IS NOT
COMPLAINING WHEN I GET THE VALUE FROM THE RESULT IN A
OBJECT. BUT IT IS GIVING ERROR WHEN I AM TRYING TO
READ THE OBJECT.
Regards
Nilabhra Banerjee
--- Tom Lane <tg*@sss.pgh.pa.us> wrote: > Bernd Helmle
<ma******@oopsware.de> writes:
Here you can find an excellent description, how
BLOBs in PostgreSQL can be handled:
http://www.varlena.com/varlena/GeneralBits/44.php
That's a good discussion, but it left out at least
one useful bit of
info about managing large objects: there's a contrib
utility
(contrib/vacuumlo) that can find and remove large
objects that are not
referenced anywhere in the database. This is a good
way to clean up
if you've been using large objects without any of
the automatic
management techniques suggested in the GeneralBits
article.
regards, tom lane
---------------------------(end of
broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please
send an appropriate
subscribe-nomail command to
ma*******@postgresql.org so that your
message can get through to the mailing list
cleanly
__________________________________________________ ______________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
ma*******@postgresql.org)