Advertisement
Guest User

Untitled

a guest
Feb 25th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.81 KB | None | 0 0
  1. Exception in thread "main" java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Falha na conexão TCP/IP com o host localhost, porta 1433. Erro: "Connection refused: connect. Verifique as propriedades da conexão. Verifique se uma instância do SQL Server está sendo executada no host e se está aceitando conexões TCP/IP na porta. Verifique se as conexões TCP na porta não foram bloqueadas por um firewall.".
  2. at br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:16)
  3. at DAO.ContatoDAO.<init>(ContatoDAO.java:16)
  4. at br.com.caelum.jdbc.teste.TestaConexao.main(TestaConexao.java:22)
  5. Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Falha na conexão TCP/IP com o host localhost, porta 1433. Erro: "Connection refused: connect. Verifique as propriedades da conexão. Verifique se uma instância do SQL Server está sendo executada no host e se está aceitando conexões TCP/IP na porta. Verifique se as conexões TCP na porta não foram bloqueadas por um firewall.".
  6. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
  7. at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
  8. at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
  9. at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
  10. at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
  11. at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
  12. at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
  13. at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
  14. at java.sql.DriverManager.getConnection(Unknown Source)
  15. at java.sql.DriverManager.getConnection(Unknown Source)
  16. at br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:14)
  17.  
  18.  
  19. ... 2 more
  20.  
  21. package br.com.caelum.jdbc;
  22.  
  23. import java.sql.Connection;
  24. import java.sql.DriverManager;
  25. import java.sql.SQLException;
  26.  
  27. public class ConnectionFactory {
  28.  
  29. private String conexao = "jdbc:sqlserver://localhost:1433;databaseName=fj21";
  30.  
  31. public Connection getConnection(){
  32.  
  33. try {
  34. return DriverManager.getConnection(conexao, "sa","");
  35. } catch (SQLException e) {
  36. throw new RuntimeException(e);
  37.  
  38. }
  39. }
  40.  
  41. package br.com.caelum.jdbc;
  42.  
  43. import java.sql.Connection;
  44. import java.sql.DriverManager;
  45. import java.sql.SQLException;
  46.  
  47. public class ConnectionFactory {
  48.  
  49. private String conexao = "jdbc:sqlserver://localhost:1433;user=sa;password=123;databaseName=fj21";
  50. //private String DRIVER ="com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
  51.  
  52. public Connection getConnection() throws SQLException{
  53.  
  54. // Class.forName(DRIVER );
  55. return DriverManager.getConnection(conexao);
  56. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement