Null Pointer Exception error

Hi...

I am getting error of java.lang.NullPointerException.

Previously I used Tomcat 4.0 and my code is working fone...

but when I upgraded my tomcat 4.0 to tomcat 6.0 it gives me the error of java.lang.NullPointerException.

Please help me ....
it gives error of NullPointerException on line
int id = Integer.parseInt(cachedRS.getString("SerialNo"));

here is the code...

<%@ page import="com.sun.rowset.*" %>
<%@ include file = "ConnLoad.jsp" %>
 
<jsp:useBean id="cachedRS" class="com.sun.rowset.CachedRowSetImpl" type="javax.sql.rowset.CachedRowSet" scope="session" />
 
<%
try{
 
ResultSet  rs = null;
Statement  st = null;
 
  // initialize our CachedRowSet bean 
  cachedRS.setUsername(""); 
  cachedRS.setPassword(""); 
  cachedRS.setUrl(connString);
  cachedRS.setCommand("select SerialNo,SciName,BotName,Used,Collector,Image from herbdb order by BotName"); 
  cachedRS.execute(); 
 
} catch(Exception e)
{
//out.println("Press F5 button or Click Refresh to refresh the page.");
}
 
%>
 
<%
/*try{*/
int pageSize = 10;
int noRecords = 1;
cachedRS.first();
while(cachedRS.next())
{
noRecords++;
}
cachedRS.first();
 
//int noRecords = cachedRS.size();
int noPages = noRecords/pageSize;
 
if ((noRecords%pageSize)!=0)
noPages+=1;
 
int currPage=1;
 
Enumeration formElements = request.getParameterNames();
 
if (formElements.hasMoreElements())
{
if (request.getParameter("page").length()!=0)
currPage = Integer.parseInt(request.getParameter("page"));
}
        cachedRS.absolute((currPage*pageSize)-pageSize+1);
 
int firstRecordOnPage = cachedRS.getRow();
int lastRecordOnPage;
if (noPages == currPage)
lastRecordOnPage = noRecords;
else
lastRecordOnPage = cachedRS.getRow()+pageSize-1;
%>

<body>
<% 
int colcnt = 1;
String bgcolor="";
     for (int i=0; (i < pageSize) && !cachedRS.isAfterLast(); i++) 
{
if ( (colcnt%2) == 1 )
{
bgcolor="white";
}
else
{
bgcolor="#FFF8DC";
}
try
{
%>
 
<tr bgcolor="<%=bgcolor %>" >
<%
 [quote]  int id = Integer.parseInt(cachedRS.getString("SerialNo"));
  [/quote]
%>
<td><a href="BriefRecord.jsp?id=<%=id %>">Brief</a></td>
<td><a href="DetialRecord.jsp?id=<%=id %>">Detail</a></td>
<td><i><%= cachedRS.getString("BotName") %></i></td>
<td><%= cachedRS.getString("SciName") %></td>
<td><%= cachedRS.getString("Used") %></td>
<td><%= cachedRS.getString("Collector") %></td>
<td><a href="FullView.jsp?id=<%=id %>"><IMG height="50" width="50" SRC='<%= cachedRS.getString("Image") %>'></img></a></td>

<%
 
}
finally
{
/*out.println("Error Generated Somewhere...");
}
%> 
</tr>
<% 
colcnt++;
cachedRS.next();
} 
%>
 
</body>
</html>

Hi Viral,

I think you have posted this topic in two places.

Regards,
Ananth Chellathurai

Viral,
What code creates the result set and puts it in the session? Is it getting executed in Tomcat 6?

i am using file connLoad.jsp for connection and init resultset
its works fine in other files as well as if I run the same code using tomcat4 then it works but in tomcat 6 its not working....

here is the code of connLoad.jsp

please reply as im stucked and waiting for solution

thanks in advvance

Viral,
First, note that it is considered bad practice to put Java code - especially database code - in a JSP. It should be in Java objects.

Have you looked at the logs or what line the NullPointer is thrown on yet?

The following code jumps out at me as a problem. If there is an exception loading the connection, a message is logged and the code continues with the connection set to null. This invites the code to blow up later when someone tries creating a statement from that connection.