Spring Boot 1.3.5 with Hikari Connection Pool not able to set program name in v$session

Question

I have a JHipster spring boot ver 1.3.5 application which connects to Oracle DB using Hikari Connection Pool. I am unable to set the program in v$session which should be possible by adding below in my application YAML

hikari:
   v$session:
     program: AppName
     username: DB_USER

I have tried adding these at spring.datasource level, datasource.hikari level and datasource level.

I also looked at Hibernate 4.3.5 ignores v$session.program configuration property but that did not work as well.

Update 1 - I tried all the below and none seem to work

spring.datasource.hikari.datasourceProperties.v$session.program AppName
spring.datasource.hikari.datasourceProperties.v$session.username    DB_USER
datasource.hikari.v$session.program AppName
datasource.hikari.v$session.username    DB_USER
datasource.hikari.datasourceProperties.v$session.program    AppName
datasource.hikari.datasourceProperties.v$session.username   DB_USER
hikari.v$session.program    AppName
hikari.v$session.username   DB_USER
hikari.datasourceProperties.v$session.program   AppName
hikari.datasourceProperties.v$session.username  DB_USER

Well that property doesn't exists for Spring Boot to do Hikari configuration so that indeed will not work. I would expect something like `spring.datasource.hikari.v$session.program` on the other hand to work. Or by prefixing it with `spring.datasource.hikari.datasourceProperties`. — M. Deinum, Dec 14 '16 at 06:57
@M.Deinum I tried the above (see Update 1) and none seem to work. — Vineet Bhatia, Dec 14 '16 at 16:35
I am able to get it to work if I use HikariConfig (setDataSourceProperties) instead of Spring Boot DataSourceBuilder — Vineet Bhatia, Dec 14 '16 at 16:47

score 2 · Answer 1 · answered Dec 11 '22 at 18:01

2

In Spring Boot 2 use:

spring:
  datasource:
    hikari:
      data-source-properties:
        "[v$session.program]": AppName

answered Dec 11 '22 at 18:01

Ιναη ßαbαηιη

3,410
3
20
41

score 0 · Answer 2 · answered Mar 14 '18 at 13:25

0

Following works in Spring Boot 1.5.8.RELEASE using application.yml file:

spring:
  datasource:
    hikari:
      data-source-properties:
         v$session.program: AppName

answered Mar 14 '18 at 13:25

Karol Dowbecki

43,645
9
78
111

Thank you! Finally a solution... spent a day on this. – odedia May 07 '18 at 14:06

Spring Boot 1.3.5 with Hikari Connection Pool not able to set program name in v$session

2 Answers2

Linked