Erroo

Front-end
#1

Boa noite galera, estou começando a aprender Java Web e tentando fazer um projeto
ele apresenta o seguinte erro.
<%
21:27:34,483 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver from [Module "deployment.Agenda.war:main" from Service Module Loader]

21:27:34,484 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190)

21:27:34,485 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468)

21:27:34,486 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456)

21:27:34,487 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398)

21:27:34,488 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120)

21:27:34,489 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at java.lang.Class.forName0(Native Method)

21:27:34,489 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at java.lang.Class.forName(Unknown Source)

21:27:34,490 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at DAO.FabricaConexao.fazConexao(FabricaConexao.java:10)

21:27:34,491 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at Action.InserirContato.doPost(InserirContato.java:60)

21:27:34,491 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)

21:27:34,492 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

21:27:34,493 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

21:27:34,494 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

21:27:34,495 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

21:27:34,496 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

21:27:34,498 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

21:27:34,499 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

21:27:34,500 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

21:27:34,501 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

21:27:34,502 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

21:27:34,503 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

21:27:34,503 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)

21:27:34,504 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

21:27:34,505 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at java.lang.Thread.run(Unknown Source)

21:27:34,518 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver from [Module "deployment.Agenda.war:main" from Service Module Loader]

21:27:34,519 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190)

21:27:34,520 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468)

21:27:34,522 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456)

21:27:34,523 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398)

21:27:34,524 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120)

21:27:34,524 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at java.lang.Class.forName0(Native Method)

21:27:34,525 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at java.lang.Class.forName(Unknown Source)

21:27:34,525 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at DAO.FabricaConexao.fazConexao(FabricaConexao.java:10)

21:27:34,526 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at DAO.JDBCContatoDAO.<init>(JDBCContatoDAO.java:16)

21:27:34,527 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at Action.InserirContato.doPost(InserirContato.java:62)

21:27:34,531 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)

21:27:34,532 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

21:27:34,533 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

21:27:34,536 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

21:27:34,537 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

21:27:34,538 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

21:27:34,539 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

21:27:34,540 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

21:27:34,541 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

21:27:34,542 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

21:27:34,543 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

21:27:34,544 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

21:27:34,547 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)

21:27:34,548 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

21:27:34,549 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) at java.lang.Thread.run(Unknown Source)

21:27:34,550 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/Agenda].[InserirContato]] (http-localhost-127.0.0.1-8080-2) Servlet.service() for servlet InserirContato threw exception: java.lang.NullPointerException
at DAO.JDBCContatoDAO.inserir(JDBCContatoDAO.java:27) [classes:]
at Action.InserirContato.doPost(InserirContato.java:63) [classes:]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_11] %>

e não consigo resolver , será que alguem pode me ajudar?

#2

Provavelmente vc está sem o driver do mysql

#3

então eu fiz uma classe para testar conexão e me retorna que está conectado,mas hora que vou salvar os dados do
formulário acontece esse erro.

#4

manda o código da classe que ta dando erro

#5

classe conexão

package DAO;

import java.sql.Connection;

public class FabricaConexao {
	private java.sql.Connection conexao;
	
	public Connection fazConexao(){
		try{
			Class.forName("org.gjt.mm.mysql.Driver");
			conexao = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/contato","root","");
		}catch(Exception e){
			e.printStackTrace();
		}
		return conexao;
	}
	
	public void fecharConexao(){
		try {
			conexao.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

classe contato

package Model;

import java.util.Date;

public class Contato {
	
	private int codigo;
	private String nome;
	private String telefone;
	private String celular;
	private Date dataNascimento;
	private String endereco;
	private String cidade;
	private String estado;
	
	
	public int getCodigo() {
		return codigo;
	}
	public void setCodigo(int codigo) {
		this.codigo = codigo;
	}
	public String getNome() {
		return nome;
	}
	public void setNome(String nome) {
		this.nome = nome;
	}
	public String getTelefone() {
		return telefone;
	}
	public void setTelefone(String telefone) {
		this.telefone = telefone;
	}
	public String getCelular() {
		return celular;
	}
	public void setCelular(String celular) {
		this.celular = celular;
	}
	public Date getDataNascimento() {
		return dataNascimento;
	}
	public void setDataNascimento(Date dataNascimento) {
		this.dataNascimento = dataNascimento;
	}
	public String getEndereco() {
		return endereco;
	}
	public void setEndereco(String endereco) {
		this.endereco = endereco;
	}
	public String getCidade() {
		return cidade;
	}
	public void setCidade(String cidade) {
		this.cidade = cidade;
	}
	public String getEstado() {
		return estado;
	}
	public void setEstado(String estado) {
		this.estado = estado;
	}

classe dao


import java.util.List;

import Model.Contato;

public interface ContatoDAO {
	public void inserir(Contato contato);
	public List&lt;Contato&gt; listarTodos();
}

classe jdbcdao

public class JDBCContatoDAO implements ContatoDAO{

		
	Connection conexao;
	
	public JDBCContatoDAO(Connection conexao){
		this.conexao = new FabricaConexao().fazConexao();
	}
	
	@Override
	public void inserir(Contato contato) {
		String comando = "insert into Contato (nome,telefone,celular,dataNascimento, endereco, cidade, estado)" +
							"values(?,?,?,?,?,?,?)";
		
		
		try {
			
			PreparedStatement p = conexao.prepareStatement(comando);
			p.setString(1,contato.getNome());
			p.setString(2,contato.getTelefone());
			p.setString(3,contato.getCelular());
			p.setDate(4,new java.sql.Date(contato.getDataNascimento().getTime()));
			p.setString(5, contato.getEndereco());
			p.setString(6,contato.getCidade());
			p.setString(7,contato.getEstado());
			 
			p.execute();
			p.close();
			
			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		
		
		
	}

	@Override
	public List&lt;Contato&gt; listarTodos() {
		// TODO Auto-generated method stub
		return null;
	}

servlet


public class InserirContato extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public InserirContato() {
		super();

	}

	protected void doGet(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {

	}

	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		System.out.println("Servelt executando gravação de contato!!!!");

		String nome = request.getParameter("nome");
		String telefone = request.getParameter("telefone");
		String celular = request.getParameter("celular");
		String nascimentoSt = request.getParameter("nascimento");
		String endereco = request.getParameter("endereco");
		String cidade = request.getParameter("cidade");
		String estado = request.getParameter("estado");

		Date date = null;
		try {
			date = new SimpleDateFormat("dd/MM/yyyy").parse(nascimentoSt);
		} catch (ParseException e) {
			e.printStackTrace();
		}

		Contato novoContato = new Contato();
		novoContato.setNome(nome);
		novoContato.setTelefone(telefone);
		novoContato.setCelular(celular);
		novoContato.setDataNascimento(date);
		novoContato.setEndereco(endereco);
		novoContato.setCidade(cidade);
		novoContato.setEstado(estado);

		FabricaConexao fabrica = new FabricaConexao();
		Connection conexao = fabrica.fazConexao();

		JDBCContatoDAO dao = new JDBCContatoDAO(conexao);
		dao.inserir(novoContato);

	}

}

e o formulario

&lt;%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%&gt;
&lt;!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"&gt;
&lt;html&gt;
&lt;head&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"&gt;
&lt;title&gt;Agenda de Contatos&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
	&lt;form action="InserirContato" method="post"&gt;
		Nome: &lt;input type="text" name="nome" /&gt;<br />
		Telefone: &lt;input type="text" name="telefone" /&gt;<br />
		Celular: &lt;input type="text" name="celular" /&gt;<br />
		Nascimento: &lt;input type="text" name="nascimento" /&gt;<br />
		Endereço: &lt;input type="text" name="endereco" /&gt;<br />
		Cidade: &lt;input type="text" name="cidade" /&gt;<br />
		Estado: &lt;input type="text" name="estado" /&gt;<br />
&lt;input type="submit" value="Gravar" /&gt;
	&lt;/form&gt;	
&lt;/body&gt;
&lt;/html&gt;

ai apresenta o erro que postei acima

#6

A classe que voce usou para testar a conexão,é de um projeto paralelo? Ou voce utilizou o mesmo projeto para testar?

#7

mesmo projeto, e fala que a conexão esta aberta, essa foi a classe

	public static void main(String [] args)throws SQLException{
		Connection con = new FabricaConexao().fazConexao();
		System.out.println("Conexão Aberta");
		con.close();
}
}

e já testei , quando insiro dados por uma classe, ele grava no banco
agora pelo formulário não grava

#8

será que alguém poderia me ajudar?

#9