Erro SQL

25 de outubro de 2010 9 respostas

akiles 25 de outubro de 2010

Pessoal bom dia! Como eu resolvo este erro

Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://banco
	at br.com.ecourbis.rotiva.backup.ConnectionFactery_2.getConnection2(ConnectionFactery_2.java:23)
	at br.com.ecourbis.rotiva.backup.Testacon.main(Testacon.java:14)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://banco
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at br.com.ecourbis.rotiva.backup.ConnectionFactery_2.getConnection2(ConnectionFactery_2.java:18)
	... 1 more

Tenho minha Factery assim

package br.com.ecourbis.rotiva.backup;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JOptionPane;

public class ConnectionFactery_2 {
	public static Connection getConnection2(){
		System.out.println("Conectado funcionando");
		
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//busca Driver   
	          //conecta no BD   
	          Connection con=DriverManager.getConnection("jdbc:jtds:sqlserver://banco","user","senha");   
	          PreparedStatement stmt= con.prepareStatement(null);  
			
		} catch (Exception e) {
			JOptionPane.showMessageDialog(null, "Erro ao se conectar com banco de dados");
			throw new RuntimeException(e);
		}
		return null;
		
	}
}

9 Respostas

douglastc 25 de out. de 2010

public Connection conectaBanco() throws ClassNotFoundException, SQLException{
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		String connectionUrl = "jdbc:sqlserver://nomeDoComputador;databaseName=nomeDoBanco";
		Connection con = DriverManager.getConnection(connectionUrl, "usuario", "senha");
		return con;
	}

akiles 25 de out. de 2010

Continua com erro

Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at br.com.ecourbis.rotiva.backup.ConnectionFactery_2.conectaBanco(ConnectionFactery_2.java:13) at br.com.ecourbis.rotiva.backup.Testacon.main(Testacon.java:14)

douglastc 25 de out. de 2010

Vc importou os .jar do jdbc para o Projeto?

akiles 25 de out. de 2010

Onde eu encontro o jar jdbc

douglastc 25 de out. de 2010

Procura no Google esse arquivo sqljdbc4.jar, então vc salva ele no seu projeto.

akiles 26 de out. de 2010

Coloquei o jar e continua assim

Conectado funcionando Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://banco at br.com.ecourbis.rotiva.backup.ConnectionFactery.getConnection2(ConnectionFactery.java:27) at br.com.ecourbis.rotiva.backup.Testacon.main(Testacon.java:14) Caused by: java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://EMOTTA at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at br.com.ecourbis.rotiva.backup.ConnectionFactery.getConnection2(ConnectionFactery.java:19) ... 1 more

akiles 26 de out. de 2010

Essa e minha connection

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JOptionPane;

public class ConnectionFactery_2 {
	public Connection conectaBanco() throws ClassNotFoundException, SQLException{   
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");   
        String connectionUrl = "jdbc:jtds:sqlserver://maquina;databaseName=banco";   
        Connection con = DriverManager.getConnection(connectionUrl, "usuario", "senha");   
        return con;   
	}
}

acmedis 26 de out. de 2010

Tenta dessa forma.

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://" + host + ":" + porta + ";databaseName=" + nameBase + ";integratedSecurity=false;", usuario, senha);

douglastc 26 de out. de 2010

Tenta mudar a String connectionUrl para "jdbc:sqlserver://nomeComputador;databaseName=nomeBanco";

Seu usuário e senha do banco são esses mesmos? usuario e senha?

Criado 25 de outubro de 2010

Ultima resposta 26 de out. de 2010

Respostas 9

Participantes 3

9 Respostas

Topicos relacionados