Guest User

Untitled

a guest
Nov 6th, 2017
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. java.util.Properties props = new java.util.Properties();
  2. props.setProperty("password","mypassword");
  3. props.setProperty("user","myusername");
  4. props.put("v$session.osuser", System.getProperty("user.name").toString());
  5. props.put("v$session.machine", InetAddress.getLocalHost().getCanonicalHostName());
  6. props.put("v$session.program", "My Program Name");
  7. DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
  8. Connection conn=
  9. DriverManager.getConnection("jdbc:oracle:thin:@myhostname:1521:mysid", props);
  10.  
  11. SQL>select username,osuser,program,machine
  12. from v$session
  13. where username = 'ROB';
  14.  
  15. USERNAME OSUSER PROGRAM MACHINE
  16. --------- ----------- ------------------ -----------
  17. ROB rmerkw My Program Name machine
  18.  
  19. dbms_application_info.set_client_info
  20. dbms_application_info.set_module
  21. dbms_application_info.set_action
  22.  
  23. dbms_application_info.set_client_info('Client Info');
  24.  
  25. connection.setClientInfo("OCSID.CLIENTID", "MyClientId");
Add Comment
Please, Sign In to add comment