Friday 11 November 2011

SQLDeveloper and wallet authentication - use thick and check OS_AUTHENTICATION

To use the wallet feature with SQLDeveloper -

1/get wallet working for sqlplus,
2/use jdbc oci thick,
3/no username or password,
4/check OS_AUTHENTICATION (which means username is not required and you are passed back to the jdbc oci thick).
5/use TNS->connection identifier.

Tested with 11.2.0.2 server software providing OCI.