<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3354" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Hi Everybody,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>My Requirement:<BR>1. <SPAN
class=627170203-25072008>R</SPAN>emove the usage of cleartext password from
mysql-ds.xml <BR>2. Use the custom password manager to retrieve the
password</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Given Solution by extend<SPAN
class=627170203-25072008>ing</SPAN> the SecureIdentityLoginModule:<BR>JBoss
connector API’s provides SecureIdentityLoginModule to encrypt database passwords
rather than using clear text passwords in the datasource configuration.
I <SPAN class=627170203-25072008>have implemented a custom login module
by</SPAN> extend<SPAN class=627170203-25072008>ing</SPAN> this class and
overridden the commit method, which will call password manager to retrieve the
password.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Problem:<BR>By going thru the <SPAN
class=627170203-25072008>above approach of custom login module</SPAN>, JBoss JCA
takes ~25 milliseconds to return the connection. And this 25 milliseconds
doesn't count the time to call password manager. But if I don't use cleartext
password, it takes hardly 1 millisecond.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I want to understand:<BR>1. <SPAN
class=627170203-25072008>How JCA works </SPAN>when login module is used which
takes <SPAN class=627170203-25072008>~</SPAN>25 milliseconds.<SPAN
class=627170203-25072008> </SPAN><BR>2. Is there any way I can configure
JBoss JCA to verify the password only for the 1st time, and for the subsequent
calls, it just returns the connection<SPAN class=627170203-25072008> directly
from connection pool</SPAN> <SPAN class=627170203-25072008>to reduce the
time taken to </SPAN>~1 milliseconds.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=627170203-25072008>Regards</SPAN>,<BR>Priya<SPAN
class=627170203-25072008>n</SPAN>ka</FONT></FONT></DIV></FONT></DIV><P><strong><span style='font-size:10.0pt;font-family:
"Palatino Linotype","serif";color:green'> Please do not print this email unless it is absolutely necessary. </span></strong><span style='font-family:"Arial","sans-serif"'><o:p></o:p></span></p>
<p> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. </p>
<p>WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. </p>
<p>
www.wipro.com
</p>
</BODY></HTML>