Guest User

Untitled

a guest
Dec 3rd, 2018
235
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.57 KB | None | 0 0
  1. run:
  2. com.microsoft.sqlserver.jdbc.SQLServerException: Le pilote n'a pas pu établir de connexion sécurisée au serveur SQL Server à l'aide du chiffrement SSL (Secure Sockets Layer). Erreur : « Le serveur SQL Server n'a retourné aucune réponse. La connexion a été fermée. ClientConnectionId:b41b6f9f-9c96-431a-ae4b-9066fef73be1 ».
  3. at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2826)
  4. at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1829)
  5. at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2391)
  6. at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2042)
  7. at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1889)
  8. at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1120)
  9. at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:700)
  10. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  11. at java.sql.DriverManager.getConnection(DriverManager.java:270)
  12. at connectbd.ConnectBD.main(ConnectBD.java:41)
  13. Caused by: java.io.IOException: Le serveur SQL Server n'a retourné aucune réponse. La connexion a été fermée. ClientConnectionId:b41b6f9f-9c96-431a-ae4b-9066fef73be1
  14. at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:786)
  15. at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:836)
  16. at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:829)
  17. at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:999)
  18. at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:989)
  19. at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
  20. at sun.security.ssl.InputRecord.read(InputRecord.java:503)
  21. at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:983)
  22. at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385)
  23. at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413)
  24. at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397)
  25. at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1756)
  26. ... 8 more
  27. BUILD SUCCESSFUL (total time: 3 seconds)
  28.  
  29. package connectbd;
  30. import java.sql.Connection;
  31. import java.sql.DriverManager;
  32. import java.sql.ResultSet;
  33. import java.sql.SQLException;
  34. import java.sql.Statement;
  35. import java.sql.PreparedStatement;
  36.  
  37. /**
  38. *
  39. * @author blaid
  40. */
  41. public class ConnectBD {
  42.  
  43. /**
  44. * @param args the command line arguments
  45. */
  46. public static void main(String[] args) {
  47. // TODO code application logic here
  48. String Server="SQLSERVER";
  49. int port = 1433;
  50. String user = "SIBD_admin_gr15";
  51. String password = "aPassword123";
  52. String database = "LP_SIBD_GR15";
  53. String Instance = "SQLE";
  54. String jdbcurl;
  55. Connection con = null;
  56. try {
  57. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  58. } catch (ClassNotFoundException e) {
  59. e.printStackTrace();
  60. }
  61. jdbcurl = "jdbc:sqlserver://" + Server + ";instanceName="+Instance+";user=" + user + ";password=" + password + "; databasename=" + database + "";
  62.  
  63. try {
  64. con=DriverManager.getConnection(jdbcurl);
  65. System.out.println("Connection success");
  66. } catch(SQLException e) {
  67. e.printStackTrace();
  68. }
  69.  
  70. }
  71.  
  72. }
Add Comment
Please, Sign In to add comment