Re: What is "result_id"

John,

This can happen when there are concurrency issues with the software 
using the JDBC driver, or in some cases when you access a ResultSet that 
has been closed.  In this case, it appears that the software is reading 
data from a java.sql.Blob from a result set, but the ResultSet is 
closed.  Your software should be careful not to close a ResultSet or its 
parent *Statement object throughout the duration of retrieving data from 
the result.

Toby.

John Plate wrote:

> Hi
> 
> I got this error message:
> 
> Hibernate: select dbphotobea0_.id as id0_, dbphotobea0_.file as file0_
> from photo dbphotobea0_ where dbphotobea0_.id=?
> java.io.IOException: SQL Error: 'result_id' invalid.
>         at
> com.mckoi.database.jdbc.AbstractStreamableObject$StreamableObjectInputStream.readPageContent(AbstractStreamableObject.java:139)
>         at
> com.mckoi.util.PagedInputStream.fillBuffer(PagedInputStream.java:110)
> at com.mckoi.util.PagedInputStream.skip(PagedInputStream.java:179)
>         at
> com.mckoi.database.jdbc.MStreamableBlob.getBytes(MStreamableBlob.java:67)
> 
> 
> Hibernate produced the SQL above. Mckoi got a problem. Can someone
> help me to see what the problem could be?
> 
> The table is simple:
> 
>     id int
>     file blob
> 
> Thanks in advance
> John



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]