This content has been marked as final. Show 5 replies
try with ojdbc14.jar
Don't use "oracle.jdbc.driver.OracleDriver". That is
long-deprecated. Use "oracle.jdbc.OracleDriver" instead.
And don't use ojdbc14.jar. It's inappropriate for your
JVM and DBMS.
If you try with system user, It will succeed to connect. If you try with different user(whether the user exists or not) It fails with OAUTH exception. This is a very rare case.
I think we should use O3Logon protocol to authenticate the user. We should use lower version(for example: ojdbc14.jar compatible with JDK 1.5) and not the latest version, since starting with 11g release, JDBC thin driver implements O5Logon challenge-response protocol instead of O3Logon to authenticate the user.
You can also use the latest driver but you should set the connection property "oracle.jdbc.thinLogonCapability" to "o3".
Just a little bump to inform that the suggestion of setting the property "oracle.jdbc.thinLogonCapability" to "o3" seemed to have worked for me. I'm very happy about this, as I was also getting a "OAUTH marshaling failure"-message while running our project.
(Side note: our project is being migrated from JDeveloper 184.108.40.206 with JRE 1.3.0_02 to JDeveloper 220.127.116.11.0 with JRE 1.6.0_24)