java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Value can not be converted to requested type.

Oracle Community | 807541 | 1 decade ago
  1. 0

    HELP! cannot convert String to String from DB ResultSet!!!

    Oracle Community | 1 decade ago | 807541
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Value can not be converted to requested type.
  2. 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]
  3. 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_
  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

    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.

    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]Value can not be converted to requested type.

      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.BaseData.getInteger(Unknown Source)
      4. com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source)
      5. com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source)
      5 frames