- This topic has 7 replies, 3 voices, and was last updated 10 years, 2 months ago by
.
-
Posts
-
Hi, using workbench 10.7. I am not able to connect jdbc:thin using SSL. Other tools allow me to connect through SSL (sqldeveloper, sqlplus, TOAD). I have added the jar files:ojdbc6,oraclepki,osdt_cert,osdt_core
I am using Java 1.7 SDK
The message I get is that the certificate is bad however, as mentioned above, I am able to connect over tcps with the other tools.Any idea’s?
spdge,
Sorry for the late response.
Can you please answer some more queries to help us investigate further :
1) Can you please share your Oracle Version and details ? Also, please mention on which OS the oracle server and client are installed ?
2) Please clear the .log file located at <Workspace dir>/.metadata/.log file, try connecting to Oracle using SSL from MyEclipse and attach the log file here to help us investigate further.
3) Please share your MyEclipse installation details from MyEclipse > Installation summary > Installation details ?@support-pradeep wrote:
spdge,
Sorry for the late response.
Can you please answer some more queries to help us investigate further :
1) Can you please share your Oracle Version and details ? Also, please mention on which OS the oracle server and client are installed ?
2) Please clear the .log file located at <Workspace dir>/.metadata/.log file, try connecting to Oracle using SSL from MyEclipse and attach the log file here to help us investigate further.
3) Please share your MyEclipse installation details from MyEclipse > Installation summary > Installation details ?spdge,
Thanks for the info, though you forgot to include the Oracle details (the version and which system it’s running on).
However, it’s proving difficult to set up a system to test here. If you can provide or point to the steps to do so, that would be useful (that is, how to enable SSL on Oracle and how to enable the client to connect with SSL). I have Oracle 11gR2 on Windows, here and followed some Oracle documentation but can’t connect with SQL Developer.
What is the URL you are using and how did you enable other tools (like SQL developer) to communicate over SSL, as I understand various system properties need to be set on the client, and possibly certificate stores and additional jar files? System properties for the IDE may be set in the myeclipse.ini file.
Is it possible for you to connect via the normal JDBC URL? I assume this is a development environment, rather than a production environment, as MyEclipse is a development tool.
@support-tony wrote:
spdge,
Thanks for the info, though you forgot to include the Oracle details (the version and which system it’s running on).
However, it’s proving difficult to set up a system to test here. If you can provide or point to the steps to do so, that would be useful (that is, how to enable SSL on Oracle and how to enable the client to connect with SSL). I have Oracle 11gR2 on Windows, here and followed some Oracle documentation but can’t connect with SQL Developer.
What is the URL you are using and how did you enable other tools (like SQL developer) to communicate over SSL, as I understand various system properties need to be set on the client, and possibly certificate stores and additional jar files? System properties for the IDE may be set in the myeclipse.ini file.
Is it possible for you to connect via the normal JDBC URL? I assume this is a development environment, rather than a production environment, as MyEclipse is a development tool.
@spdge wrote:
@support-tony wrote:
spdge,
Thanks for the info, though you forgot to include the Oracle details (the version and which system it’s running on).
However, it’s proving difficult to set up a system to test here. If you can provide or point to the steps to do so, that would be useful (that is, how to enable SSL on Oracle and how to enable the client to connect with SSL). I have Oracle 11gR2 on Windows, here and followed some Oracle documentation but can’t connect with SQL Developer.
What is the URL you are using and how did you enable other tools (like SQL developer) to communicate over SSL, as I understand various system properties need to be set on the client, and possibly certificate stores and additional jar files? System properties for the IDE may be set in the myeclipse.ini file.
Is it possible for you to connect via the normal JDBC URL? I assume this is a development environment, rather than a production environment, as MyEclipse is a development tool.
spdge,
Unfortunately, your reply is missing from your last two posts. Could you please post again?
in the meantime, I’ve managed to set up SSL connections to an Oracle database and have connected through sqlplus. However, a JDBC URL doesn’t work in SQL Developer. I assume some further configuration is needed, and I’ll look into that but an answer to my previous reply would be helpful.
spdge,
I was finally able to connect with both SQL Developer and MyEclipse 10.7.1. I’m still not sure what steps you’ve taken but after I imported the certificate authority certificate (I was using self-certification) to the cacerts file in the JRE used to run MyEclipse, I was able to connect. These seem to be the vital steps:
1. Import the certificate:
"C:\Development\MyEclipse\Location1\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\bin\keytool.exe" -importcert -alias selfie -keystore "C:\Development\MyEclipse\Location1\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\security\cacerts" -trustcacerts -file \Users\Tony\Downloads\Oracle\ca.crt2. Use a JDBC url that includes a description taken from the tnsnames.ora file:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=localhost)(PORT=2484))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = orcl)))Note that file paths and your tnsnames.ora entry will be different from those on my machine and so you will need to alter those accordingly. I have used the JDK that came with the MyEclipse installation, if you’re not sure which JDK is being used to run MyEclipse, check the -vm parameter in the myeclipse.ini file in the same folder as your myeclipse.exe file.
If the above is not relevant to your situation, please provide more details as requested earlier. otherwise, please let us know how you get on with this information.
