a way to pass a value to triggers from JDBC connection.

[Former Member]

Hi,

there is a way to pass a value to triggers from JDBC connections?

i created many triggers to track changes in tables, but now i must set what user do that change, i think in a way to pass something in JDBC connection that in triggers i can use to identify the user that made that change.

any idea?

best regards.

Clóvis

[Former Member]

Hi,

why don't you use the extended_value_spec USER for this ?

Elke

[Former Member]

Hi,

because i'm using hibernate and only one user connects on database, the user i mean is the one controlled by my application.

best regards.

Clóvis