This is a simple question. This is TopLink/JBoss related and is an interesting problem. I have a data source configure called "MyDataSource" with user "A" password "B". I am noticing that the first one to connect using that data source primes the connection pooling for the datasource. So here is the problem:
If the first guy there does a DataSource.getConnection() then all subsequent calls to DataSource.getConnection("A","B") will fail even though the userid and password passed into the getConnection() are the exact same credentials defined in the mydatasource-ds.xml file. The opposite is also true, if the first one to request a connection from the DataSource does a DataSource.getConnection("A","B") then all subsequent connections using getConnection() fail.
Unfortunately, TopLink seems to want to issue getConnection(Userid, Password) so I am looking for a solution the will allow me to use both getConnection() and getConnection(userid,password) and have it use the same connection pool if userid and password matches the userid and password in the datasource configured credentials.
Is this possible. I did explore security byContainer, but with 3.2.1 could not figure out exactly what I needed to do.
Thanks
