Have you verified that this large object (id=12992) exists in your 
database?  (select distinct loid from pg_largeobject where loid = 12992)
If it doesn't, I think then the place to look is the code that you used 
to insert the large objects as it would appear that code didn't do the 
insert correctly (or some other code as since deleted the large object).


Matt Fair wrote:

> Hello,
> I am having a similary problem that I was having when I was trying to 
> upload an image to the database. I am already able to upload blobs into 
> the database but I cannot download them.
> I get the error 'inv_open: large object 12992 not found', which I assume 
> means that the statement should be in a transaction, but it is and it 
> still outputs the error.
> Here is my code:
>        con.setAutoCommit(false);
>        Statement statement = con.createStatement();
>        ResultSet rs = statement.executeQuery("select image from 
> userpreferences where username='"+user+"'");
>        if(rs == null) return null;
>        InputStream is = rs.getBinaryStream("image");     <----- This is 
> where the error is thrown
>        JimiReader reader = Jimi.createJimiReader(is);
>        image = reader.getImage();
>        con.commit();
>        con.close();
>        return new ServerMessage(new JimiImageSerializer(image));
> Here is my error stack trace:
> FastPath call returned ERROR:  inv_open: large object 12992 not found
>        at org.postgresql.fastpath.Fastpath.fastpath(
>        at org.postgresql.fastpath.Fastpath.fastpath(
>        at org.postgresql.fastpath.Fastpath.getInteger(
>        at 
> org.postgresql.largeobject.LargeObject.<init>(
>        at 
>        at 
> org.postgresql.jdbc2.ResultSet.getBinaryStream(
>        at 
> org.postgresql.jdbc2.ResultSet.getBinaryStream(
>        at 
> org.opensimpx.server.RequestHandler.getBackgroundImage( 
>        at 
> org.opensimpx.server.RequestHandler.handleRequest(
>        at
>        at
> Any ideas?
> Thank you in advanced,
> Matt
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to