[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
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
a
anonymous
said
about 13 years ago
[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.
Roger Bjärevall
said
about 13 years ago
[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
anonymous