nullpointer exception in jsp

hi guys,
I am gettting org.apache.jasper.JasperException: java.lang.NullPointerException
I am using Hibernate in my appln to get data
pls help me;;;;;;;;;;;;;;;;;;;;;;;

here is the code::::::::

<%!
public void jspInit(ServletConfig config) {
try {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session = sessionFactory.openSession();
} catch (HibernateException e) {
e.printStackTrace();
}//init(ServletConfig)
}

/*Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin :@path given:java","scott","tiger");
PreparedStatement ps=conn.prepareStatement("select distinct(job) from hb_emp");
ResultSet rs=ps.executeQuery();
while(rs.next())*/



Query query = session.createQuery("select eb.desg" + "from EmpBean eb");
Iterator it = query.iterate();
Boolean b = it.hasNext();
%>
<% while(b)
{ Object[] row = (Object[])it.next();

%>
<option value="<%=(String) row[0]%>"><%=(String) row[0]%></option>


<%}
%>

Without code, it's tough to see where an exception is thrown.

I think it's in your while loop at the end of your code.

Code:

---

Boolean b = it.hasNext();
%>
<% while(b)
{ Object[] row = (Object[])it.next();

%>
<option value="<%=(String) row[0]%>"><%=(String) row[0]%></option>


<%}
%>

---

Boolean b is only being checked once, not after each iteration of the loop like you intended.

Try this:

Code:

---

%>
<% while(it.hasNext())
{ Object[] row = (Object[])it.next();

%>
<option value="<%=(String) row[0]%>"><%=(String) row[0]%></option>


<%}
%>

---

Putting hasNext in the loop condition will make sure that it is checked each time through the loop.

I could be wrong though.

I just looked at the API and noticed that Iterator's .next method throws a NoSuchElementException, not a NullPointerException so I might be wrong.

Just a pointer: scriptlets are A Bad Thing anyway, and anything, scriptlets or otherwise, that connects a JSP to a database, is a bad design. Try and layer the app a bit more, otherwise you'll be copying and pasting data access code all over the place

It may b prb of result giving null data, just try to make condition which checks null pointer

It may b prb of result giving null data, just try to make condition which checks null pointer then try it