Passing user from user session in Java to Firebird Trigger using Hibernate or JDBC

Question

I have a trigger that is used to audit data modifications. I need to send a query before every JDBC call so it sends user id to Firebird. How could I use it with Hibernate?

JDBC query example:

select rdb$set_context('USER_SESSION','CURRENT_USER', ?) from rdb$database

Are you using Hibernate directly, or as a JPA implementation (or, do you use `SessionFactory` or `EntityManagerFactory`)? — Mark Rotteveel, Mar 21 '18 at 19:29

score 2 · Accepted Answer · answered Mar 22 '18 at 15:56

I know of two ways to achieve this:

Execute a native query to set the value:

EntityManager em = emf.createEntityManager();
Query contextSetQuery = em.createNativeQuery(
        "select rdb$set_context('USER_SESSION','CURRENT_USER', ?) from rdb$database");
contextSetQuery.setParameter(1, "MARK_NATIVE");
contextSetQuery.getSingleResult();

// other stuff

Getting the result is imperative, as fetching the result is what will actually set the context variable.

Unwrap to a Hibernate Session and set the client info property on the connection
```
EntityManager em = emf.createEntityManager();
Session session = em.unwrap(Session.class);
session.doWork(connection -> connection.setClientInfo("CURRENT_USER", "MARK_CLIENT_INFO"));

// other stuff
```
The Jaybird implementation of Connection.setClientInfo will do the same as the native query (and the query in your question).

Passing user from user session in Java to Firebird Trigger using Hibernate or JDBC

1 Answers1