Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- run:
- 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 ».
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2826)
- at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1829)
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2391)
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2042)
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1889)
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1120)
- at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:700)
- at java.sql.DriverManager.getConnection(DriverManager.java:664)
- at java.sql.DriverManager.getConnection(DriverManager.java:270)
- at connectbd.ConnectBD.main(ConnectBD.java:41)
- 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
- at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:786)
- at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:836)
- at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:829)
- at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:999)
- at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:989)
- at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
- at sun.security.ssl.InputRecord.read(InputRecord.java:503)
- at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:983)
- at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385)
- at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413)
- at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397)
- at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1756)
- ... 8 more
- BUILD SUCCESSFUL (total time: 3 seconds)
- package connectbd;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.PreparedStatement;
- /**
- *
- * @author blaid
- */
- public class ConnectBD {
- /**
- * @param args the command line arguments
- */
- public static void main(String[] args) {
- // TODO code application logic here
- String Server="SQLSERVER";
- int port = 1433;
- String user = "SIBD_admin_gr15";
- String password = "aPassword123";
- String database = "LP_SIBD_GR15";
- String Instance = "SQLE";
- String jdbcurl;
- Connection con = null;
- try {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- }
- jdbcurl = "jdbc:sqlserver://" + Server + ";instanceName="+Instance+";user=" + user + ";password=" + password + "; databasename=" + database + "";
- try {
- con=DriverManager.getConnection(jdbcurl);
- System.out.println("Connection success");
- } catch(SQLException e) {
- e.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment