we are using jboss 3.2.3 and an oracle database (9i).
We want users to log in on our client and use the supplied username/password to be used for the containers database connection.
The database uses the different users to execute sql statements in different schema's. Currently we have configured one user, in the oracle datasource, for the container. This user is now used for every sql statement. We want to change this to the currently logged in user and it has to be possible to have different users with different connections at the same time.
Can anyone help us with this or point us in the right direction?
Your help is greatly appreciated!
Each user should get/use its own connection pool. Try to ask this in the JCA forum.