|Subject||Connection pool, trigger and binnacle|
I'm using Firebird 2.5 and i have a system running in this server.
I have a binnacle (bitacora) that is updated with triggers "After Update or Delete"
and everything works fine, since I use the "current_user".
But I'm developing a new web application with java EE, JSF and Glassfish, with
Glassfish i am using a connection pool, this use a user WEBGRAL for n users who connect.
Then I have the problem that all transactions are recorded update and delete
in the database with the user WEBGRAL and not the user who entered the time of loggearse
in the web application.
There a way to pass the user triggers firebird to recognize them or some other idea to solve