My Requirement: 1. remove the usage of cleartext password from mysql-ds.xml 2. Use the custom password manager to retrieve the password
Given Solution by extend the SecureIdentityLoginModule: JBoss connector API�s provides SecureIdentityLoginModule to encrypt database passwords rather than using clear text passwords in the datasource configuration. I have extended this class and overridden the commit method, which will call password manager to retrieve the password.
Problem: By going thru the custom login module, 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.
I want to understand: 1. what is done by JCA when login module is used which takes !25 milliseconds. 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 in ~1 milliseconds.
Did you set min-pool-size in the *-ds.xml file? If not, try setting it to the number of simultaneous connections that you expect to have and see if that reduces the time.
0
