I looked at this one. Does the above post apply only for jboss 5 ?
Bcoz i found this https://community.jboss.org/thread/202092 where they specify that <application-managed-security></application-managed-security>, don't work in Jboss 7 and rather use <pool><allow-multiple-users/></pool>
which one are we supposed to use ?
and as specified in the post we are getting connection using the userid and pwd and also using the loginmodules authentication.
JBoss 7 version that we are currently using doesnt respect <pool><allow-multiple-users/></pool>. I get parsing error. I was looking at where to place
<application-managed-security></application-managed-security> but i dont see that element in the datasources xsd.
I see how its supposed to put in resource-adapter.
but i still havent figured out a way to specify it in a ds file.
When a security domain used by the data source it should use a pooling strategy that is based on the subject, i.e. for every logged in subject there will be separate pool. If not used one single pool is used and connections are shared between different users. In this case the error seems to indicate that, when you are using security domain, that strategy not being used and when it checks for already created connections the properties do not match, so it is destroying the connection.
What I do not know is if JBoss 7.1.1 supports this pooling strategy or not, I will ask in their forums.
Based on the replies from AS7 thread, you can either use AS7 nightlly, or wait for AS 7.2.
Ok. Thanks for the quick response.