stops reading the resultset when column value in row is NULL

[alperay]

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

[greenbean]

Something similar is happening with my code.

What is the solution to this problem?

[karldmoore]

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.