解决
:在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" />


