Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- java.util.Properties props = new java.util.Properties();
- props.setProperty("password","mypassword");
- props.setProperty("user","myusername");
- props.put("v$session.osuser", System.getProperty("user.name").toString());
- props.put("v$session.machine", InetAddress.getLocalHost().getCanonicalHostName());
- props.put("v$session.program", "My Program Name");
- DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
- Connection conn=
- DriverManager.getConnection("jdbc:oracle:thin:@myhostname:1521:mysid", props);
- SQL>select username,osuser,program,machine
- from v$session
- where username = 'ROB';
- USERNAME OSUSER PROGRAM MACHINE
- --------- ----------- ------------------ -----------
- ROB rmerkw My Program Name machine
- dbms_application_info.set_client_info
- dbms_application_info.set_module
- dbms_application_info.set_action
- dbms_application_info.set_client_info('Client Info');
- connection.setClientInfo("OCSID.CLIENTID", "MyClientId");
Add Comment
Please, Sign In to add comment