Boa tarde pessoal, tudo bem!!
Eu tinha feito meu programinha pra conectar com o oracle, até aí funcinava tudo muito bem, mas eu queria criar código automático e no oracle eu tive que criar gatilhos e sequencias pra fazer isso, não deu muito certo, daí resolvi mudar de banco, o mysql e lá só fiz auto_increment mas na minha classe que criei pra conexão eu não sei se está certo… segue abaixo, se alguém puder me ajudar eu fico grata…
package conexao;
import java.sql.*;
public class BDConector
{
private static BDConector instance = null;
private Connection conn = null;
private String banco;
//Construtor que carrega o campo estático conn com uma conexão ao banco.
private BDConector(String tipo) throws Exception
{
banco = tipo;
/*
* Conexão com o Oracle
*
*/
if (banco.equals("oracle"))
{
try
{
Class.forName("oracle.jdbc.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521", "SYSTEM", "123456"
);
}
catch(Exception e)
{
throw new Exception(e.getMessage());
}
}
else
if (banco.equals("postgresql"))
{
{
/*
* Conexão com PostGreSQL
*
*/
try
{
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection
(
"jdbc:postgresql://localhost:5432/meubanco", "postgres", "postgres"
);
}catch(Exception e)
{
throw new Exception(e.getMessage());
}
}
}// fim do else
else
if (banco.equals("mysql"))
{
{
/*
* Conexão com MySQL
*
*/
try {
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/CSV","root","123456");
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e)
{
e.printStackTrace();
}
}// fim do else
}
}
//Método estático que será chamado pelo cliente. Ele só cria uma instância se a
//atual for nula.
public static BDConector getInstance(String tipo) throws Exception
{
if(instance == null)
{
System.out.println("Instância NOVA criada");
instance = new BDConector(tipo);
}
else
System.out.println("Instância JÁ criada");
return instance;
}
public Connection getConnection()
{
return conn;
}
public static void closeConnection(Statement stmt, ResultSet rs)
throws Exception
{
close(stmt, rs);
}
public static void closeConnection(Statement stmt)
throws Exception
{
close(stmt, null);
}
public static void close(Statement stmt, ResultSet rs)
throws Exception
{
try
{
if(rs != null)rs.close();
if(stmt != null)stmt.close();
}
catch (Exception e)
{
throw new Exception(e.getMessage());
}
}
}
O erro que dá na console é esta:
28/05/2010 10:52:49 org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:SCV' did not find a matching property.
28/05/2010 10:52:49 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based 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.6.0_07\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre6/bin/client;C:/Arquivos de programas/Java/jre6/bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Arquivos de programas\Java\jdk1.6.0_07\bin;C:\tools\maven\bin
28/05/2010 10:52:50 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8094
28/05/2010 10:52:50 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1583 ms
28/05/2010 10:52:50 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
28/05/2010 10:52:50 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
28/05/2010 10:52:51 org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(C:\Documents and Settings\Celia\Meus documentos\SCV\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\wtpwebapps\SCV\WEB-INF\lib\servlet.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
28/05/2010 10:52:54 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8094
28/05/2010 10:52:54 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8095
28/05/2010 10:52:54 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/125 config=null
28/05/2010 10:52:54 org.apache.catalina.startup.Catalina start
INFO: Server startup in 4588 ms
Instância NOVA criada
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at conexao.BDConector.<init>(BDConector.java:65)
at conexao.BDConector.getInstance(BDConector.java:86)
at servlet.ServletVeiculo.processRequest(ServletVeiculo.java:45)
at servlet.ServletVeiculo.doGet(ServletVeiculo.java:244)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
28/05/2010 10:53:34 org.apache.catalina.core.StandardContext reload
INFO: Reloading this Context has started
28/05/2010 10:53:35 org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(C:\Documents and Settings\Celia\Meus documentos\SCV\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\wtpwebapps\SCV\WEB-INF\lib\servlet.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class