Advertisement
Guest User

Untitled

a guest
Jun 12th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.12 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. public class ExampleSQLJDBC {
  4.  
  5. public static void main(String[] args) {
  6.  
  7. // Setting.
  8. String connectionUrl = "jdbc:sqlserver://SERVER.database.windows.net:1433;database=DATABASE;encrypt=true;trustServerCertificate=true;";
  9. String user = "USER@SERVER";
  10. String pass = "PASSWORD";
  11.  
  12. // Declare the JDBC object.
  13. Connection conn = null;
  14.  
  15. try {
  16. // Establish the connection.
  17. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  18. conn = DriverManager.getConnection(connectionUrl, user, pass);
  19. }
  20. catch (Exception e) {
  21. e.printStackTrace();
  22. }
  23. }
  24. }
  25.  
  26. com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Broken pipe ClientConnectionId:742ba7b5-43bb-441b-8e8d-bbb9dc5fa8ce".
  27. at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2226)
  28. at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1756)
  29. at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1803)
  30. at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1454)
  31. at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1285)
  32. at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
  33. at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1131)
  34. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  35. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  36. at run.ExampleSQLJDBC.main(ExampleSQLJDBC.java:21)
  37. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  38. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  39. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  40. at java.lang.reflect.Method.invoke(Method.java:498)
  41. at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement