O seu arquivo .class deve estar num diret�rio com o mesmo nome do pacote.
Repare que voc� declarou: "package Servlelts;" e n�o Servlets como � o nome
do diret�rio.
[]s
RODRIGO MIGUEL
Business Intelligence - Logocenter S.A.
----- Original Message -----
From: "Ricardo Slobodeicov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 7:10 PM
Subject: [java-list] JSP + COMBO BOX + BANCO DE DADOS
> Salve galera do Java !!
>
> Pessoal,
>
> Gostaria de saber se algu�m pode me dar alguma dica para que eu possa usar
JSP e quem sabe JavaBeans ou alguma outra tecnologia para poder "popular" um
combo box de uma p�gina html (ou p�gina *.jsp) com informa��es de uma tabela
de um banco de dados.
>
> � preciso que quando a p�gina seja carregada no navegador o combo box
dessa p�gina seja populado com as informa��es atuais de uma determinada
tabela de um banco de dados DB2.
>
> Tentei usar o c�digo a seguir em uma p�gina JSP, mas n�o est� dando certo.
O servidor (Tomcat) d� uma mensagem de erro dizendo que n�o foi poss�vel
compilar a p�gina jsp.
>
> ---------------------------------------
> <%@ page import="java.util.* " %>
> <jsp:useBean id="item" class="Servlets.BeanList">
> <%
>
> ArrayList meuArray;
> int tamanho;
> BeanList item = new BeanList();
> meuArray = item.buscarPais();
> tamanho = meuArray.size();
>
> <select name="pais">
> <option>Escolha sua opcao</option>
> <% for (int i = 0; i < tamanho; i++) { %>
> <option value="<%= (String) meuArray.get(i) %>">
> </option>
> <% } %>
> </select>
>
> %>
> </jsp:useBean>
> ---------------------------------------
>
>
> Ps.: A classe BeanList � a seguinte:
>
> ---------------------------------------
> package Servlelts;
>
> import java.util.*;
> import java.sql.*;
>
> public class BeanList {
>
> Connection connection;
> Statement statement;
> ArrayList resultBusca;
> String url;
> String query;
>
> public ArrayList buscarPais() {
>
> resultBusca = new ArrayList();
>
> query =
> "SELECT nm_pais FROM pais";
>
> try {
> Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
> url = "jdbc:db2:banco";
> connection = DriverManager.getConnection(url, "usuario",
"senha");
> statement = connection.createStatement();
> ResultSet rs = statement.executeQuery(query);
> ResultSetMetaData rsmd = rs.getMetaData();
> rs.next();
> for (int i = 1; i <= rsmd.getColumnCount(); i++) {
> resultBusca.add(rs.getString(i));
> }
> statement.close();
>
> } catch (Exception e) {
> System.err.println("Erro ao tentar buscar o contato.");
> e.printStackTrace();
> }
>
> return resultBusca;
> }
> ---------------------------------------
>
> AS MENSAGENS DE ERRO S�O AS SEGUINTES:
>
> Error: 500
> Location: /JapiControle/Html/teste2.jsp
> Internal Servlet Error:
>
> org.apache.jasper.JasperException: Unable to compile class for JSP
> at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:630)
> at
org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
> at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:542)
> at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:258)
> at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:268)
> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
> at org.apache.tomcat.core.Handler.service(Handler.java:287)
> at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:80
6)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:752)
> at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:213)
> at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
> at java.lang.Thread.run(Thread.java:484)
>
> Root cause:
> java.lang.NullPointerException
> at
org.apache.jasper.compiler.GetPropertyGenerator.generate(GetPropertyGenerato
r.java:100)
> at
org.apache.jasper.compiler.JspParseEventListener$GeneratorWrapper.generate(J
spParseEventListener.java:771)
> at
org.apache.jasper.compiler.JspParseEventListener.generateAll(JspParseEventLi
stener.java:220)
> at
org.apache.jasper.compiler.JspParseEventListener.endPageProcessing(JspParseE
ventListener.java:175)
> at org.apache.jasper.compiler.Compiler.compile(Compiler.java:210)
> at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:612)
> at
org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
> at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:542)
> at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:258)
> at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:268)
> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
> at org.apache.tomcat.core.Handler.service(Handler.java:287)
> at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:80
6)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:752)
> at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:213)
> at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
> at java.lang.Thread.run(Thread.java:484)
>
> ---------------------------------------
> E MAIS ESSA:
>
> org.apache.jasper.JasperException: Unable to compile class for
JSPC:\jakarta-tomcat-3.2.4\webapps\JapiControle\WEB-INF\classes\Servlets\Bea
nList.java:1: The source file encoding may be different with this platform
encoding. Please use -encoding option to adjust file encoding, or apply
native2ascii utility to make source file ASCII encoding.
>
>
> error: File
C:\jakarta-tomcat-3.2.4\webapps\JapiControle\WEB-INF\classes\Servlets\BeanLi
st.java does not contain type Servlets.BeanList as expected. Please adjust
the class path so that the file does not appear in the package Servlets.
>
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_
00031_0002ejsp1_jsp_1.java:67: Class Servlets.BeanList not found.
> Servlets.BeanList item = null;
> ^
>
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_
00031_0002ejsp1_jsp_1.java:70: Class Servlets.BeanList not found.
> item= (Servlets.BeanList)
> ^
>
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_
00031_0002ejsp1_jsp_1.java:75: Class Servlets.BeanList not found.
> item = (Servlets.BeanList)
Beans.instantiate(this.getClass().getClassLoader(), "Servlets.BeanList");
> ^
>
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_
00031_0002ejsp1_jsp_1.java:91: Class Html.BeanList not found.
> BeanList item = new BeanList();
> ^
>
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_
00031_0002ejsp1_jsp_1.java:91: Variable 'item' is already defined in this
method.
> BeanList item = new BeanList();
> ^
>
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_
00031_0002ejsp1_jsp_1.java:91: Class Html.BeanList not found.
> BeanList item = new BeanList();
> ^
> 8 errors
>
> ---------------------------------------
>
> Agrade�o a quem possa me ajudar.
> Valeu !!!
>
> ------------------------------ LISTA SOUJAVA ----------------------------
> http://www.soujava.org.br - Sociedade de Usu�rios Java da Sucesu-SP
> d�vidas mais comuns: http://www.soujava.org.br/faq.htm
> regras da lista: http://www.soujava.org.br/regras.htm
> historico: http://www.mail-archive.com/java-list%40soujava.org.br
> para sair da lista: envie email para [EMAIL PROTECTED]
> -------------------------------------------------------------------------
------------------------------ LISTA SOUJAVA ----------------------------
http://www.soujava.org.br - Sociedade de Usu�rios Java da Sucesu-SP
d�vidas mais comuns: http://www.soujava.org.br/faq.htm
regras da lista: http://www.soujava.org.br/regras.htm
historico: http://www.mail-archive.com/java-list%40soujava.org.br
para sair da lista: envie email para [EMAIL PROTECTED]
-------------------------------------------------------------------------
