Sending the SQL SET command just after obtaining the database connection with the Aries transaction service

2023-08-07 Thread f...@gordijn.org
Hi,

I use the XA variant of the Aries transaction service (see 
https://aries.apache.org/documentation/modules/tx-control/index.html).
My problem is the following:

Just after the connection to the database is established (or returned from the 
pool) I need to send to the database a SQL SET command (in order to use Row 
Level Security (RLS) in the Postgres database, which then is followed by the 
normal communication.

It is not clear to me how to do this. I found that the database connection is 
requested by EnlistingDataSource (innerclass from 
JPAEntityManagerProviderFactoryImpl). But this class uses a number of private 
variables and methods which make it not possible to override them.

How can I solve this, e.g. sending a SQL SET command just after the connection 
is openen or obtained from the connection pool?

Kind regards,

-- Jaap Gordijn



Sending the SQL SET command just after obtaining the database connection with the Aries transaction service

2023-08-17 Thread f...@gordijn.org
No one?

---
Hi,

I use the XA variant of the Aries transaction service (see 
https://aries.apache.org/documentation/modules/tx-control/index.html).
My problem is the following:

Just after the connection to the database is established (or returned from the 
pool) I need to send to the database a SQL SET command (in order to use Row 
Level Security (RLS) in the Postgres database, which then is followed by the 
normal communication.

It is not clear to me how to do this. I found that the database connection is 
requested by EnlistingDataSource (innerclass from 
JPAEntityManagerProviderFactoryImpl). But this class uses a number of private 
variables and methods which make it not possible to override them.

How can I solve this, e.g. sending a SQL SET command just after the connection 
is openen or obtained from the connection pool?

Kind regards,

-- Jaap Gordijn



OAuth2 in Karaf

2023-08-20 Thread f...@gordijn.org
Hi all,

Are there any examples on how to do OAuth2 in Karaf?

Best,

-- Jaap