Desenvolvi uma aplicação com ZK, ela acessa um banco de dados mysql 5 com conector 3.1.6 +
java 6.15. Instalei essa aplicação no meu computador e está funcionando sem problemas.
Instalei a mesma aplicação no servidor da minha hospedagem. Está aparecendo um erro em
tempo de execução quando se escolhe a opção “Agenda” no menu da aplicação. Depois que
se clica no botão OK a aplicação apresenta a tela de cadastro, mas sem preencher o grid
com os dados da respectiva tabela.
ACESSE O ENDEREÇO: www.vpcamargo.kinghost.net/AgEletronicaMVC/inde.zul.
Segue os erros encontrados no catalina.out.
Feb 24, 2009 12:08:04 AM org.apache.catalina.startup.HostConfig checkResources
INFO: Undeploying context [/AgEletronicaMVC]
The event processing thread stops
Feb 24, 2009 12:12:34 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:12:34 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:12:44 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:12:44 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:12:54 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added : ‘Filters.jar’
Feb 24, 2009 12:12:54 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:13:04 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:13:04 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:13:14 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:13:14 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:13:24 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:13:24 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:13:34 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:13:34 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:13:44 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:13:44 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:13:54 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:13:54 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:14:04 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:14:04 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:14:14 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:14:14 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:14:24 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:14:24 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:14:34 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:14:34 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:14:44 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:14:44 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:14:54 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:14:54 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:15:04 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:15:04 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:15:14 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:15:14 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:15:24 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:15:24 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:15:34 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:15:34 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:15:44 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added
Feb 24, 2009 12:15:44 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:15:54 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added : ‘zk.jar’
Feb 24, 2009 12:15:54 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:16:05 AM org.apache.catalina.loader.WebappClassLoader modified
INFO: Additional JARs have been added : ‘zul.jar’
Feb 24, 2009 12:16:05 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
Feb 24, 2009 12:16:05 AM org.zkoss.zk.ui.sys.ConfigParser parseConfigXml:125
INFO: Loading system default
Feb 24, 2009 12:17:52 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/jdk1.6.0_05/jre/lib/i386/server:/usr/java/jdk1.6.0_05/jre/lib/i386:/usr/java/jdk1.6.0_05/jre/…/lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
Feb 24, 2009 12:17:52 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-10010
Feb 24, 2009 12:17:52 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 338 ms
Feb 24, 2009 12:17:52 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Feb 24, 2009 12:17:52 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.10
Feb 24, 2009 12:17:52 AM org.zkoss.zk.ui.sys.ConfigParser parseConfigXml:125
INFO: Loading system default
Feb 24, 2009 12:17:53 AM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Feb 24, 2009 12:17:53 AM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Feb 24, 2009 12:17:53 AM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeAdded(‘org.apache.catalina.Registry’, ‘org.apache.tomcat.util.modeler.Registry@b1a4e2’)
Feb 24, 2009 12:17:53 AM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeAdded(‘org.apache.catalina.MBeanServer’, ‘com.sun.jmx.mbeanserver.JmxMBeanServer@c00025’)
Feb 24, 2009 12:17:53 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-10010
Feb 24, 2009 12:17:53 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:10011
Feb 24, 2009 12:17:53 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/17 config=null
Feb 24, 2009 12:17:53 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 1153 ms
Feb 24, 2009 12:18:23 AM org.zkoss.zk.ui.impl.UiEngineImpl handleError:1107
SEVERE: >>java.lang.NullPointerException
at AgendaEletronicaMVC.DAO.AgendaDAO.listaAgendaAll(AgendaDAO.java:21) at AgendaEletronicaMVC.controle.AgendaControle.preencheListaPesqAgenda(AgendaControle.java:89) at AgendaEletronicaMVC.controle.AgendaControle.onCreate(AgendaControle.java:81) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.zkoss.zk.ui.impl.EventProcessor.process0(EventProcessor.java:213) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:143) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:48 …
pedaço da classe AgendaDAO:
01 package AgendaEletronicaMVC.DAO;
02
03 import AgendaEletronicaMVC.modelo.<em>;
04 import java.sql.</em>;
05 import com.mysql.jdbc.Connection;
06 import java.util.Vector;
07
08 public class AgendaDAO {
09 public Conexao conexao = new Conexao();
10
11
12 // TABELA AGENDA - METODOS DE PERSISTENCIA - INICIO
12 public Vector listaAgendaAll() throws SQLException
14 {
15 Agenda a;
16 Vector v = new Vector();
17 Connection conn = null;
18 conn= conexao.abreConexaoBD();
19 ResultSet rs = null;
20 Statement st = null;
21 st = conn.createStatement();
22 rs= st.executeQuery(“select * from agenda order by nome”);
…
Corrige o código, inserindo a linha 17 (Connection conn = null).
a conexão ocorre na classe Conexao (que está instanciada na linha 09) através
do método abreConexao (na linha 1.
A classe Conexao é a seguinte:
package AgendaEletronicaMVC.DAO;
import java.sql.*;
import java.sql.DriverManager;
import com.mysql.jdbc.Connection;
public class Conexao
{
//usuário e senha
private String login = “root”;
private String senha = “”;
// IP do servidor do banco
private String host = “localhost”;
// Nome do banco de dados
private String dbName = “vpcamargo”;
// URL de conexao do banco
private String url = “jdbc:mysql://” + host + “/” + dbName;
// Objeto do tipo Connection para estabelecer a conexão
public Connection conexao = null;
// Objeto Statement usado para enviar consultas para o banco de dados
public Statement stmt = null;
public ResultSet r = null;
public Conexao() { }
public Connection abreConexaoBD()
{
try
{
try
{
Class.forName(“com.mysql.jdbc.Driver”);
}
catch (ClassNotFoundException ex)
{
return null;
}
try
{
// efetua conexao com o banco de dados
this.conexao =
(Connection) DriverManager.getConnection(url,login,senha);
}
catch (SQLException ex)
{
return null;
}
return this.conexao;
}
catch (Exception e)
{
return null;
}
}
}
AGUARDO UMA AJUDA. GRATO PELA ATENÇÃO
