JBoss 4.2.3GA and Oracle 11g

[wecucho]

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 :)

[peterj]

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.

[wecucho]

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

[wecucho]

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>