We fix this by the connection pool configuration. <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property> <property name="hibernate.c3p0.acquire_increment">2</property> <property name="hibernate.c3p0.idle_test_period">300</property> <property name="hibernate.c3p0.timeout">1800</property> <property name="hibernate.c3p0.max_size">25</property> <property name="hibernate.c3p0.min_size" >3</property> <property name="hibernate.c3p0.max_statement">0</property> <property name="hibernate.c3p0.preferredTestQuery">ALTER SESSION SET EDITION=R2016_03_01</property> <property name="hibernate.c3p0.testConnectionOnCheckout">true</property> with test query we are setting up the oracle EBR edition version ... by doing this whenever code gets the connection it will be form the new edition. |