I have a same requirement as specified in post to pass user id as client identifier for audit purposes.
webpage
I have followed the same approach as mentioned in 8.2.Configuration of a Custom DataSource Connection Preparer
http://docs.spring.io/spring-data/jdbc/docs/current/reference/html/orcl.connection.html
Below is the piece of code which I have :
I have configured aop autoaspect proxy as shown below.
I am deploying my web service in websphere server. Everything is working fine If I configure data source using apache dbcp BasicDataSource:
Code is working fine with the above configuration. Once connection is returned, I am able to set value to client identifier and able to retrieve it from syscontext with audit trigger.
But We have actual data source configuration as shown below:
I cannot change this configuration as it is used by multiple applications and I have to follow the same. With the above configuration While deploying I am getting null pointer exception while creating data source bean. Below is the exception that I am getting:
has anyone followed this approach before. It would be helpful if some one can provide instructions on how to proceed further to to resolve this error. is there any other recommended way to follow this approach. Thanks in advance!