Announcement Announcement Module
Collapse
No announcement yet.
stops reading the resultset when column value in row is NULL Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • stops reading the resultset when column value in row is NULL

    Object [] params2 = new Object[]{gsmno};
    System.out.println("HibernateinvoiceDao-->getInvoicebyGsmNo-->gsmno"+gsmno+" startDate="+startDate.toString());
    if(getHibernateTemplate() == null)
    System.out.println("getHibernateTemplate()is NULL");

    List tmp = getHibernateTemplate().find("from com.telsim.ccb.model.CcbInvoiceMaster cim where cim.id.gsmNo=?",gsmno);
    System.out.println("getInvoicebyGsmNo-->SIZE=="+tmp.size());
    return tmp;

    I noticed that it stops reading the resultset when coloumn value in a row is NULL.
    Length of the returrning list is OK but all the values in the list is set to nULL..
    What can be the problem..

    Related messages are below:




    2005-06-28 09:35:15,455 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
    2005-06-28 09:35:15,455 DEBUG [org.hibernate.SQL] - select ccbinvoice0_.INVOICE_NO as INVOICE1_, ccbinvoice0_.INVOICE_STATUS as INVOICE2_, ccbinvoice0_.PAYMENT_SOURCE as PAYMENT3_, ccbinvoice0_.PAYTYPE as PAYTYPE, ccbinvoice0_.GSM_NO as GSM5_, ccbinvoice0_.START_DATE as START6_, ccbinvoice0_.CUSTOMER_ID as CUSTOMER7_, ccbinvoice0_.BILLING_PERIOD as BILLING8_, ccbinvoice0_.GROUP_CODE as GROUP9_, ccbinvoice0_.GROUP_START_DATE as GROUP10_, ccbinvoice0_.INVOICE_DATE as INVOICE11_, ccbinvoice0_.DUE_DATE as DUE12_, ccbinvoice0_.DUE_AMOUNT as DUE13_, ccbinvoice0_.INVOICE_AMOUNT as INVOICE14_, ccbinvoice0_.PAYMENT_DATE as PAYMENT15_, ccbinvoice0_.PAYMENT_VALUE as PAYMENT16_, ccbinvoice0_.PAYMENT_SOURCE_DEP as PAYMENT17_, ccbinvoice0_.SEND_DATE as SEND18_, ccbinvoice0_.SEND_FILE as SEND19_, ccbinvoice0_.RECEIVED_DATE as RECEIVED20_, ccbinvoice0_.RECEIVED_FILE as RECEIVED21_, ccbinvoice0_.PAYMENT_PROCESS_DATE as PAYMENT22_, ccbinvoice0_.ASSUMED_PAY_TYPE as ASSUMED23_, ccbinvoice0_.CITY_CODE as CITY24_, ccbinvoice0_.SCT_LATE as SCT25_, ccbinvoice0_.EARTQUAKE_FLAG as EARTQUAKE26_, ccbinvoice0_.YTS_IND as YTS27_, ccbinvoice0_.WARNING_REMINDER_IND as WARNING28_, ccbinvoice0_.FLAG as FLAG, ccbinvoice0_.LATE_PAYMENT_INTEREST_FLAG as LATE30_, ccbinvoice0_.CR_USER as CR31_, ccbinvoice0_.CR_DATE as CR32_, ccbinvoice0_.UPD_USER as UPD33_, ccbinvoice0_.UPD_DATE as UPD34_, ccbinvoice0_.UPD_SEQ as UPD35_, ccbinvoice0_.OTS_INSTITUTION as OTS36_, ccbinvoice0_.OTS_DIRECTION as OTS37_, ccbinvoice0_.OTS_LOG_DATE as OTS38_, ccbinvoice0_.OTS_LOG_TIME as OTS39_, ccbinvoice0_.OTS_LOG_SEQUENCE as OTS40_ from CCB.CCB_INVOICE_MASTER ccbinvoice0_ where ccbinvoice0_.GSM_NO=?
    Hibernate: select ccbinvoice0_.INVOICE_NO as INVOICE1_, ccbinvoice0_.INVOICE_STATUS as INVOICE2_, ccbinvoice0_.PAYMENT_SOURCE as PAYMENT3_, ccbinvoice0_.PAYTYPE as PAYTYPE, ccbinvoice0_.GSM_NO as GSM5_, ccbinvoice0_.START_DATE as START6_, ccbinvoice0_.CUSTOMER_ID as CUSTOMER7_, ccbinvoice0_.BILLING_PERIOD as BILLING8_, ccbinvoice0_.GROUP_CODE as GROUP9_, ccbinvoice0_.GROUP_START_DATE as GROUP10_, ccbinvoice0_.INVOICE_DATE as INVOICE11_, ccbinvoice0_.DUE_DATE as DUE12_, ccbinvoice0_.DUE_AMOUNT as DUE13_, ccbinvoice0_.INVOICE_AMOUNT as INVOICE14_, ccbinvoice0_.PAYMENT_DATE as PAYMENT15_, ccbinvoice0_.PAYMENT_VALUE as PAYMENT16_, ccbinvoice0_.PAYMENT_SOURCE_DEP as PAYMENT17_, ccbinvoice0_.SEND_DATE as SEND18_, ccbinvoice0_.SEND_FILE as SEND19_, ccbinvoice0_.RECEIVED_DATE as RECEIVED20_, ccbinvoice0_.RECEIVED_FILE as RECEIVED21_, ccbinvoice0_.PAYMENT_PROCESS_DATE as PAYMENT22_, ccbinvoice0_.ASSUMED_PAY_TYPE as ASSUMED23_, ccbinvoice0_.CITY_CODE as CITY24_, ccbinvoice0_.SCT_LATE as SCT25_, ccbinvoice0_.EARTQUAKE_FLAG as EARTQUAKE26_, ccbinvoice0_.YTS_IND as YTS27_, ccbinvoice0_.WARNING_REMINDER_IND as WARNING28_, ccbinvoice0_.FLAG as FLAG, ccbinvoice0_.LATE_PAYMENT_INTEREST_FLAG as LATE30_, ccbinvoice0_.CR_USER as CR31_, ccbinvoice0_.CR_DATE as CR32_, ccbinvoice0_.UPD_USER as UPD33_, ccbinvoice0_.UPD_DATE as UPD34_, ccbinvoice0_.UPD_SEQ as UPD35_, ccbinvoice0_.OTS_INSTITUTION as OTS36_, ccbinvoice0_.OTS_DIRECTION as OTS37_, ccbinvoice0_.OTS_LOG_DATE as OTS38_, ccbinvoice0_.OTS_LOG_TIME as OTS39_, ccbinvoice0_.OTS_LOG_SEQUENCE as OTS40_ from ZZ.WW_YY_XX ccbinvoice0_ where ccbinvoice0_.XX_AA=?
    2005-06-28 09:35:15,471 DEBUG [org.hibernate.jdbc.AbstractBatcher] - preparing statement
    2005-06-28 09:35:15,471 DEBUG [org.hibernate.type.StringType] - binding '5423877659' to parameter: 1
    2005-06-28 09:35:15,627 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open ResultSet (open ResultSets: 0, globally: 0)
    2005-06-28 09:35:15,627 DEBUG [org.hibernate.loader.Loader] - processing result set
    2005-06-28 09:35:15,627 DEBUG [org.hibernate.loader.Loader] - result set row: 0
    2005-06-28 09:35:15,674 DEBUG [org.hibernate.type.StringType] - returning 'FBXXXXXXX' as column: INVOICE1_
    2005-06-28 09:35:15,674 DEBUG [org.hibernate.type.StringType] - returning 'AKTIF' as column: INVOICE2_
    2005-06-28 09:35:15,674 DEBUG [org.hibernate.type.StringType] - returning null as column: PAYMENT3_
    2005-06-28 09:35:15,674 DEBUG [org.hibernate.loader.Loader] - result row: null
    2005-06-28 09:35:15,674 DEBUG [org.hibernate.loader.Loader] - done processing result set (1 rows)
    2005-06-28 09:35:15,674 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close ResultSet (open ResultSets: 1, globally: 1)
    2005-06-28 09:35:15,674 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
    2005-06-28 09:35:15,690 DEBUG [org.hibernate.jdbc.AbstractBatcher] - closing statement
    2005-06-28 09:35:15,690 DEBUG [org.hibernate.loader.Loader] - total objects hydrated: 0
    2005-06-28 09:35:15,690 DEBUG [org.hibernate.engine.PersistenceContext] - initializing non-lazy collections
    2005-06-28 09:35:15,690 DEBUG [org.springframework.transaction.support.Transactio nSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1 e2c841] for key [org.hibernate.impl.SessionFactoryImpl@1c958af] bound to thread [http-8080-Processor23]

    Thanks
    Alper Aykac

  • #2
    Something similar is happening with my code.

    What is the solution to this problem?

    Comment


    • #3
      What is the specific problem in your case, the data isn't coming back? Can we see the hbm, Hibernated class, applicationContext, dao thats problematic.

      Comment

      Working...
      X