Hi, Iḿ trying to figure out a way to incorporate oracleś Proxy Authentication into JBoss. Proxy Authentication is a method of connecting to the database using one user through another. This means that my application has a database user, for example - appserv, and my users each has his own database user, for example joe. With proxy authentication, I can connect from the middle tier to jo through appserv. This enables all kinds of database features, mainly security related features, such as audit, label security, etc.
Anyway, I wrote a database driver to replace the default oracle driver, and used it instead of the OracleDriver within the xxx-ds.xml file. Now everything works fine except for one little thing - JBoss always has to define a pool of connections, that the application uses to retrieve a data source. However, the proxy authentication is a pool on its own, and does not require a different pool. Not only that, but if JBoss caches (in the pool) my database connection, users might get a connection authenticated to someone else, becuase the connection is not really closed, just returned to the pool. Waht can I do? I tried setting the min and max size of the pool to 0, but in this case, instead of creating new connections for each request, I get an exception that there are no connections availble within the timeout. Can I disable the JBoss pool? please help, Thanks, Amir View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830307#3830307 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830307 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
