java.lang.NullPointerException about the list.add(Int , Object)
I want to get a list of the table VwOdaycount ,the list should contain the fday (taken as the key word of the list) and the fcount(taken as the object of the list).
the HQL is ""select model.fday,model.fcount from VwOdaycount as model where model.fitemId="+itemID +
"and model.fyear=" +year +"and model.fmonth="+month+"order by model.fday asc"; "
using the Hibernate version:3.01
failure Trace is folowing:
java.lang.NullPointerException
at library.dao.hibernate.OCounterDaoHibernateImpl$2.doInHibernate(OCounterDaoHibernateImpl.java:58)
at library.dao.hibernate.OCounterDaoHibernateImpl$2.doInHibernate(OCounterDaoHibernateImpl.java:1)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at library.dao.hibernate.OCounterDaoHibernateImpl.getDayCounts(OCounterDaoHibernateImpl.java:46)
at library.test.testOCounter.testGetOCounter(testOCounter.java:42)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
the code is following:
public List getDayCounts(int itemID, int year, final int month) {
final String queryString = "select model.fday,model.fcount from VwOdaycount as model where model.fitemId="+itemID +
"and model.fyear=" +year +"and model.fmonth="+month+"order by model.fday asc";
return (List) this.getHibernateTemplate().execute(
new HibernateCallback(){
public List doInHibernate(Session session)throws HibernateException{
Query queryObject = session.createQuery(queryString);
Iterator it=queryObject.iterate();
List<Object> list =null;//int i=0;
while(it.hasNext())
{
Object[] result =(Object[]) it.next();
//System.out.println(result[0]);
//System.out.println(result[1]);
int i=Integer.parseInt(result[0].toString());
list.add(i,result[1]);
}
return list;
}
});}
The problem is on the "list.add(i,result[1])",I am sure that the result is not null,but I don't know the reason that it don't work. thanks!
Message was edited by:
wang_11o1
Message was edited by:
wang_11o1
