IÃ‚Â´m trying to configure JBoss 4.2.2.GA to use a dedicated Oracle Connection per User. IÃ‚Â´ve tried to convince JBoss, but with no success so far.
I need this, because our DBA designed the Database (a lot of PL/SQL Code for Calculations) with Oracle Sessions. He stores there some preprocessed Data. With the normal Setup i share the Oracle Session, with the Criteria Subject, the system uses the JAAS Username and Password to connect to the database. So IÃ‚Â´m a little bit clueless at the moment.
My current Setup is JBoss 4.2.2.GA, JPA, EJB3, JSF, RichFaces.
Can anybody explain to my how to setup such a scenario ?