3 Replies Latest reply on Jan 28, 2009 3:15 PM by William Anez

    JBoss 4.2.3GA and Oracle 11g

    William Anez Newbie

      Hi, i have two enviroments for working, the devel enviroment where i have a JBoss 4.2.3 and Oracle 10g, in this enviroment i have develop an application with entities, beans, etc and all works fine, but in the producction enviroment where i have Oracle 11g, when i try to deploy my app there i get the Exception about the unsupported version (major version [11]) for this Oracle, so, i already know that the hibernate that comes with 4.2.3GA does not support this Oracle, the problem is that i don't know which jars i have to replace, version, locations, etc.

      Can anyone help me with this ? i already try with the hibernate3.jar thats comes in hibernate 3.2.4sp1 but other missing class comes in new exception, and i even know if this is helping..

      Any help will be appreciated :)

        • 1. Re: JBoss 4.2.3GA and Oracle 11g
          Peter Johnson Master

          It is difficuty to diagnose a problem without seeing the complete error message along with it's stack trace. The stack trace usually holds clues as to what was going on when the error was issued.

          My guess is that the Oracle JDBC driver you are using on the production system does not work with Oracle 11g, in which case you should get the proper driver.

          Also, where did you tell Hibernate that you are using Oracle 11? Post that config file.

          • 2. Re: JBoss 4.2.3GA and Oracle 11g
            William Anez Newbie

            For now i fixed setting the Dialect to Oracle 10g in the persistence.xml


            <?xml version="1.0" encoding="UTF-8"?>
            <persistence>
            <persistence-unit name="mimapp3">
            <jta-data-source>java:/mimapp3</jta-data-source>

            <properties>
            <property name="hibernate.hbm2ddl.auto" value="update" />
            <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>

            </properties>

            </persistence-unit>
            </persistence>


            and im using this oracle driver: ojdbc14.jar and also i upgrade the hibernate jars by downloading the lastest ones from the hibernate web site, i add the following jars to my server/default/lib directory (and also delete the oldest ones)


            antlr-2.7.6.jar
            commons-collections-3.1.jar
            dom4j-1.6.1.jar
            hibernate3.jar (3.3.1)
            hibernate-annotations.jar
            hibernate-commons-annotations.jar
            hibernate-entitymanager.jar
            javassist-3.4.GA.jar
            jta-1.1.jar
            slf4j-api-1.5.2.jar
            slf4j-jcl-1.5.2.jar


            • 3. Re: JBoss 4.2.3GA and Oracle 11g
              William Anez Newbie

              i dont know why, but the persistence don't show complete... here goes again

              <?xml version="1.0" encoding="UTF-8"?>
              <persistence>
               <persistence-unit name="mimapp3">
               <jta-data-source>java:/mimapp3</jta-data-source>
              
               <properties>
               <property name="hibernate.hbm2ddl.auto" value="update" />
               <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
               </properties>
              
               </persistence-unit>
              </persistence>