"Wood, Alan" wrote:
>
> Is there any way to have jBoss utilize user accounts when connecting to the
> database?
>
> For instance:
>
> User test logs into the EJB system.
> The session gets a connection from the pool
> The session mutates the connection to use the username "test" for accessing
> the database.
>
> The reason for this is that our legacy system records the person that
> created/updated the record. We'd like to maintain that through the use of
> triggers.
As far as I'm aware, DBMSes don't generally provide a way to change the
user associated with a session. Certainly JDBC doesn't expose any such
functionality. The only way to acheive this is to have a separate pool
for each user (which kind of defeats the purpose of pooling).
The J2EE connector architecture (which I'm slowly working on
implementing for JBoss) directly supports selecting pooled connections
based on the caller principal, so when this is done it should be able to
do what you want. Stay tuned.
Toby.
--
Toby Allsopp
Energy Research Lab
Peace Software International Ltd
Ph +64-9-3730400
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
