JSP + Servlet + Firebird 1.5

felipereisbr · Outubro 17, 2006, 7:02pm

Olá Gente, estou usando o Firebird 1.5 com o drive jaybird-full-2.0.1.jar.
Mas quando executo meu projeto no servidor ele gera o seguinte erro:

java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver

Aguem sabe como configurar o classpatch??


private static java.sql.Connection conexao ;

	private static void criaConexao()
	{
		String strDriver = "org.firebirdsql.jdbc.FBDriver";
		String strUrl    = "jdbc:firebirdsql:localhost/3050:C:/BDLOCADORA.GDB";
		String strUser   = "sysdba";
		String strSenha	= "masterkey";
		
		try
		{
			System.out.println("Pegando driver para conexao com banco de dados");
			Class.forName(strDriver);
			
			System.out.println("Iniciando conexao com as seguintes configuracoes:" 
					+"\n - URL:["+strUrl+"]"
					+"\n - Usuario:["+strUser+"]" 
					+"\n - Senha:["+strSenha+"]");
			
			conexao = DriverManager.getConnection(strUrl,strUser,strSenha);
			System.out.println("\nConexao com banco de dados estabelecida com sucesso.");
		}
		catch(ClassNotFoundException exc)
		{
		//	System.err.print("ClassNotFoundException: "+exc.getMessage());
			//System.err.println(exc.getMessage());
			//System.out.println("não conectou");
		}
		catch(SQLException exc) 
        {
            System.err.println("Falha na tentativa de conexao: " + exc.getMessage());
        }
	}

Grato Reis

fcoury · Outubro 17, 2006, 7:05pm

Reis,

Que servidor você está usando (UNIX, Linux, Windows, …)?

Como está o CLASSPATH atual do servidor?

Você tentou rodar usando o -classpath do executável java?
Ex.: java mypackage.MyClass -classpath ./jaybird-full-2.0.1.jar

Veja isso e me avisa, que tento te ajudar.

Abraços!

Felipe.

felipereisbr · Outubro 17, 2006, 7:21pm

Olá , tipo , estou usando o seguinte:

S.O: Windows XP;
Drive: jaybird-2.0.1;
Servidor: Tomcat 5.5;
Eclipse Lomboz ;

Coloquei os arquivos do JayBird no diretório:

ProjetoHomemMaquinaWeb\WebContent\WEB-INF\lib\JayBird
dentro dele tem:
jaybird-pool-2.0.1.jar
jaybird-2.0.1.jar
jaybird-full-2.0.1.jar

Se poder ajuar… ficarei Grato !!

[]´s Reis

fcoury · Outubro 17, 2006, 7:23pm

O que tentaria seria tirar de dentro do diretório JayBird, deixando direto no WEB-INF\lib.

Veja se isso funciona, ok?

Abraços!

felipereisbr · Outubro 17, 2006, 7:27pm

tipo, ja tentei e continuou dando o mesmo erro !

A chamada dos drives no meu codigo está correta?

[]´s

fcoury · Outubro 17, 2006, 7:33pm

Cara,

De acordo com a documentação tá certinho…

Você já tentou rodar a classe direto, por fora do TomCat, fazendo algo como:

java nomedaclasse -classpath ProjetoHomemMaquinaWeb\WebContent\WEB-INF\lib\JayBird\ jaybird-full-2.0.1.jar

???

Porque o erro que você está tendo PARECE ser um problema de classpath mesmo…

felipereisbr · Outubro 17, 2006, 7:38pm

Tipo, quando eu rodo fora da “web” , ou seja, por um metodo main na classe , ele roda certinha, faz tudo ok! o problema é no servidor !

como posso resolver esse problema de classpatch??

[]´s

fcoury · Outubro 17, 2006, 7:40pm

Uma idéia é colocar o jar dentro do diretório do próprio tomcat, não lembro exatamente qual é porque estou sem ele agora, mas é algo como common/lib, server/lib ou shared/lib… Dá uma olhadinha por favor!!!

felipereisbr · Outubro 17, 2006, 8:00pm

Olá fiz isso que tu falou, coloquei na pasta common\lib, e ele mi apresentou um erro diferente . veja:


at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values

[]´s

fcoury · Outubro 17, 2006, 10:55pm

Então, isso é uma boa notícia!

Você passou daquele ponto, está dando erro em outro lugar. Este tipo de erro normalmente dá quando você tenta fazer um insert com mais campos ou menos campos na parte dos valores (VALUES).

Manda a exceção inteira, por favor!

Abraços!

felipereisbr · Outubro 18, 2006, 2:19pm

tipo, revisei meu código, mas não estou conseguindo achar o erro, ja revisei o numero de colunas i tal´s,

Obs: quando executo pelo “main” ele não mi da esse “erro” do “numero de colunas”, ele inseri direitinho!

vou postar abaixo meu codigo pra tu dar uma olhadinha!!!

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<form action='CadastroFuncionario' method="POST">
Cadastro de Funcionários: <br />
Nome: <input type='text' name='nome_func'/><br/>
Sobrenome: <input type='text' name='sobrenome_func'/><br/>
CPF: <input type='text' name='cpf_func'/><br/>
RG: <input type='text' name='rg_func'/><br/>
Sexo:<BR><INPUT TYPE="RADIO" NAME="sexo_func" VALUE="M"> Masculino<BR>
<INPUT TYPE="RADIO" NAME="sexo_func" VALUE="F"> Feminino <BR>
Telefone:  <input type='text' name='telefone_func'/><br/>
Data de Nascimento:  <input type='text' name='data_func'/><br/>
E-mail: <input type='text' name='email_func'/><br/>
Senha: <input type='text' name='senha_func'/><br/>
<input type="submit" value="enviar">
</form>


</body>
</html>

AcessoDados.java

package br.com.estacio.faculdade.base;

import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class AcessoDados {

	private static java.sql.Connection conexao ;

	private static void criaConexao()
	{
		String strDriver = "org.firebirdsql.jdbc.FBDriver";
		String strUrl    = "jdbc:firebirdsql:localhost/3050:C:/BDLOCADORA.GDB";
		String strUser   = "sysdba";
		String strSenha	= "masterkey";
		
		try
		{
			System.out.println("Pegando driver para conexao com banco de dados");
			Class.forName(strDriver);
			
			System.out.println("Iniciando conexao com as seguintes configuracoes:" 
					+"\n - URL:["+strUrl+"]"
					+"\n - Usuario:["+strUser+"]" 
					+"\n - Senha:["+strSenha+"]");
			
			conexao = DriverManager.getConnection(strUrl,strUser,strSenha);
			System.out.println("CONECTOU");
			System.out.println("\nConexao com banco de dados estabelecida com sucesso.");
		}
		catch(ClassNotFoundException exc)
		{
		//	System.err.print("ClassNotFoundException: "+exc.getMessage());
			//System.err.println(exc.getMessage());
			//System.out.println("não conectou");
		}
		catch(SQLException exc) 
        {
            System.err.println("Falha na tentativa de conexao: " + exc.getMessage());
        }
	}
	
	private static void encerraConexao()
	{
		try
		{
			System.out.println("Encerrando conexao...");
			conexao.close();
		}
		catch(SQLException exc)
		{
			System.err.println("Falha no encerramento da conexao: " + exc.getMessage());
		}
	}
	 
	public static void inserirFuncionario(Funcionario f) throws Exception {
		criaConexao();		
		

	String strSQL = "INSERT INTO funcionarios " +
	" (func_nome,func_sobrenome,func_data,func_rg,func_cpf,func_sexo,func_telefone,func_senha,func_email) "+
	" VALUES (?,?,?,?,?,?,?,?,?);";
	conexao.setAutoCommit(false);

	
		PreparedStatement stmt = conexao.prepareStatement(strSQL);
		 System.out.println("passou akifeli");
		 stmt.setString(1, f.getNome());
		 stmt.setString(2, f.getSobrenome());
		 stmt.setString(3, f.getDatan());
		 stmt.setString(4, f.getRg());
		 stmt.setString(5, f.getCpf());
		 stmt.setString(6, f.getSexo());
		 stmt.setString(7, f.getTelefone());
		 stmt.setString(8, f.getSenha());
		 stmt.setString(9, f.getEmail());
		 
		 int num = stmt.executeUpdate();
		 
		 System.out.println("passou akifei");
		 
	    stmt.close();
	    conexao.commit();

	}
	
	
}

CadastroFuncionario


package br.com.estacio.faculdade.dominios;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.sun.org.apache.xalan.internal.xsltc.runtime.Hashtable;

import br.com.estacio.faculdade.base.AcessoDados;
import br.com.estacio.faculdade.base.AcessoDadosFuncionario;
import br.com.estacio.faculdade.base.Endereco;
import br.com.estacio.faculdade.base.Funcionario;
import br.com.estacio.faculdade.base.Pessoa;

 public class CadastroFuncionario extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
    
	public CadastroFuncionario() {
		super();
	}   	
	
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		//Informações Funcionário;
   
        String nomeFunc =  request.getParameter("nome_func");
		String dataFunc = request.getParameter("data_func");
		String cpfFunc= request.getParameter("cpf_func");
		String emailFunc= request.getParameter("email_func");
		String rgFunc = request.getParameter("rg_func");
		String telefoneFunc = request.getParameter("telefone_func");
		String senhaFunc = request.getParameter("senha_func");
		String sobrenomeFunc = request.getParameter("sobrenome_func");
		String sexoFunc = request.getParameter("sexo_func");
		
		Funcionario f = new Funcionario();
		f.setNome(nomeFunc);
		f.setDatan(dataFunc);
        f.setCpf(cpfFunc);
        f.setEmail(emailFunc);
        f.setRg(rgFunc);
        f.setTelefone(telefoneFunc);
        f.setSenha(senhaFunc);
        f.setSobrenome(sobrenomeFunc);
        f.setSexo(sexoFunc);
        
        
        
        try {
			AcessoDadosFuncionario.inserirFuncionario(f);
			System.out.println("Deu certo");
		} catch (SQLException e) {
			System.out.println("deu erro1");
			e.printStackTrace(); 
		} catch (Exception e) {
			System.out.println("deu erro2");
			e.printStackTrace();
		}
   
		
        
     RequestDispatcher disp;
    disp = request.getRequestDispatcher(destino);
    disp.forward(request, response);  
		*/
		
		

	}
// TESTANDO COM O MAIN 
//Esse funciona!!
public static void main (String args[]){
	
	  
	String nomeFunc= "nomefghc";
	
	String sobrenomeFunc = "sobrenomfgh";

	String data= "03/21/2004";
	
	String email = "sobrenomfgh@hotmail.com";
	String cpf= "07638202619";
	
	String rg = "1234567891";
	String telefone= "02126280625";
	
	String senha = "123456";

	String sexo= "n";
	
	Funcionario f = new Funcionario();
	f.setNome(nomeFunc);
    f.setSobrenome(sobrenomeFunc);
    f.setDatan(data);
    f.setEmail(email);
    f.setCpf(cpf);
    f.setRg(rg);
    f.setSexo(sexo);
    f.setTelefone(telefone);
    f.setSenha(senha);

    
		
				try {
					AcessoDados.inserirFuncionario(f);
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
	

		
		
			
	
}
}

Exeções


18/10/2006 12:47:51 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Arquivos de programas\Java\jre1.5.0_07\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
18/10/2006 12:47:51 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
18/10/2006 12:47:51 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 921 ms
18/10/2006 12:47:51 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
18/10/2006 12:47:51 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.17
18/10/2006 12:47:51 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
18/10/2006 12:47:52 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
18/10/2006 12:47:53 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
18/10/2006 12:47:53 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/157  config=null
18/10/2006 12:47:53 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
18/10/2006 12:47:53 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1547 ms
passou aki
deu erro1
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:118)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2104)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2054)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478)
	at org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:194)
	at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1107)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1145)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:116)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
passou aki
deu erro1
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:118)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2104)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2054)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478)
	at org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:194)
	at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1107)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1145)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:116)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
passou aki
deu erro1
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:118)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2104)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2054)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478)
	at org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:194)
	at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1107)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1145)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:116)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
passou aki
deu erro1
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:118)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2104)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2054)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478)
	at org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:194)
	at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1107)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1145)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:116)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
passou aki
deu erro1
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:118)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -804
Count of read-write columns does not equal count of values
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2104)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2054)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478)
	at org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:194)
	at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1107)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1145)
	at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:116)
	at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
	at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:286)
	at br.com.estacio.faculdade.base.AcessoDadosFuncionario.inserirFuncionario(AcessoDadosFuncionario.java:249)
	at br.com.estacio.faculdade.dominios.CadastroFuncionario.doPost(CadastroFuncionario.java:71)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)

Grato Reis

fcoury · Outubro 18, 2006, 2:39pm

Cara,

Que bizarro!!!

Faz um favor, coloca esse debug:

System.out.println("nomeFunc: " + nomeFunc);
System.out.println("dataFunc: " + dataFunc);
System.out.println("cpfFunc: " + cpfFunc);
System.out.println("emailFunc: " + emailFunc);
System.out.println("rgFunc: " + rgFunc);
System.out.println("telefoneFunc: " + telefoneFunc);
System.out.println("senhaFunc: " + senhaFunc);
System.out.println("sobrenomeFunc: " + sobrenomeFunc);
System.out.println("sexoFunc: " + sexoFunc);

… no doPost, depois que você atribui todas as variáveis

e esse:

System.out.println("f.getNome(): " + f.getNome());
System.out.println("f.getSobrenome(): " + f.getSobrenome());
System.out.println("f.getDatan(): " + f.getDatan());
System.out.println("f.getRg(): " + f.getRg());
System.out.println("f.getCpf(): " + f.getCpf());
System.out.println("f.getSexo(): " + f.getSexo());
System.out.println("f.getTelefone(): " + f.getTelefone());
System.out.println("f.getSenha(): " + f.getSenha());
System.out.println("f.getEmail(): " + f.getEmail());

… no inserirFuncionários (pode ser antes de tudo nesse método) e me posta o que ele imprime quando você manda pela web… To achando que o problema pode ser na forma que vc tá pegando os parametros…

Vamos ver…

felipereisbr · Outubro 18, 2006, 3:03pm

Olá meu caro, consegui descobrir o erro, graças ao debug !!!

Era um erro bobo, mas que as vezes passa sem a gente perceber !!


package br.com.estacio.faculdade.dominios;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.sun.org.apache.xalan.internal.xsltc.runtime.Hashtable;

import br.com.estacio.faculdade.base.AcessoDados;
import br.com.estacio.faculdade.base.AcessoDadosFuncionario;
import br.com.estacio.faculdade.base.Endereco;
import br.com.estacio.faculdade.base.Funcionario;
import br.com.estacio.faculdade.base.Pessoa;

 public class CadastroFuncionario extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
    
	public CadastroFuncionario() {
		super();
	}   	
	
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		//Informações Funcionário;
   
        String nomeFunc =  request.getParameter("nome_func");
		String dataFunc = request.getParameter("data_func");
		String cpfFunc= request.getParameter("cpf_func");
		String emailFunc= request.getParameter("email_func");
		String rgFunc = request.getParameter("rg_func");
		String telefoneFunc = request.getParameter("telefone_func");
		String senhaFunc = request.getParameter("senha_func");
		String sobrenomeFunc = request.getParameter("sobrenome_func");
		String sexoFunc = request.getParameter("sexo_func");
		
		Funcionario f = new Funcionario();
		f.setNome(nomeFunc);
		f.setDatan(dataFunc);
        f.setCpf(cpfFunc);
        f.setEmail(emailFunc);
        f.setRg(rgFunc);
        f.setTelefone(telefoneFunc);
        f.setSenha(senhaFunc);
        f.setSobrenome(sobrenomeFunc);
        f.setSexo(sexoFunc);
        
        System.out.println("nomeFunc: " + nomeFunc);
        System.out.println("dataFunc: " + dataFunc);
        System.out.println("cpfFunc: " + cpfFunc);
        System.out.println("emailFunc: " + emailFunc);
        System.out.println("rgFunc: " + rgFunc);
        System.out.println("telefoneFunc: " + telefoneFunc);
        System.out.println("senhaFunc: " + senhaFunc);
        System.out.println("sobrenomeFunc: " + sobrenomeFunc);
        System.out.println("sexoFunc: " + sexoFunc);

        //Endereço Funcionário;
        /*String logradouroFunc= request.getParameter("logradouro_func");
        String bairroFunc= request.getParameter("bairro_func");
        String cepFunc= request.getParameter("cep_func");
        String cidadeFunc= request.getParameter("cidade_func");
        String ufFunc= request.getParameter("uf_func");
        String complementoFunc= request.getParameter("complemento_func");
        String numFunc= request.getParameter("num_func");
        Endereco e = new Endereco();
        e.setLogradouro(logradouroFunc);
        e.setBairro(bairroFunc);
        e.setCep(cepFunc);
        e.setCidade(cidadeFunc);
        e.setUf(ufFunc);
        e.setComplemento(complementoFunc);
        e.setNumero(Integer.parseInt(numFunc));*/
        
        try {
			AcessoDados.inserirFuncionario(f);
			System.out.println("Deu certo");
		} catch (SQLException e) {
			System.out.println("deu erro1");
			e.printStackTrace(); 
		} catch (Exception e) {
			System.out.println("deu erro2");
			e.printStackTrace();
		}
   
		/*
		String destino;
		if (quant == 0){
			destino = "PaginaErro.jsp";
		}
		else {
			destino = "loginsucess.jsp";
		}
        
        
     RequestDispatcher disp;
    disp = request.getRequestDispatcher(destino);
    disp.forward(request, response);  
		*/
		
		

	}
// TESTANDO COM O MAIN 
public static void main (String args[]){
	
	  
	String nomeFunc= "nomefghc";
	
	String sobrenomeFunc = "sobrenomfgh";

	String data= "03/21/2004";
	
	String email = "sobrenomfgh@hotmail.com";
	String cpf= "07638202619";
	
	String rg = "1234567891";
	String telefone= "02126280625";
	
	String senha = "123456";

	String sexo= "n";
	
	Funcionario f = new Funcionario();
	f.setNome(nomeFunc);
    f.setSobrenome(sobrenomeFunc);
    f.setDatan(data);
    f.setEmail(email);
    f.setCpf(cpf);
    f.setRg(rg);
    f.setSexo(sexo);
    f.setTelefone(telefone);
    f.setSenha(senha);

    
		
				[b]try {
					AcessoDados.inserirFuncionario(f);
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}[/b]	

		
		
			
	
}
}

A minha classe de acesso ao banco se chama AcessoDados, mas como andei fazendo outra para teste que se Chamava AcessoDadosFuncionario, ficou com esse nome lá

		[b]try {
					AcessoDados.inserirFuncionario(f);
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}[/b]

Agora mudei para AcessosDados e rodou direitinho!

Bem, depois de tudo deu certinho !!

Obrigado mesmo pela força amigo !!!
Qualquercoisa estamos sempre por aqui !!!

Abraços Reis

fcoury · Outubro 18, 2006, 3:19pm

De nada cara, se precisar também estamos aí… O importante é que deu certo!

system · Dezembro 29, 2015, 4:43pm

JSP + Servlet + Firebird 1.5

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI