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
/Dirección de Desarrollo/

Universidad Mariano Gálvez
3a. Av. 9-00 Zona 2 · Int. Finca El Zapote
Tel: *24111800 Ext. 1166 y 1290* · Fax: *Ext. 1166*
[email protected] <mailto:[email protected]> · www.umg.edu.gt <http://www.umg.edu.gt>



Reply via email to