Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-1039

Change Hibernate dialect for Oracle 9i/10g to use Oracle9iDialect

    • Icon: Suggestion Suggestion
    • Resolution: Fixed
    • 1.5.1
    • Database
    • None
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Seems a recent hibernate upgrade may have revealed this. Seeing the following error in a customer's logs.

      2008-05-05 03:36:48,963 main WARN [org.hibernate.dialect.Oracle9Dialect] The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead
      2008-05-05 03:36:48,965 main WARN [org.hibernate.dialect.OracleDialect] The OracleDialect dialect has been deprecated; use Oracle8iDialect instead

            [CWD-1039] Change Hibernate dialect for Oracle 9i/10g to use Oracle9iDialect

            DonnaA added a comment -

            Split 9i and 10g options on installation. Existing users can change the dialect manually in the

            {CROWD_HOME}

            /crowd.cfg.xml file.

            For Oracle 10g:

            <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
            

            For Oracle9i:

            <property name="hibernate.dialect">org.hibernate.dialect.Oracle9iDialect</property>
            

            DonnaA added a comment - Split 9i and 10g options on installation. Existing users can change the dialect manually in the {CROWD_HOME} /crowd.cfg.xml file. For Oracle 10g: <property name= "hibernate.dialect" > org.hibernate.dialect.Oracle10gDialect </property> For Oracle9i: <property name= "hibernate.dialect" > org.hibernate.dialect.Oracle9iDialect </property>

            DonnaA added a comment -

            Actually, I think we may want to add an Oracle10g dialect option.

            DonnaA added a comment - Actually, I think we may want to add an Oracle10g dialect option.

              Unassigned Unassigned
              donna@atlassian.com DonnaA
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: