:在Google(researches)上花费了数小时后,我了解到问题出在context.xml中的连接属性中……您可以在连接池配置中的connectionProperties中设置v $ session.osuser值。像这样的’connectionProperties =“ v $ session.osuser = MyApp;”
<Resource
name="jdbc/DMDataSource"
global="jdbc/DMDataSource"
dataSourceJNDI="jdbc/DMDataSource"
auth="Container"
jmxEnabled="true"
connectionProperties="v$session.osuser=MyApp;"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="${OPENSHIFT_DM_DB_URL}"
username="${OPENSHIFT_DM_DB_USERNAME}"
password="${OPENSHIFT_DM_DB_PASSWORD}"
initialSize="5"
maxActive="50"
maxIdle="10"
maxWait="10000"
validationQuery="select 1 from dual"
validationInterval="60000"
testOnBorrow="true"
testOnReturn="false"
testWhileIdle="false"
timeBetweenEvictionRunsMillis="1200000"
minevictableIdleTimeMillis="1800000"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
/>