rhodia.spb.architecture.exception.RHFSystemException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • I´m doing a query that should return a list of beans. In the following code: ... Query query = session.createQuery(strQuery); Iterator it = query.iterate(); <-- a this point, ... when I try to get the iterator, I receive an exception: =========================================== TitleDAO - listTitles() Hibernate: select titlebean0_.TITLE_CODE as x0_0_ from SPB_TITLES titlebean0_ Hibernate: select titlebean0_.TITLE_CODE as TITLE_CODE0_, titlebean0_.FIRST_TITLE as FIRST_TI2_0_, titlebean0_.SECOND_TITLE as SECOND_T3_0_, titlebean0_.THIRD_TITLE as THIRD_TI4_0_, titlebean0_.SUBTITLE as SUBTITLE0_ from SPB_TITLES titlebean0_ where titlebean0_.TITLE_CODE=? 13:35:35,062 WARN JDBCExceptionReporter:57 - SQL Error: 0, SQLState: S1000 13:35:35,062 ERROR JDBCExceptionReporter:58 - [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt 13:35:35,078 WARN JDBCExceptionReporter:57 - SQL Error: 0, SQLState: S1000 13:35:35,078 ERROR JDBCExceptionReporter:58 - [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt could not load: [rhodia.spb.commons.databeans.TitleBean#FIO_POY] rhodia.spb.architecture.exception.RHFSystemException at rhodia.spb.architecture.dao.RHFGenericSDAO.readTableObjects(RHFGenericSDAO.java:54) at =========================================== This error "[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt" happens when it´s tried to do more then one action throw the same SQL server connection without finishing the first action. This is a standalone client application with no concurrency. It seems that Hibernate do 2 queries when you try to get the iterator: one to get the PKs fiels and another to get the first row. At this second query the exception is thrown. A friend said that this code works fine with MySQL, so I think it's some restriction with SQL server connection/driver/database configuration. Could you please check this error?
    via by Gian Paolo Peduto,
  • I´m doing a query that should return a list of beans. In the following code: ... Query query = session.createQuery(strQuery); Iterator it = query.iterate(); <-- a this point, ... when I try to get the iterator, I receive an exception: =========================================== TitleDAO - listTitles() Hibernate: select titlebean0_.TITLE_CODE as x0_0_ from SPB_TITLES titlebean0_ Hibernate: select titlebean0_.TITLE_CODE as TITLE_CODE0_, titlebean0_.FIRST_TITLE as FIRST_TI2_0_, titlebean0_.SECOND_TITLE as SECOND_T3_0_, titlebean0_.THIRD_TITLE as THIRD_TI4_0_, titlebean0_.SUBTITLE as SUBTITLE0_ from SPB_TITLES titlebean0_ where titlebean0_.TITLE_CODE=? 13:35:35,062 WARN JDBCExceptionReporter:57 - SQL Error: 0, SQLState: S1000 13:35:35,062 ERROR JDBCExceptionReporter:58 - [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt 13:35:35,078 WARN JDBCExceptionReporter:57 - SQL Error: 0, SQLState: S1000 13:35:35,078 ERROR JDBCExceptionReporter:58 - [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt could not load: [rhodia.spb.commons.databeans.TitleBean#FIO_POY] rhodia.spb.architecture.exception.RHFSystemException at rhodia.spb.architecture.dao.RHFGenericSDAO.readTableObjects(RHFGenericSDAO.java:54) at =========================================== This error "[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt" happens when it´s tried to do more then one action throw the same SQL server connection without finishing the first action. This is a standalone client application with no concurrency. It seems that Hibernate do 2 queries when you try to get the iterator: one to get the PKs fiels and another to get the first row. At this second query the exception is thrown. A friend said that this code works fine with MySQL, so I think it's some restriction with SQL server connection/driver/database configuration. Could you please check this error?
    via by Gian Paolo Peduto,
    • rhodia.spb.architecture.exception.RHFSystemException at rhodia.spb.architecture.dao.RHFGenericSDAO.readTableObjects(RHFGenericSDAO.java:54)
    No Bugmate found.