I have need to pass the username of the person logged into my application to the database. The only way that I can see to really accomplish this is to call a stored procedure immediately after obtaining a pooled connection and calling it again when the connection is released to clear the name.
I would need to modify Torque to call my "handler" class after the connection is obtained from the pool but before it is returned from Torque.getConnection(). The problem is how does the code in my handler class obtain a reference to the current TurbineUser for the thread??? I have been thinking about using java.lang.ThreadLocal inside of my handler class to store the current user. I would set the user inside of the session validator. Has anyone else implemented anything like this? Any thoughts on how I am thinking about implementing it? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
