Start a new topic

add support for oracle proxy users

[This topic is migrated from our old forums. The original author name has been removed]

Hi, jdbc does support it, dbvis not (that I could find). In sqlplus we can connect with username[proxyuser_name]. A similar syntax would be very welcome. a nice example for a java connection is here: best regards, Ronald http://ronr.blogspot.com

[This reply is migrated from our old forums.]

Re: add support for oracle proxy users
Hi Ronald, Based on the Java article you refer to I think you can already connect using a proxy user? Have you tried using the URL as in their example along by setting some driver properties? Best Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: add support for oracle proxy users
Hi Roger, using sqlplus I can, using dbvis, I can't. It would be nice if this could be done. What I tried is: jdbc:oracle:thin:{pool_user}/@{host}:{port}:{ORACLE_SID} and this results in An error occurred while establishing the connection: Long Message: unsupported verifier type Details:    Type: java.sql.SQLException    Error Code: 17451    SQL State: 99999 private void proxyConnection() throws Exception { 02 Properties properties = new Properties(); 03 properties.put("PROXY_USER_NAME", "pu_user_1"); 04 05 OracleConnection conn = (OracleConnection) DriverManager.getConnection( 06 "jdbc:oracle:thin:pu_pool_user/pu_pool_user@localhost:1521:ora1012", 07 properties); 08 conn.openProxySession(OracleConnection.PROXYTYPE_USER_NAME, properties); I fail to see how I can make dbvis open the ProxySession by tweeking the driver properties. If you have a pointer, I will be more than happy to try that. best regards, Ronald.
[This reply is migrated from our old forums.]

Re: add support for oracle proxy users
Ronald, Sorry I missed the Oracle specific driver call which means we need to add support in DbVisualizer. I'll register a ticket for this. Best Regards Roger