Unable to access oracle DB in java

Asked Sep 03 '18 at 11:21

Active Sep 03 '18 at 11:24

Viewed 61 times

I am trying to connect to a database using the below URL. It gives me an exception.

connectionUrl = "jdbc:oracle:thin:@HostName:1521:ORCL";

But I am able to access the database using Oracle client.

Exception it gives: ORA-28040: No matching authentication protocol

edited Sep 03 '18 at 11:24

UnlikePluto

asked Sep 03 '18 at 11:21

Pramod

3

That usually happens when you use an outdated JDBC driver against a current Oracle version. And the URL should be: `jdbc:oracle:thin:@//hostname:1521/orcl` the old SID based URL format (that you are using) should not be used any longer – Sep 03 '18 at 11:22
how can i know which driver version i need to use thanks for help – Pramod Sep 03 '18 at 11:27
`java -jar ojdbcXXXXX.jar` should display the version. – Sep 03 '18 at 11:29
it gives me Oracle 11.2.0.2.0 – Pramod Sep 03 '18 at 11:31
then which driver version i required – Pramod Sep 03 '18 at 11:32
That should work with any modern Oracle version. What is your Oracle server version? (Use `select * from v$version;` to get that) – Sep 03 '18 at 11:34
oracle version is 12.1.0 – Pramod Sep 03 '18 at 11:41
Then try the modern URL syntax that I suggested – Sep 03 '18 at 11:43
it gives same error msg – Pramod Sep 03 '18 at 11:47
maybe one of the answers of https://stackoverflow.com/q/24100117/85421 helps. Are you sure above JAR is the one being used? – user85421 Sep 03 '18 at 11:51
in order to connect to 12c database you need at least JDBC driver version 11.2.0.4. – ibre5041 Sep 03 '18 at 11:58

0 Answers0