marc fleury wrote:
>
> I am so excited that I just can't hide it!
Damn you! I hate that song and now it's stuck in my head. Aargh!
> Mr Allsopp, when do you think you will have something to show us?
Soon, soon. I haven't had a great deal of time recently, but I have some
leave shortly and I'll have nothing better to do.
So far I can read in a resource adapter, interpret the deployment
descriptor, load the classes, configure the managed connection factory
and bind the resulting connection factory into JNDI.
Missing is the interface to the transaction manager and generic
connection pooling (I think minerva will provide this).
Hopefully by then you and Rickard will have fought to the death about
the new deployment architecture so that I can just hook into it.
Toby.
>
> marc
>
> |-----Original Message-----
> |From: [EMAIL PROTECTED]
> |[mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp
> |Sent: Thursday, December 21, 2000 10:53 AM
> |To: jBoss
> |Subject: Re: [jBoss-User] Database Security
> |
> |
> |"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]
