Erro jsp...java.lang.NullPointerException

2 respostas
S

quando clico no link para chamar esse codigo ele apresenta o seguinte erro:

O seguinte erro foi encontrado:
java.lang.NullPointerException

<%<a class="mention" href="/u/page">@page</a> contentType=“text/html” import=“java.util.<em>, <a href="http://java.io">java.io</a>.</em>, java.text.<em>, java.util.Calendar.</em>, java.sql.*, DateFormat, ConectaMysql” %>

<%@ page errorPage=“error.jsp”%>

<%@ include file=“conecta.jsp” %>

<%

String sess = (String) session.getAttribute(“sessao”);

if (!(sess != null && sess.equals(“autorizado”))) {

%>
&lt;jsp:forward page="denied.jsp" /&gt;
<%

}else{

Statement stm = mysql.getConnection().createStatement();

String[] prefGerencia = new String[10];

String[] siglaGerencia = new String[10];

String[] subitemAri = new String[200];

String[] nomeSubitem = new String[200];

int totalGerencias = 0;

int totalSubitens = 0;

ResultSet resGerencias = stm.executeQuery(“SELECT pref_gerencia, sigla FROM gerencias WHERE pref_gerencia <> 8080 ORDER BY sigla”);

while(resGerencias.next()){

totalGerencias = resGerencias.getRow() - 1;

prefGerencia[totalGerencias] = resGerencias.getString(“pref_gerencia”);

siglaGerencia[totalGerencias] = resGerencias.getString(“sigla”);

}

ResultSet resSubitens = stm.executeQuery(“SELECT subitem_ari, nome_subitem FROM da_ari_subitens ORDER BY subitem_ari”);

while(resSubitens.next()){

totalSubitens = resSubitens.getRow() - 1;

subitemAri[totalSubitens] = resSubitens.getString(“subitem_ari”);

nomeSubitem[totalSubitens] = resSubitens.getString(“nome_subitem”);

}

%>

2 Respostas

Claire

Este erro é o mais fácil de se ter…

Algum parâmetro ou variável testada está tentando fazer uma operação ilegal, por esta estar nula.

Antes do while teste se o resultset está nulo.
Mas, pode ser outras coisas…

Até
Claire

S

Claire

Não consigo achar o erro neste código mesmo com a sua dica, poderia me dar outra informação?

<%<a class="mention" href="/u/page">@page</a> contentType=“text/html” import=“java.util.<em>, <a href="http://java.io">java.io</a>.</em>, java.text.<em>, java.util.Calendar.</em>, java.sql.*, ConectaAccess” %>

<%@ page isErrorPage=“true” %>

<%

String sess = (String) session.getAttribute(“sessao”);

if (!(sess != null && sess.equals(“autorizado”))) {

%>

<jsp:forward page=“denied.jsp” />

<%

}

%>

<html>

<head>

<title>Despesas Administrativas - EO</title>

<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1”>

<link href="…/_styles/bb_ie.css" rel=“stylesheet” type=“text/css”>

<script language=JavaScript src="…/inf.js" type=text/javascript></script>

<script language=JavaScript src="…/menu.js" type=text/javascript></script>

</head>
<table width="100%" border="0" cellspacing="4" cellpadding="0"> <tr> <td width="20%" valign="top" height="330"> <TABLE bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0 width=155> <TBODY> <TR>
&lt;TD align="left" bgColor=#F0CF1F height=16 width=6&gt;&amp;nbsp;&lt;/TD&gt;
        
        &lt;TD align="left" bgColor=#F0CF1F vAlign=center width=149&gt;<a 
        class=subtitulo 
        href="indexorcamento.jsp?url=0"><b>In&amp;iacute;cio</b></a>&lt;/TD&gt;

      &lt;/TR&gt;
    &lt;TR&gt;
      &lt;TD bgColor=#F0CF1F colSpan=2&gt;<IMG alt="" border=0 height=1 
        src="../Intranet/imagens/dotBranco.gif" vspace=3 width="100%">&lt;/TD&gt;

</TR>
<TR>

&lt;TD align="left" bgColor=#F0CF1F height=16 width=6&gt;&amp;nbsp;&lt;/TD&gt;
        
        &lt;TD align="left" bgColor=#F0CF1F vAlign=center width=149&gt;<a 
        class=subtitulo 
        href="indexorcamento.jsp?url=1">Defini&amp;ccedil;&amp;atilde;o</a>&lt;/TD&gt;

      &lt;/TR&gt;
    &lt;TR&gt;
      &lt;TD bgColor=#F0CF1F colSpan=2&gt;<IMG alt="" border=0 height=1 
        src="../Intranet/imagens/dotBranco.gif" vspace=3 width="100%">&lt;/TD&gt;

</TR>
<TR>

&lt;TD align="left" bgColor=#F0CF1F height=16 width=6&gt;&amp;nbsp;&lt;/TD&gt;
        
        &lt;TD align="left" bgColor=#F0CF1F vAlign=center width=149&gt;<a 
        class=subtitulo 
        href="indexorcamento.jsp?url=2">Caracter&amp;iacute;sticas</a>&lt;/TD&gt;

      &lt;/TR&gt;
    &lt;TR&gt;
      &lt;TD bgColor=#F0CF1F colSpan=2&gt;<IMG alt="" border=0 height=1 
        src="../Intranet/imagens/dotBranco.gif" vspace=3 width="100%">&lt;/TD&gt;

</TR>
<TR>

&lt;TD align="left" bgColor=#F0CF1F height=16 width=6&gt;&amp;nbsp;&lt;/TD&gt;
        
        &lt;TD align="left" bgColor=#F0CF1F vAlign=center width=149&gt;<a 
        class=subtitulo 
        href="indexorcamento.jsp?url=3">Gestoras/Executoras</a>&lt;/TD&gt;

      &lt;/TR&gt;
    &lt;TR&gt;
      &lt;TD bgColor=#F0CF1F colSpan=2&gt;<IMG alt="" border=0 height=1 
        src="../Intranet/imagens/dotBranco.gif" vspace=3 width="100%">&lt;/TD&gt;

</TR>
<TR>

&lt;TD align="left" bgColor=#F0CF1F height=16 width=6&gt;&amp;nbsp;&lt;/TD&gt;
        
        &lt;TD align="left" bgColor=#F0CF1F vAlign=center width=149&gt;<a 
        class=subtitulo 
        href="indexorcamento.jsp?url=4">Despesas Administrativas</a>&lt;/TD&gt;

      &lt;/TR&gt;
    &lt;TR&gt;
      &lt;TD bgColor=#F0CF1F colSpan=2&gt;<IMG alt="" border=0 height=1 
        src="../Intranet/imagens/dotBranco.gif" vspace=3 width="100%">&lt;/TD&gt;

</TR>
<TR>

&lt;TD align="left" bgColor=#F0CF1F height=16 width=6&gt;&amp;nbsp;&lt;/TD&gt;
        
        &lt;TD align="left" bgColor=#F0CF1F vAlign=center width=149&gt;<a 
        class=subtitulo 
        href="indexorcamento.jsp?url=5">Investimentos</a>&lt;/TD&gt;

      &lt;/TR&gt;
    &lt;TR&gt;
      &lt;TD bgColor=#F0CF1F colSpan=2&gt;<IMG alt="" border=0 height=1 
        src="../Intranet/imagens/dotBranco.gif" vspace=3 width="100%">&lt;/TD&gt;

</TR>
<TR>

&lt;TD align="left" bgColor=#F0CF1F height=16 width=6&gt;&amp;nbsp;&lt;/TD&gt;
        &lt;TD align="left" bgColor=#F0CF1F vAlign=center width=149&gt;<a 
        class=subtitulo 
        href="indexorcamento.jsp?url=6">Impacto na GDP</a>&lt;/TD&gt;

      &lt;/TR&gt;
    &lt;TR&gt;
      &lt;TD bgColor=#F0CF1F colSpan=2&gt;<IMG alt="" border=0 height=1 
        src="../Intranet/imagens/dotBranco.gif" vspace=3 width="100%">&lt;/TD&gt;

</TR>
<TR>

&lt;TD align="left" bgColor=#F0CF1F height=16 width=6&gt;&amp;nbsp;&lt;/TD&gt;
        
        &lt;TD align="left" bgColor=#F0CF1F vAlign=center width=149&gt;<a 
        class=subtitulo 
        href="daeo.jsp">Or&amp;ccedil;ado/Realizado</a>&lt;/TD&gt;

      &lt;/TR&gt;
</table>

</td>

<td width=“80%” valign=“top” align=“center”>

<img width="600" height="100">


<table width=“100%” height=“25” border=“0” cellspacing=“0” cellpadding=“0” background=“bgSubMenu.gif”>

<tr>

<td width=“118” align=“right”><a><strong>Orcado</strong></a></td>

<td width=“36”>&nbsp;</td>

<td width=“81” align=“center”><a><strong>Realizado</strong></a></td>

<td width=“36”>&nbsp;</td>

<td width=“76” align=“center”><a><strong>Treinamento</strong></a></td>

<td width=“36”>&nbsp;</td>

<td width=“45” align=“center”><a><strong>Deslocamento</strong></a></td>

<td width=“36”>&nbsp;</td>

<td width=“48” alig=“center”><a><strong>Relat&oacute;rios</strong></a></td>

<td><img src="/portal/img/dot.gif" width="1" height="1"></td>

</tr>

</table>










O seguinte erro foi encontrado:


<%= exception.printStackTrace()%>


Entre em contato com o administrador do sistema.</td>

</tr>

<tr>

<td colspan=“2”>

<table width=“100%” background="…/_images/index/fd.gif">

<tr>

<td><font class=“c”>EO-Estrat&eacute;gia e Organiza&ccedil;&atilde;o</font></td>

<td align=“center”><font class=“c”>SBS, Ed. Sede III, 18&ordm;

andar - CEP 70073-901</font></td>

<td align=“center”><font class=“c”>Pabx 310.3503 - Fax 310.4184</font></td>

<td align=“right”><font class=“c”> [email removido]</font></td>

</tr>

</table>

</td>

</tr>

</table>
</html>
Criado 27 de novembro de 2003
Ultima resposta 27 de nov. de 2003
Respostas 2
Participantes 2