rhodia.spb.architecture.exception.RHFSystemException

Hibernate JIRA | Gian Paolo Peduto | 1 decade ago
  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