Oracle 11g support

georges.goebel · **Joined:** Thu Aug 25, 2005 10:24 am **Posts:** 6

Hi,

I have installed the preview for Oracle 11g and have trouble with hibernate (JBoss AS 4.2.1).
when I deploy an J2EE application which uses the JPA (Entity beans), I get an error that hibernate cannot detect the dialect
org.hibernate.HibernateException: unknown Oracle majo version [11]
org.hibernate.dialect.DialectFactory$1.getDialectClass(DialectFactory.java:135)

I tried with both JDBC drivers 10g and 11g.

Probably only a small config change but how can I fix this ?

Thanks a lot

kajh · **Joined:** Tue Aug 16, 2005 3:44 pm **Posts:** 33

Hi!

Do you set hibernate.dialect anywhere in your hibernate config?

If not, you can try and see if that makes life better.

-Kaj :)

VampBoy · **Posted:** Thu Aug 30, 2007 1:27 pm

Yeah, looking at the source...

Code:

MAPPERS.put(
              "Oracle",
              new DatabaseDialectMapper() {
                 public String getDialectClass(int majorVersion) {
                  switch ( majorVersion ) {
                     case 8: return Oracle8iDialect.class.getName();
                     case 9: return Oracle9iDialect.class.getName();
                     case 10: return Oracle10gDialect.class.getName();
                     default: throw new HibernateException( "unknown Oracle major version [" + majorVersion + "]" );
                  }
                 }
              }
      );

They don't seem to have auto detection for 11g. You'll have to set the dialect manually in your config. You should probably be fine using the 10g Dialect.

georges.goebel · **Joined:** Thu Aug 25, 2005 10:24 am **Posts:** 6

Thanks for your reply, but I tried with the dialect 10g but I had no luck.
In fact, if I use JBoss 4.2.0, it works. Can anybody explain me what changed ? Is it a hibernate or JBoss AS problem ?

Thanks

dsm08873 · **Posted:** Tue Nov 27, 2007 3:24 pm

George,

Have you add any recent luck with 11g? Is it now working for you. I'm planning on moving to it and was just starting to look at what other people have experienced. I didn't find many posts in the forum that mentioned 11g.

Thanks,
Don

georges.goebel · **Joined:** Thu Aug 25, 2005 10:24 am **Posts:** 6

Hi,

No I had no luck. I also posted the same problem in the JBoss forum and nobody answered yet.
In my configuration, the Problem only occures in JBoss 4.2.1 and JBoss 4.2.2.
JBoss 4.2.0 works perfectly withe the same configuration files.

Georges

georges.goebel · **Joined:** Thu Aug 25, 2005 10:24 am **Posts:** 6

Hi

Watch the JIRA (5015) for a workaround.

http://jira.jboss.com/jira/browse/JBAS-5015