-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 
Author Message
 Post subject: Hibernate 3.0 compability with Oracle 11g
PostPosted: Tue Feb 14, 2012 2:24 am 
Newbie

Joined: Tue Feb 14, 2012 2:15 am
Posts: 3
Hello,

Is Hibernate 3.0 compatible with Oracle 11g?
If yes could you plz tell me which dialect to use.

Regards,
kamal


Top
 Profile  
 
 Post subject: Re: Hibernate 3.0 compability with Oracle 11g
PostPosted: Tue Feb 14, 2012 3:20 am 
Expert
Expert

Joined: Tue Jun 16, 2009 3:36 am
Posts: 990
Quote:
Is Hibernate 3.0 compatible with Oracle 11g?


I believe yes (as Oracle 11g is surely backwards compatible to Oracle10g)

Quote:
If yes could you plz tell me which dialect to use.


org.hibernate.dialect.Oracle10gDialect


Top
 Profile  
 
 Post subject: Re: Hibernate 3.0 compability with Oracle 11g
PostPosted: Tue Feb 14, 2012 3:38 am 
Newbie

Joined: Tue Feb 14, 2012 2:15 am
Posts: 3
Hello,

Thanks for response.

But I see there is no org.hibernate.dialect.Oracle10gDialect in hibernate-3.0.jar. so How can this Dialect be used with hibernate-3.0.jar and Oracle 11g?

For you information, currently my application is using org.hibernate.dialect.Oracle9Dialect with hibernate-3.0.jar with Oracle 10g which is OK.

Regards,
kamal


Top
 Profile  
 
 Post subject: Re: Hibernate 3.0 compability with Oracle 11g
PostPosted: Tue Feb 14, 2012 3:46 am 
Expert
Expert

Joined: Tue Jun 16, 2009 3:36 am
Posts: 990
Quote:
But I see there is no org.hibernate.dialect.Oracle10gDialect in hibernate-3.0.jar.


Sorry, to be honest I looked into hibernate-3.6 instead to hibernate-3.0.

In your situation I first would test if

org.hibernate.dialect.Oracle9Dialect with hibernate-3.0.jar with Oracle 11g

does work.

If not, I would suggest you to migrate to a newer hibernate version.


Top
 Profile  
 
 Post subject: Re: Hibernate 3.0 compability with Oracle 11g
PostPosted: Tue Feb 14, 2012 3:56 am 
Expert
Expert

Joined: Tue Jun 16, 2009 3:36 am
Posts: 990
Alternatively you can write your own Oracle10gDialect ,
I just looked how org.hibernate.dialect.Oracle10gDialect is defined and it's quite simple (few lines):

Code:
package org.hibernate.dialect;

import org.hibernate.sql.JoinFragment;
import org.hibernate.sql.ANSIJoinFragment;


/**
* A dialect specifically for use with Oracle 10g.
* <p/>
* The main difference between this dialect and {@link Oracle9iDialect}
* is the use of "ANSI join syntax".  This dialect also retires the use
* of the <tt>oracle.jdbc.driver</tt> package in favor of
* <tt>oracle.jdbc</tt>.
*
* @author Steve Ebersole
*/
public class Oracle10gDialect extends Oracle9iDialect {

   public Oracle10gDialect() {
      super();
   }

   public JoinFragment createOuterJoinFragment() {
      return new ANSIJoinFragment();
   }
}


And classes JoinFragment and ANSIJoinFragment are already defined in hibernate3.0


Top
 Profile  
 
 Post subject: Re: Hibernate 3.0 compability with Oracle 11g
PostPosted: Tue Feb 14, 2012 9:46 am 
Newbie

Joined: Tue Feb 14, 2012 2:15 am
Posts: 3
Hi,

is it possible to use OracleDialect with Oracle11g? ,As it is given in documentation that it is compatible with any Oracle version.

Regards,
Kamal


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.