Hibernate version:3.01
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"; "
Full stack trace of any exception that occurs:
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!

Hi wang_11o1,

dude
List<Object> list =null;//int i=0;

this should be
List<Object> list =nee ArrayList<Object>();

Try to learn Java then come to Hibernate

thanks a lot!
Dharmendra Pandey

I have change it ,but failure trace is changing too,as following :
java.lang.IndexOutOfBoundsException: Index: 1, Size: 0
at java.util.ArrayList.add(Unknown Source)
at library.dao.hibernate.OCounterDaoHibernateImpl$2.doInHibernate(OCounterDaoHibernateImpl.java:60)
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:47)
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 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)

Hi wang_11o1,

check the size of your Object[] result array before handling with content. The size (result.length) might be 0 and you're accessing result[0] and result[1].

chucky

Don't forget to rate if this helps

I find the point:
it's the
[code]int i=Integer.parseInt(result[0].toString());[/code]
if I change it to
[code]int i=0;list.add(i,result[1]); i++;[/code]
it's ok!
why?

Hi wang_11o1,

The exception


tells us that you are trying to insert an element in the list at index 1 right after you've created it (size 0). So the list doesn't have the index 1 yet.
That means the code

was returning 1 and the next line:

will try to insert the content of result[1] at index 1 (not yet available).

But if you do it like you've done:

the content of result[1] at index 0 (available) and you increment i (so next index will be also available).

Hope you understand now what you're doing.

chucky

Don't forget to rate if this helps
--------------------------------------