Example of setting CLIENT_IDENTIFIER in thin JDBC?
Hi:
Can anyone provide a really simple code snippet example of how to set the CLIENT_IDENTIFIER in thin JDBC? This is needed to support application user proxy authentication in Oracle9 (where the real user is known to the middle tier but not to the database, supports connection pooling). According to the docs for 9i, this value shows up in v$session and in audit tables and views as CLIENT_ID, thus identifying the application user that an operation was performed on behalf of. The docs show an example for the OCI, but not for thin JDBC (although the docs say it's supported for thin and thick JDBC).
Before we base a design on it, I'd like to make sure it actually works. (I'm a DBA rather than a developer, so please assume I'm totally stupid about JDBC...<g>)
TIA,
Dave