Connect oracle cloud with ojdbc6, jdk1.7.0_80
ngoahodb opened this issue · 1 comments
I used the sample below to connect to a cloud database on Oracle Cloud. When I use ojdbc8, JDK 1.8 I am getting the response and when I switch to ojdbc6, JDK7 (jdk1.7.0_80), getting the error at OracleConnection.CONNECTION_PROPERTY_TNS_ADMIN (CONNECTION_PROPERTY_TNS_ADMIN cannot be resolved or is not a field). How can I connect to oracle cloud with ojdbc6, jdk1.7.0_80.
My app worked follow this steps:
1/ Use ojdbc7
2/ Setup JDBC Thin Driver Connection Prerequisites
3/ Run with config:
-Dcatalina.base="C:\apache-tomcat-7.0.42"
-Dcatalina.home="C:\apache-tomcat-7.0.42"
-Dwtp.deploy="C:\apache-tomcat-7.0.42\wtpwebapps"
-Djava.endorsed.dirs="C:\apache-tomcat-7.0.42\endorsed"
-Xmx2g -Xms2g -XX:MaxPermSize=128m -Djava.security.egd=file:/dev/urandom
-Doracle.net.tns_admin=C:\Wallet
-Djavax.net.ssl.trustStore=C:\Wallet\truststore.jks
-Djavax.net.ssl.trustStorePassword=your-pass
-Djavax.net.ssl.keyStore=C:\Wallet\keystore.jks
-Djavax.net.ssl.keyStorePassword=your-pass
-Doracle.net.ssl_server_dn_match=true
-Doracle.net.ssl_version=1.2
-Doracle.net.ssl_cipher_suites=(TLS_RSA_WITH_AES_256_CBC_SHA256)
-Dhttps.protocols=TLSv1.2
ref: