essa e classe de conexão
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
public class FabricaConexao {
private static String URL = "jdbc:sqlserver://localhost:1433;databaseName=Monitoria";
private static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String USUARIO = "denis";
private static String SENHA = "denis02";
public static Connection getConnection() throws SQLException {
try {
Class.forName(DRIVER);
System.out.println("Conectando ao Banco");
return DriverManager.getConnection(URL, USUARIO, SENHA);
} catch (ClassNotFoundException e) {
throw new SQLException(e.getMessage());
}
}
}
quando tento testala usando essa outra classe
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
public class TestConexão {
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException{
// TODO Auto-generated method stub
Connection conexao = FabricaConexao.getConnection();
try {
conexao.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
ele gera o erro
Conectando ao Banco
[color=red]Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: Failed Logon:com.microsoft.sqlserver.jdbc.SQLServerException: TCP/IP connection failed to host:localhost java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.fortBrasil.monitoria.dsaSystem.FabricaConexao.getConnection(FabricaConexao.java:29)
at com.fortBrasil.monitoria.dsaSystem.TestConexão.main(TestConexão.java:15)[/color]
será que alguem pode me ajudar!!!
Agradeço
