How do I connect SQL Server with IBM JDK 8?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
My application run on Suse Linux with IBM JDK 8.
The code is
Connection con=DriverManager.getConnection("jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName", "user", "password");
Statement sta=con.createStatement();
String sql="select * from table";
The problem is
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed
If I change the jdk from IBM to Oracle ,the application will be run .
How do I connect sqlserver with IBM JDK?
java version "1.8.0"
Java(TM) SE Runtime Environment (build pxa6480sr3fp12-20160919_01(SR3 FP12))
IBM J9 VM (build 2.8, JRE 1.8.0 Linux amd64-64 Compressed References 20160915_318796 (JIT enabled, AOT enabled)
J9VM - R28_Java8_SR3_20160915_0912_B318796
JIT - tr.r14.java.green_20160818_122998
GC - R28_Java8_SR3_20160915_0912_B318796_CMPRSS
J9CL - 20160915_318796)
JCL - 20160914_01 based on Oracle jdk8u101-b13
java ibm-jdk
asked Nov 16 '18 at 15:48
Ran JiRan Ji
61110
add a comment |
My application run on Suse Linux with IBM JDK 8.
The code is
Connection con=DriverManager.getConnection("jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName", "user", "password");
Statement sta=con.createStatement();
String sql="select * from table";
The problem is
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed
If I change the jdk from IBM to Oracle ,the application will be run .
How do I connect sqlserver with IBM JDK?
java version "1.8.0"
Java(TM) SE Runtime Environment (build pxa6480sr3fp12-20160919_01(SR3 FP12))
IBM J9 VM (build 2.8, JRE 1.8.0 Linux amd64-64 Compressed References 20160915_318796 (JIT enabled, AOT enabled)
J9VM - R28_Java8_SR3_20160915_0912_B318796
JIT - tr.r14.java.green_20160818_122998
GC - R28_Java8_SR3_20160915_0912_B318796_CMPRSS
J9CL - 20160915_318796)
JCL - 20160914_01 based on Oracle jdk8u101-b13
java ibm-jdk
asked Nov 16 '18 at 15:48
Ran JiRan Ji
61110
do you know the specific Java version of each? Maybe you could try a jvm argument such as -Dhttps.protocols
– Brandon G
Nov 16 '18 at 15:57
@BrandonG my application run on a Suse Linux OS with a IBM JDK installed, but it's not my own JVM
– Ran Ji
Nov 16 '18 at 16:01
add a comment |
My application run on Suse Linux with IBM JDK 8.
The code is
Connection con=DriverManager.getConnection("jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName", "user", "password");
Statement sta=con.createStatement();
String sql="select * from table";
The problem is
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed
If I change the jdk from IBM to Oracle ,the application will be run .
How do I connect sqlserver with IBM JDK?
java version "1.8.0"
Java(TM) SE Runtime Environment (build pxa6480sr3fp12-20160919_01(SR3 FP12))
IBM J9 VM (build 2.8, JRE 1.8.0 Linux amd64-64 Compressed References 20160915_318796 (JIT enabled, AOT enabled)
J9VM - R28_Java8_SR3_20160915_0912_B318796
JIT - tr.r14.java.green_20160818_122998
GC - R28_Java8_SR3_20160915_0912_B318796_CMPRSS
J9CL - 20160915_318796)
JCL - 20160914_01 based on Oracle jdk8u101-b13
java ibm-jdk
asked Nov 16 '18 at 15:48
Ran JiRan Ji
61110
My application run on Suse Linux with IBM JDK 8.
The code is
Connection con=DriverManager.getConnection("jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName", "user", "password");
Statement sta=con.createStatement();
String sql="select * from table";
The problem is
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed
If I change the jdk from IBM to Oracle ,the application will be run .
How do I connect sqlserver with IBM JDK?
java version "1.8.0"
Java(TM) SE Runtime Environment (build pxa6480sr3fp12-20160919_01(SR3 FP12))
IBM J9 VM (build 2.8, JRE 1.8.0 Linux amd64-64 Compressed References 20160915_318796 (JIT enabled, AOT enabled)
J9VM - R28_Java8_SR3_20160915_0912_B318796
JIT - tr.r14.java.green_20160818_122998
GC - R28_Java8_SR3_20160915_0912_B318796_CMPRSS
J9CL - 20160915_318796)
JCL - 20160914_01 based on Oracle jdk8u101-b13
java ibm-jdk
java ibm-jdk
asked Nov 16 '18 at 15:48
Ran JiRan Ji
61110
asked Nov 16 '18 at 15:48
Ran JiRan Ji
61110
edited Nov 16 '18 at 16:04
Ran Ji
asked Nov 16 '18 at 15:48
Ran JiRan Ji
61110
asked Nov 16 '18 at 15:48
Ran JiRan Ji
61110
asked Nov 16 '18 at 15:48
Ran JiRan Ji
61110
61110
do you know the specific Java version of each? Maybe you could try a jvm argument such as -Dhttps.protocols
– Brandon G
Nov 16 '18 at 15:57
@BrandonG my application run on a Suse Linux OS with a IBM JDK installed, but it's not my own JVM
– Ran Ji
Nov 16 '18 at 16:01
add a comment |
do you know the specific Java version of each? Maybe you could try a jvm argument such as -Dhttps.protocols
– Brandon G
Nov 16 '18 at 15:57
@BrandonG my application run on a Suse Linux OS with a IBM JDK installed, but it's not my own JVM
– Ran Ji
Nov 16 '18 at 16:01
do you know the specific Java version of each? Maybe you could try a jvm argument such as -Dhttps.protocols
– Brandon G
Nov 16 '18 at 15:57
do you know the specific Java version of each? Maybe you could try a jvm argument such as -Dhttps.protocols
– Brandon G
Nov 16 '18 at 15:57
@BrandonG my application run on a Suse Linux OS with a IBM JDK installed, but it's not my own JVM
– Ran Ji
Nov 16 '18 at 16:01
@BrandonG my application run on a Suse Linux OS with a IBM JDK installed, but it's not my own JVM
– Ran Ji
Nov 16 '18 at 16:01
add a comment |
1 Answer
1
active
oldest
votes
add a tls version
jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName=databasename;sslProtocol=TLSv1.2
answered Nov 18 '18 at 5:10
Ran JiRan Ji
61110
Why? How does it fix it? Why does it fix it? What was the actual problem?
– Stephen C
Nov 18 '18 at 6:42
@StephenC I am really sorry , I dont know the true reason. But it really works.Maybe the sqlserver 2014 must be connected with v1.2, but the ibm jdk use an old version default
– Ran Ji
Nov 29 '18 at 13:30
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53341211%2fhow-do-i-connect-sql-server-with-ibm-jdk-8%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
add a tls version
jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName=databasename;sslProtocol=TLSv1.2
answered Nov 18 '18 at 5:10
Ran JiRan Ji
61110
Why? How does it fix it? Why does it fix it? What was the actual problem?
– Stephen C
Nov 18 '18 at 6:42
@StephenC I am really sorry , I dont know the true reason. But it really works.Maybe the sqlserver 2014 must be connected with v1.2, but the ibm jdk use an old version default
– Ran Ji
Nov 29 '18 at 13:30
add a comment |
add a tls version
jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName=databasename;sslProtocol=TLSv1.2
answered Nov 18 '18 at 5:10
Ran JiRan Ji
61110
Why? How does it fix it? Why does it fix it? What was the actual problem?
– Stephen C
Nov 18 '18 at 6:42
@StephenC I am really sorry , I dont know the true reason. But it really works.Maybe the sqlserver 2014 must be connected with v1.2, but the ibm jdk use an old version default
– Ran Ji
Nov 29 '18 at 13:30
add a comment |
add a tls version
jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName=databasename;sslProtocol=TLSv1.2
answered Nov 18 '18 at 5:10
Ran JiRan Ji
61110
add a tls version
jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName=databasename;sslProtocol=TLSv1.2
answered Nov 18 '18 at 5:10
Ran JiRan Ji
61110
answered Nov 18 '18 at 5:10
Ran JiRan Ji
61110
answered Nov 18 '18 at 5:10
Ran JiRan Ji
61110
answered Nov 18 '18 at 5:10
Ran JiRan Ji
61110
61110
Why? How does it fix it? Why does it fix it? What was the actual problem?
– Stephen C
Nov 18 '18 at 6:42
@StephenC I am really sorry , I dont know the true reason. But it really works.Maybe the sqlserver 2014 must be connected with v1.2, but the ibm jdk use an old version default
– Ran Ji
Nov 29 '18 at 13:30
add a comment |
Why? How does it fix it? Why does it fix it? What was the actual problem?
– Stephen C
Nov 18 '18 at 6:42
@StephenC I am really sorry , I dont know the true reason. But it really works.Maybe the sqlserver 2014 must be connected with v1.2, but the ibm jdk use an old version default
– Ran Ji
Nov 29 '18 at 13:30
Why? How does it fix it? Why does it fix it? What was the actual problem?
– Stephen C
Nov 18 '18 at 6:42
Why? How does it fix it? Why does it fix it? What was the actual problem?
– Stephen C
Nov 18 '18 at 6:42
@StephenC I am really sorry , I dont know the true reason. But it really works.Maybe the sqlserver 2014 must be connected with v1.2, but the ibm jdk use an old version default
– Ran Ji
Nov 29 '18 at 13:30
@StephenC I am really sorry , I dont know the true reason. But it really works.Maybe the sqlserver 2014 must be connected with v1.2, but the ibm jdk use an old version default
– Ran Ji
Nov 29 '18 at 13:30
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53341211%2fhow-do-i-connect-sql-server-with-ibm-jdk-8%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
do you know the specific Java version of each? Maybe you could try a jvm argument such as -Dhttps.protocols
– Brandon G
Nov 16 '18 at 15:57
@BrandonG my application run on a Suse Linux OS with a IBM JDK installed, but it's not my own JVM
– Ran Ji
Nov 16 '18 at 16:01