Hello All,
Configuration:
Hibernate 3.1 , Spring1.2.5,
Server : weblogic 9.1
Db : Oracle 10g
In our project we are migrating from oracle 9i to 10g I have tested pointing the weblogic server to 10g (test env). and there is no issues noted even if the hibernate dialect is in 9i.
Even though no issues are noted, is it advisable to keep the dialect as is (1.e. 9i) or to change it. Kindly advise. Even small input could be highly valuable.
Dialect used:
Code:
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.TreeCacheProvider</prop>
</props>
</property>