| Subject | Connection pool, trigger and binnacle |
|---|---|
| Author | Carlos Mazariegos |
| Post date | 2016-09-09T20:48:19Z |
Hi,
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
the problem.
Regards
--
|
Carlos Mazariegos Universidad Mariano Gálvez |