Hi All,

I'm using hibernate 2.1.2 with Tomcat and MSSQL.
The application is running great, but after a while I get this exception:

[ERROR] JDBCExceptionReporter - -Could not execute query <java.sql.SQLException: [SQLServer JDBC Driver]No more data available to read.>java.sql.SQLException: [SAP_Portals][SQLServer JDBC Driver]No more data available to read.

It happens after running select query.
I have to retart the application in order to fix it.

Any ideas?

the error seems to come from the jdbc driver, not hibernate, what does google say about this sql error?

yeah, I know that it come from the driver, but after I tried to search google I think this is something because of the connection or statement was closed or timed out.
So I thought maybe hibernate is not refreshing the connection or statements.

what pool are you using?

I didn't configure any connection pool, I'm using hibernate default configuration.

try proxool, hibernate default pool is only for dev environment, but you should switch as soon a possible to proxool

Thanks a lot for your help, I will try that.