tomcat_jdbc

Starting service Tomcat-Standalone

Apache Tomcat/4.0.4

Starting service Tomcat-Apache

Apache Tomcat/4.0.4

ERRO: Problemas ao adicionar nova entrada

java.sql.SQLException: [Microsoft][Driver ODBC para Microsoft Access] Tipo de da

dos imcompatÝvel na expressÒo de critÚrio.

at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)

at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)

at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3065)

at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)

at CadastroCliente.insertIntoDB(CadastroCliente.java:65)

at CadastroCliente.doPost(CadastroCliente.java:46)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:247)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:193)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:243)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline

.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav

a:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:190)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline

.java:566)

at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve

.java:246)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline

.java:564)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav

a:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:

import <a href="http://java.io">java.io</a>.<em>;

import javax.servlet.</em>;

import javax.servlet.http.<em>;

import java.util.</em>;

import java.sql.*;

public class CadastroCliente extends HttpServlet {

private Statement statement = null;

private Connection connection = null;

private String URL = “jdbc:odbc:CadastroCliente”;//ponte ODBC-JDBC

public void init( ServletConfig config )

throws ServletException

{

super.init( config );

try {
     Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
     connection =
        DriverManager.getConnection( URL, "kairos", "1234mudar" );
  }
  catch ( Exception e ) {
     e.printStackTrace();
     connection = null;
  }

public void doPost( HttpServletRequest req,

HttpServletResponse res )

throws ServletException, IOException

{

String nome,cpf,endereco,cidade,estado,telefone,email,data_nascimento;

nome = req.getParameter( “Nome” );

cpf = req.getParameter( “CPF” );

endereco = req.getParameter( “Endereco” );

cidade = req.getParameter( “Cidade” );

estado = req.getParameter( “Estado” );

telefone = req.getParameter( “Telefone” );

email = req.getParameter( “Email” );

data_nascimento = req.getParameter( “Data Nascimento” );

PrintWriter output = res.getWriter();
  res.setContentType( "text/html" );

  boolean success = insertIntoDB(
     "'"+ nome +  "','" + cpf + "','"+ endereco +
     "','"+cidade+"','"+estado+"','"+telefone
     +"','"+email+"','"+data_nascimento+ "'" );

  if ( success )
     output.print( "<H2>Obrigado  " + nome +
                   " por se cadastrar no Shopping Gospel.</H2>" );
  else
     output.print( "<H2>Um erro ocorreu. " +
                   "Por favor tente mais tarde.</H2>" );

  output.close();

private boolean insertIntoDB( String stringtoinsert )

{

try {

statement = connection.createStatement();

statement.execute(

“INSERT INTO CadastroCliente values (” + stringtoinsert + “);” );

statement.close();

}

catch ( Exception e ) {

System.err.println(

“ERRO: Problemas ao adicionar nova entrada” );

e.printStackTrace();

return false;

}

return true;

public void destroy()

{

try {

connection.close();

}

catch( Exception e ) {

System.err.println( “Problema ao fechar banco de dados” );

}

}

}