"No more data available to read" error

13 Jan 2006 7:43 PM

MittyKom

Hi All

"No more data available to read" error is thrown by database driver when
connections max out on SQL Server. Does any one know what this means and how
can i resolve this issue? An application developed in Java uses SQL Server
for data storage. Thank you in advance.

13 Jan 2006 9:45 PM

Ryan Powers

This is not a sql server error message. It is an error message that is
raised by the jdbc driver itself.

It could be caused by several things that I know of, but each is sort of
application dependent.

1) Thread contention (non-thread safe) code within the app. 2 thread
competing for the same data in memory on the server
2) BLOB types, I read a bit that having BLOB types within your result set
can lead to this type of problem
3) Trying to scroll backward, or through a forward-only result set for a
second time.

I'd recommend contacting the JDBC driver manufacturer, as they would have
more details. I would be surprised if it was really related to not enough db
connections.

Sorry I can't be of more help.

--
Ryan Powers
Clarity Consulting
http://www.claritycon.com

Show quote

"MittyKom" wrote:

> Hi All
>
> "No more data available to read" error is thrown by database driver when
> connections max out on SQL Server. Does any one know what this means and how
> can i resolve this issue? An application developed in Java uses SQL Server
> for data storage. Thank you in advance.
>