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