具有Hikari连接池的Spring Boot 1.3.5无法在v $ session中设置程序名称 [英] Spring Boot 1.3.5 with Hikari Connection Pool not able to set program name in v$session
问题描述
我有一个JHipster spring boot ver 1.3.5应用程序,该应用程序使用Hikari Connection Pool连接到Oracle DB.我无法在v$session
中设置程序,可以通过在我的应用程序YAML中添加以下内容来实现
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
我尝试在spring.datasource级别,datasource.hikari级别和datasource级别添加这些.
I have tried adding these at spring.datasource level, datasource.hikari level and datasource level.
我还查看了 Hibernate 4.3.5忽略v $ session.program配置属性,但效果不佳.
I also looked at Hibernate 4.3.5 ignores v$session.program configuration property but that did not work as well.
更新1 -我尝试了以下所有操作,但似乎都无法正常工作
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
推荐答案
在Spring Boot 1.5.8.RELEASE中使用application.yml
文件进行以下工作:
Following works in Spring Boot 1.5.8.RELEASE using application.yml
file:
spring:
datasource:
hikari:
data-source-properties:
v$session.program: AppName
这篇关于具有Hikari连接池的Spring Boot 1.3.5无法在v $ session中设置程序名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!