rhodia.spb.architecture.exception.RHFSystemException

Hibernate JIRA | Gian Paolo Peduto | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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?

    Hibernate JIRA | 1 decade ago | Gian Paolo Peduto
    rhodia.spb.architecture.exception.RHFSystemException
  2. 0

    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?

    Hibernate JIRA | 1 decade ago | Gian Paolo Peduto
    rhodia.spb.architecture.exception.RHFSystemException

    Root Cause Analysis

    1. rhodia.spb.architecture.exception.RHFSystemException

      No message provided

      at rhodia.spb.architecture.dao.RHFGenericSDAO.readTableObjects()
    2. rhodia.spb.architecture
      RHFGenericSDAO.readTableObjects
      1. rhodia.spb.architecture.dao.RHFGenericSDAO.readTableObjects(RHFGenericSDAO.java:54)
      1 frame