Oracle改标识符,更改Oracle JDBC瘦客户机标识符

[Identical to this answer]

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

在应用程序级别,您可以使用以下方法在v $session中设置client_info,module和action：

dbms_application_info.set_client_info

dbms_application_info.set_module

dbms_application_info.set_action