The problem is, in your connection method
ds.getConnection("user", "pass")
This is actually creates a different pooling criteria (PoolByCri) than the one
configured in the datasource (OnePool). So, you have 2 choices.
1) Use the username/password provided in your *-ds.xml file to aquire a
connection. In that case, the code would become:
getConnection();
2)If you truly want to allow multiple users for the connection, add the
following to your *-ds.xml file
<application-managed-security/>
This will tie each connection created via the ds.getConnection("user","pass")
to a particular pool. Note, that a sub pool is created 'per user'. So, if you
have n users, you have n sub pools.
More can be found here:
http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigJCACommon
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3944408#3944408
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3944408
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
