SSL with Oracle thin driver - what would be the JDBC URL for creating a connection?JDBC connect to Oracle database with SSLJava JDBC unable to connect to a Oracle database with SSLConnecting to SSL-enabled Oracle DB through Java (JDBC)Creating an ssl connection to oracle db with JavaNLS_LANG setting for JDBC thin driver?How to use SSL with Oracle thin driver?Oracle read-only JDBC connectionConfiguring SSL connection for Oracle 12JDBC Connection Error to Oracle DatabaseOracle JDBC thin driver SSLtcps oracle tomcat thin driver not workinghow do I give the TLS1.2 parameter in the Oracle jdbc thin connection urlWhat kind of failover is used by jdbc oracle thin driver when multiple hosts provided
How to train a replacement without them knowing?
Spongy green glass found on graves
Which basis does the wavefunction collapse to?
May the tower use the runway while an emergency aircraft is inbound?
Radix2 Fast Fourier Transform implemented in C++
Adding things to bunches of things vs multiplication
Airline power sockets shut down when I plug my computer in. How can I avoid that?
Why do balloons get cold when they deflate?
Quick destruction of a helium filled airship?
Are there any rules on how characters go from 0th to 1st level in a class?
Subgroup generated by a subgroup and a conjugate of it
Will some rockets really collapse under their own weight?
How to render "have ideas above his station" into German
global variant of csname…endcsname
C++ Least cost swapping 2
Do I need to start off my book by describing the character's "normal world"?
Rotate List by K places
Why is the battery jumpered to a resistor in this schematic?
Number of matrices with bounded products of rows and columns
Check disk usage of files returned with spaces
What's a good pattern to calculate a variable only when it is used the first time?
My new Acer Aspire 7 doesn't have a Legacy Boot option, what can I do to get it?
Are unaudited server logs admissible in a court of law?
Vegetarian dishes on Russian trains (European part)
SSL with Oracle thin driver - what would be the JDBC URL for creating a connection?
JDBC connect to Oracle database with SSLJava JDBC unable to connect to a Oracle database with SSLConnecting to SSL-enabled Oracle DB through Java (JDBC)Creating an ssl connection to oracle db with JavaNLS_LANG setting for JDBC thin driver?How to use SSL with Oracle thin driver?Oracle read-only JDBC connectionConfiguring SSL connection for Oracle 12JDBC Connection Error to Oracle DatabaseOracle JDBC thin driver SSLtcps oracle tomcat thin driver not workinghow do I give the TLS1.2 parameter in the Oracle jdbc thin connection urlWhat kind of failover is used by jdbc oracle thin driver when multiple hosts provided
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
We are trying to connect to Oracle using Oracle thin driver with SSL.
We are able to connect to Oracle using thin driver using following connect string to connect without SSL - jdbc:oracle:thin:@<host>:<port>:<service_name>.
Can anyone help with the connect string if we want to use SSL encryption?
What would be the parameters to be given in JDBC URL to make a connection?
Any help would be appreciated.
oracle jdbc driver thin
edited Mar 27 at 7:57
tomerpacific
1,5811 gold badge10 silver badges26 bronze badges
asked Mar 27 at 6:58
Divya GargDivya Garg
11 bronze badge
add a comment |
We are trying to connect to Oracle using Oracle thin driver with SSL.
We are able to connect to Oracle using thin driver using following connect string to connect without SSL - jdbc:oracle:thin:@<host>:<port>:<service_name>.
Can anyone help with the connect string if we want to use SSL encryption?
What would be the parameters to be given in JDBC URL to make a connection?
Any help would be appreciated.
oracle jdbc driver thin
edited Mar 27 at 7:57
tomerpacific
1,5811 gold badge10 silver badges26 bronze badges
asked Mar 27 at 6:58
Divya GargDivya Garg
11 bronze badge
docs.oracle.com/database/121/JJDBC/clntsec.htm#JJDBC28339
– a_horse_with_no_name
Mar 27 at 7:00
add a comment |
We are trying to connect to Oracle using Oracle thin driver with SSL.
We are able to connect to Oracle using thin driver using following connect string to connect without SSL - jdbc:oracle:thin:@<host>:<port>:<service_name>.
Can anyone help with the connect string if we want to use SSL encryption?
What would be the parameters to be given in JDBC URL to make a connection?
Any help would be appreciated.
oracle jdbc driver thin
edited Mar 27 at 7:57
tomerpacific
1,5811 gold badge10 silver badges26 bronze badges
asked Mar 27 at 6:58
Divya GargDivya Garg
11 bronze badge
We are trying to connect to Oracle using Oracle thin driver with SSL.
We are able to connect to Oracle using thin driver using following connect string to connect without SSL - jdbc:oracle:thin:@<host>:<port>:<service_name>.
Can anyone help with the connect string if we want to use SSL encryption?
What would be the parameters to be given in JDBC URL to make a connection?
Any help would be appreciated.
oracle jdbc driver thin
oracle jdbc driver thin
edited Mar 27 at 7:57
tomerpacific
1,5811 gold badge10 silver badges26 bronze badges
asked Mar 27 at 6:58
Divya GargDivya Garg
11 bronze badge
edited Mar 27 at 7:57
tomerpacific
1,5811 gold badge10 silver badges26 bronze badges
asked Mar 27 at 6:58
Divya GargDivya Garg
11 bronze badge
edited Mar 27 at 7:57
tomerpacific
1,5811 gold badge10 silver badges26 bronze badges
edited Mar 27 at 7:57
tomerpacific
1,5811 gold badge10 silver badges26 bronze badges
edited Mar 27 at 7:57
tomerpacific
1,5811 gold badge10 silver badges26 bronze badges
1,5811 gold badge10 silver badges26 bronze badges
asked Mar 27 at 6:58
Divya GargDivya Garg
11 bronze badge
asked Mar 27 at 6:58
Divya GargDivya Garg
11 bronze badge
asked Mar 27 at 6:58
Divya GargDivya Garg
11 bronze badge
11 bronze badge
docs.oracle.com/database/121/JJDBC/clntsec.htm#JJDBC28339
– a_horse_with_no_name
Mar 27 at 7:00
add a comment |
docs.oracle.com/database/121/JJDBC/clntsec.htm#JJDBC28339
– a_horse_with_no_name
Mar 27 at 7:00
docs.oracle.com/database/121/JJDBC/clntsec.htm#JJDBC28339
– a_horse_with_no_name
Mar 27 at 7:00
docs.oracle.com/database/121/JJDBC/clntsec.htm#JJDBC28339
– a_horse_with_no_name
Mar 27 at 7:00
add a comment |
1 Answer
1
active
oldest
votes
The only thing you add to the connect string is PROTOCOL=tcps - everything else gets set up through JSSE properties. You'll have different choices depending on whether you just want to use SSL for encryption, or whether you also want it for authentication (and if so, whether you prefer Oracle Wallets or Java Keystores).
I feel like the official SSL with Oracle JDBC Driver whitepaper is a great walkthrough (this post is basically a non-pdf version of the same info). You might also find this Oracle blog post helpful.
There's several questions on here about this topic, they have some good code examples that might be helpful: 1 2 3 4
answered Mar 27 at 13:32
kfinitykfinity
3,9771 gold badge7 silver badges14 bronze badges
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%2f55371435%2fssl-with-oracle-thin-driver-what-would-be-the-jdbc-url-for-creating-a-connecti%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
The only thing you add to the connect string is PROTOCOL=tcps - everything else gets set up through JSSE properties. You'll have different choices depending on whether you just want to use SSL for encryption, or whether you also want it for authentication (and if so, whether you prefer Oracle Wallets or Java Keystores).
I feel like the official SSL with Oracle JDBC Driver whitepaper is a great walkthrough (this post is basically a non-pdf version of the same info). You might also find this Oracle blog post helpful.
There's several questions on here about this topic, they have some good code examples that might be helpful: 1 2 3 4
answered Mar 27 at 13:32
kfinitykfinity
3,9771 gold badge7 silver badges14 bronze badges
add a comment |
The only thing you add to the connect string is PROTOCOL=tcps - everything else gets set up through JSSE properties. You'll have different choices depending on whether you just want to use SSL for encryption, or whether you also want it for authentication (and if so, whether you prefer Oracle Wallets or Java Keystores).
I feel like the official SSL with Oracle JDBC Driver whitepaper is a great walkthrough (this post is basically a non-pdf version of the same info). You might also find this Oracle blog post helpful.
There's several questions on here about this topic, they have some good code examples that might be helpful: 1 2 3 4
answered Mar 27 at 13:32
kfinitykfinity
3,9771 gold badge7 silver badges14 bronze badges
add a comment |
The only thing you add to the connect string is PROTOCOL=tcps - everything else gets set up through JSSE properties. You'll have different choices depending on whether you just want to use SSL for encryption, or whether you also want it for authentication (and if so, whether you prefer Oracle Wallets or Java Keystores).
I feel like the official SSL with Oracle JDBC Driver whitepaper is a great walkthrough (this post is basically a non-pdf version of the same info). You might also find this Oracle blog post helpful.
There's several questions on here about this topic, they have some good code examples that might be helpful: 1 2 3 4
answered Mar 27 at 13:32
kfinitykfinity
3,9771 gold badge7 silver badges14 bronze badges
The only thing you add to the connect string is PROTOCOL=tcps - everything else gets set up through JSSE properties. You'll have different choices depending on whether you just want to use SSL for encryption, or whether you also want it for authentication (and if so, whether you prefer Oracle Wallets or Java Keystores).
I feel like the official SSL with Oracle JDBC Driver whitepaper is a great walkthrough (this post is basically a non-pdf version of the same info). You might also find this Oracle blog post helpful.
There's several questions on here about this topic, they have some good code examples that might be helpful: 1 2 3 4
answered Mar 27 at 13:32
kfinitykfinity
3,9771 gold badge7 silver badges14 bronze badges
answered Mar 27 at 13:32
kfinitykfinity
3,9771 gold badge7 silver badges14 bronze badges
answered Mar 27 at 13:32
kfinitykfinity
3,9771 gold badge7 silver badges14 bronze badges
answered Mar 27 at 13:32
kfinitykfinity
3,9771 gold badge7 silver badges14 bronze badges
3,9771 gold badge7 silver badges14 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
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%2f55371435%2fssl-with-oracle-thin-driver-what-would-be-the-jdbc-url-for-creating-a-connecti%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
docs.oracle.com/database/121/JJDBC/clntsec.htm#JJDBC28339
– a_horse_with_no_name
Mar 27 at 7:00