Dear CF-Users,
In order to have proper auditing and for other benefits like identity
preservation we cannot just make use of a single username/password as is
traditionally required for connection pooling. There is more than one way to
handle this, but a common method that can be used to avoid this type of
problem is to make use of proxy authentication. With proxy authentication,
we can keep the advantages of connection pooling whilst at the same time we
are able to, a certain extent, identify users. In Java proxy authentication
is implemented as shown below (David Knox code):
1. Connect to middle tier using the proxy user:
OracleOCIConnectionPool ods = new OracleOCIConnectionPool();
ods.setURL("jdbc:oracle:oci:@" + tnsAlias);
ods.setUser("coldFusion");
ods.setPassword("password");
2. Connect using Proxy Authentication:
java.util.Properties userNameProp = new java.util.Properties();
userNameProp.setProperty(OracleOCIConnectionPool.PROXY_DISTINGUISHED_NAME,
"scott");
Connection conn =
ods.getProxyConnection(OracleOCIConnectionPool.PROXYTYPE_DISTINGUISHED_NAME,
userNameProp);
Basically, I would like to know, if possible, if ColdFusion natively
supports this kind of authentication.
Thanks all for your kind assistance.
Kindest Regards,
Joseph.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303723
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
