Oracle not providing osuser when there is a connection from a java program -
I am trying to connect to my remote Oracle database, and it is closed and users and a white pc The list may be linked to it, however, Oracle OSUSER is not providing when I try to connect, so I have been refused.
How do I connect here:
public static final string CONNECTION_STRING = "JDBC: Oracle: thin: @myip: port: db"; Public static final java.util.Properties CONNECTION_PROPERTIES = new java.util.Properties (); Fixed {CONNECTION_PROPERTIES.setProperty ("password", "password"); CONNECTION_PROPERTIES.setProperty ("user", "dbuser"); CONNECTION_PROPERTIES.put ("v $ session.osuser", System.getProperty ("user.name"). ToString ()); {CONNECTION_PROPERTIES.put ("v $ session.machine", try InetAddress.getLocalHost (). GetCanonicalHostName ()); } Hold (unknownHostException E) {System.out.println ("Failed to set hostname. Trying with localhost, it is unlikely to succeed."); E.printStackTrace (); CONNECTION_PROPERTIES.put ("v $ session.machine", "localhost"); } CONNECTION_PROPERTIES.put ("v $ session.program", "GDS_Reports"); } And I am creating a connection like this:
DriverManager.registerDriver (new oracle.jdbc.OracleDriver ()); Connection Conn = DriverManager.getConnection (GlobalConstants.CONNECTION_STRING, GlobalConstants.CONNECTION_PROPERTIES); But the table reports these connections:
Machine Oscars DBSER FTIM ---------------- - ---------------------- -------------------- ------ - ------------ ----------------- wn7-18tl6m1.domain dbuser 02-SEP-2011 14:46 wn7-18tl6m1.domain Dbuser 02 -SEP-2011 14:46 wn7-18tl6m1.domain dbuser 02-SEP-2011 14:46 wn7-18tl6m1.domain dbuser 02-SEP-2011 14:46 < P> There is a bug in some Oracle JDBC drivers so that OSUSER can not be set up so that you can upgrade to a new version to fix it.
Comments
Post a Comment