java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: x4_0_

Hibernate JIRA | Alessandro Vernet | 1 decade ago
  1. 0

    The code: session.iterate("select p.year, sum(f.units), sum(a.units), sum(f.units*pp.listPrice)" + " from Period p" + " left outer join p.forecasts f" + " left outer join p.actuals a" + " left outer join p.productPrices pp" + " where p.period >= ? and p.period <= ?" + " and f.customer = ? and f.product = ? and f.employee = ?" + " and a.customer = ? and a.product = ? and a.employee = ?" + " and pp.customer = ? and pp.product = ?" + " group by p.year order by p.year", ... The important part is the "sum(f.units*pp.listPrice)". Hibernate generates this query: select period0_.year as x0_0_, sum(forecast1_.units) as x1_0_, sum(actuals2_.units) as x2_0_, sum(forecast1_.units*productp3_.list) as x3_0_ from owf_period period0_ left outer join owf_forecast forecast1_ on period0_.period=forecast1_.period left outer join owf_actual actuals2_ on period0_.period=actuals2_.period left outer join owf_product_price productp3_ on period0_.period=productp3_.period where (period0_.period>=? )and(period0_.period<=? )and(forecast1_.customer_id=? )and(forecast1_.product_id=? )and(forecast1_.employee_id=? )and(actuals2_.customer_id=? )and(actuals2_.product_id=? )and(actuals2_.employee_id=? )and(productp3_.customer_id=? )and(productp3_.product_id=? ) group by period0_.year order by period0_.year Running this throws the exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: x4_0_ at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getColumnOrdinal(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:159) at net.sf.hibernate.type.IntegerType.get(IntegerType.java:14) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:60) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:51) at net.sf.hibernate.impl.IteratorImpl.postNext(IteratorImpl.java:62) at net.sf.hibernate.impl.IteratorImpl.<init>(IteratorImpl.java:44) at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:835) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1439) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1416)

    Hibernate JIRA | 1 decade ago | Alessandro Vernet
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: x4_0_
  2. 0

    The code: session.iterate("select p.year, sum(f.units), sum(a.units), sum(f.units*pp.listPrice)" + " from Period p" + " left outer join p.forecasts f" + " left outer join p.actuals a" + " left outer join p.productPrices pp" + " where p.period >= ? and p.period <= ?" + " and f.customer = ? and f.product = ? and f.employee = ?" + " and a.customer = ? and a.product = ? and a.employee = ?" + " and pp.customer = ? and pp.product = ?" + " group by p.year order by p.year", ... The important part is the "sum(f.units*pp.listPrice)". Hibernate generates this query: select period0_.year as x0_0_, sum(forecast1_.units) as x1_0_, sum(actuals2_.units) as x2_0_, sum(forecast1_.units*productp3_.list) as x3_0_ from owf_period period0_ left outer join owf_forecast forecast1_ on period0_.period=forecast1_.period left outer join owf_actual actuals2_ on period0_.period=actuals2_.period left outer join owf_product_price productp3_ on period0_.period=productp3_.period where (period0_.period>=? )and(period0_.period<=? )and(forecast1_.customer_id=? )and(forecast1_.product_id=? )and(forecast1_.employee_id=? )and(actuals2_.customer_id=? )and(actuals2_.product_id=? )and(actuals2_.employee_id=? )and(productp3_.customer_id=? )and(productp3_.product_id=? ) group by period0_.year order by period0_.year Running this throws the exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: x4_0_ at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getColumnOrdinal(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:159) at net.sf.hibernate.type.IntegerType.get(IntegerType.java:14) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:60) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:51) at net.sf.hibernate.impl.IteratorImpl.postNext(IteratorImpl.java:62) at net.sf.hibernate.impl.IteratorImpl.<init>(IteratorImpl.java:44) at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:835) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1439) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1416)

    Hibernate JIRA | 1 decade ago | Alessandro Vernet
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: x4_0_
  3. 0

    After patching/hacking UP-1155, we ran across these result set exceptions which have been seen before in other UPortal classes (UP-1039, UP-849). These result set reading exceptions occur when attempting to view your institutions uPortal home page: DEBUG [DLM Fragment Activator] dlm.RDBMDistributedLayoutStore.[] Jul/11 22:29:30 - RDBMUserLayoutStore::getStructureStylesheetUserPreferences(): SELECT PARAM_NAME, PARAM_VAL, PARAM_TYPE, ULS.STRUCT_ID, CHAN_ID, ULP.STRUCT_PARM_NM, ULP.STRUCT_PARM_VAL FROM UP_SS_USER_ATTS UUSA, UP_LAYOUT_STRUCT ULS, UP_LAYOUT_PARAM ULP WHERE UUSA.USER_ID=4 AND PROFILE_ID=1 AND SS_ID=4 AND SS_TYPE=1 AND UUSA.STRUCT_ID = ULS.STRUCT_ID AND UUSA.USER_ID = ULS.USER_ID AND UUSA.STRUCT_ID *= ULP.STRUCT_ID AND UUSA.USER_ID *= ULP.USER_ID ERROR [DLM Fragment Activator] dlm.FragmentActivator.[] Jul/11 22:29:30 - ------ Problem occurred activating Entertainment------ Anomaly occurred while loading structure or theme stylesheet user preferences for fragment 'Entertainment'. The fragment will not be available for inclusion into user layouts. java.lang.RuntimeException: Anomaly occurred while loading structure or theme stylesheet user preferences for fragment 'Entertainment'. The fragment will not be available for inclusion into user layouts. at org.jasig.portal.layout.dlm.FragmentActivator.loadPreferences(FragmentActivator.java:350) at org.jasig.portal.layout.dlm.FragmentActivator.activateFragments(FragmentActivator.java:118) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore$1.run(RDBMDistributedLayoutStore.java:175) Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 5. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:186) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore._getStructureStylesheetUserPreferences(RDBMDistributedLayoutStore.java:1044) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.getDistributedSSUP(RDBMDistributedLayoutStore.java:841) at org.jasig.portal.layout.dlm.FragmentActivator.loadPreferences(FragmentActivator.java:343) ... 2 more DEBUG [DLM Fragment Activator] dlm.FragmentActivator.[] Jul/11 22:29:30 -

    Apereo Issues | 1 decade ago | Elliot Metsger
    java.lang.RuntimeException: Anomaly occurred while loading structure or theme stylesheet user preferences for fragment 'Entertainment'. The fragment will not be available for inclusion into user layouts.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    After patching/hacking UP-1155, we ran across these result set exceptions which have been seen before in other UPortal classes (UP-1039, UP-849). These result set reading exceptions occur when attempting to view your institutions uPortal home page: DEBUG [DLM Fragment Activator] dlm.RDBMDistributedLayoutStore.[] Jul/11 22:29:30 - RDBMUserLayoutStore::getStructureStylesheetUserPreferences(): SELECT PARAM_NAME, PARAM_VAL, PARAM_TYPE, ULS.STRUCT_ID, CHAN_ID, ULP.STRUCT_PARM_NM, ULP.STRUCT_PARM_VAL FROM UP_SS_USER_ATTS UUSA, UP_LAYOUT_STRUCT ULS, UP_LAYOUT_PARAM ULP WHERE UUSA.USER_ID=4 AND PROFILE_ID=1 AND SS_ID=4 AND SS_TYPE=1 AND UUSA.STRUCT_ID = ULS.STRUCT_ID AND UUSA.USER_ID = ULS.USER_ID AND UUSA.STRUCT_ID *= ULP.STRUCT_ID AND UUSA.USER_ID *= ULP.USER_ID ERROR [DLM Fragment Activator] dlm.FragmentActivator.[] Jul/11 22:29:30 - ------ Problem occurred activating Entertainment------ Anomaly occurred while loading structure or theme stylesheet user preferences for fragment 'Entertainment'. The fragment will not be available for inclusion into user layouts. java.lang.RuntimeException: Anomaly occurred while loading structure or theme stylesheet user preferences for fragment 'Entertainment'. The fragment will not be available for inclusion into user layouts. at org.jasig.portal.layout.dlm.FragmentActivator.loadPreferences(FragmentActivator.java:350) at org.jasig.portal.layout.dlm.FragmentActivator.activateFragments(FragmentActivator.java:118) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore$1.run(RDBMDistributedLayoutStore.java:175) Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 5. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:186) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore._getStructureStylesheetUserPreferences(RDBMDistributedLayoutStore.java:1044) at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.getDistributedSSUP(RDBMDistributedLayoutStore.java:841) at org.jasig.portal.layout.dlm.FragmentActivator.loadPreferences(FragmentActivator.java:343) ... 2 more DEBUG [DLM Fragment Activator] dlm.FragmentActivator.[] Jul/11 22:29:30 -

    Apereo Issues | 1 decade ago | Elliot Metsger
    java.lang.RuntimeException: Anomaly occurred while loading structure or theme stylesheet user preferences for fragment 'Entertainment'. The fragment will not be available for inclusion into user layouts.
  6. 0

    org.hibernate.exception.GenericJDBCException: could not load an entity:_°Ù¶ÈÖªµÀ

    baidu.com | 4 months ago
    org.hibernate.exception.GenericJDBCException: could not load an entity: [com.qinjing.hibernate.bean.Qjsys29#3]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: x4_0_

      at com.microsoft.jdbc.base.BaseExceptions.createException()
    2. com.microsoft.jdbc
      BaseResultSet.getInt
      1. com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
      2. com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      3. com.microsoft.jdbc.base.BaseResultSet.getColumnOrdinal(Unknown Source)
      4. com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source)
      4 frames
    3. Commons DBCP
      DelegatingResultSet.getInt
      1. org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:159)
      1 frame
    4. net.sf.hibernate
      SessionImpl.iterate
      1. net.sf.hibernate.type.IntegerType.get(IntegerType.java:14)
      2. net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:60)
      3. net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:51)
      4. net.sf.hibernate.impl.IteratorImpl.postNext(IteratorImpl.java:62)
      5. net.sf.hibernate.impl.IteratorImpl.<init>(IteratorImpl.java:44)
      6. net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:835)
      7. net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1439)
      8. net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1416)
      8 frames