blocks|key|1071033|text|根据supported+databases的说法，Oracle11g并未得到官方支持。不过，我相信使用org.hibernate.dialect.OracleDialect应该不会有任何问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1071034|entityMap|0|LINK|mutability|MUTABLE|url|http://community.jboss.org/wiki/SupportedDatabases^0|1F|Z|2|J|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

According to <a href="http://community.jboss.org/wiki/SupportedDatabases" rel="noreferrer">supported databases</a>, Oracle 11g is not officially supported. Although, I believe you shouldn't have any problems using <code>org.hibernate.dialect.OracleDialect</code>.

blocks|key|856622|text|使用hibernate.hbm2ddl.auto+=+validate模式的(不推荐使用的)方言org.hibernate.dialect.Oracledialect和Oracle11g数据库出现了问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|856623|使用此方言时，Hibernate无法找到序列(因为getQuerySequencesString()方法的实现返回以下查询：|856624|"select+sequence_name+from+user_sequences;"|856625|其执行从数据库返回空结果)。|856626|由于getQuerySequencesString()方法的不同实现，使用方言org.hibernate.dialect.Oracle9iDialect或更高版本可以解决此问题：|856627|"select+sequence_name+from+all_sequences++union++select+synonym_name+from+all_synonyms+us,+all_sequences+asq++where+asq.sequence_name+=+us.table_name+and+asq.sequence_owner+=+us.table_owner;"|856628|如果执行，则返回所有序列。|856629|entityMap^0|2|X|1C|Z|0|P|P|0|0|17|0|0|2|P|13|11|0|0|5B|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|14|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|15|8|@$9|16|A|17|B|C]|$9|18|A|19|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1D|8|@]|D|@]|E|$]]|$1|R|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]]|S|$]]

We had a problem with the (deprecated) dialect <code>org.hibernate.dialect.Oracledialect</code> and Oracle 11g database using <code>hibernate.hbm2ddl.auto = validate</code> mode. 

With this dialect Hibernate was unable to found the sequences (because the implementation of the <code>getQuerySequencesString()</code> method, that returns this query: 

<code>"select sequence_name from user_sequences;"</code> 

for which the execution returns an empty result from database).

Using the dialect <code>org.hibernate.dialect.Oracle9iDialect</code> , or greater, solves the problem, due to a different implementation of <code>getQuerySequencesString()</code> method: 

<code>"select sequence_name from all_sequences union select synonym_name from all_synonyms us, all_sequences asq where asq.sequence_name = us.table_name and asq.sequence_owner = us.table_owner;"</code> 

that returns all the sequences if executed, instead.

blocks|key|856671|text|如果您使用的是WL+10，请使用以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|856672|org.hibernate.dialect.Oracle10gDialect|offset|length|style|CODE|856673|entityMap^0|0|0|12|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

If you are using WL 10 use the following:

<code>org.hibernate.dialect.Oracle10gDialect</code>

blocks|key|856709|text|至少在EclipseLink+10g和11g不同的情况下。从11g开始，不建议对分页查询使用first_rows提示。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|856710|参见"Is+it+possible+to+disable+jpa+hints+per+particular+query"。这样的查询不应该在11g中使用。|offset|length|856711|SELECT+*+FROM+(
++SELECT+/*%2B+FIRST_ROWS+*/+a.*,+ROWNUM+rnum++FROM+(
++++SELECT+*+FROM+TABLES+INCLUDING+JOINS,+ORDERING,+etc.)+a
++WHERE+ROWNUM+<=+10+)
WHERE+rnum+>+0;|code-block|syntax|javascript|856712|但可能还有其他细微差别。|856713|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/36840776/is-it-possible-to-disable-jpa-hints-per-particular-query^0|0|2|1M|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

At least in case of EclipseLink 10g and 11g differ. Since 11g it is not recommended to use first_rows hint for pagination queries.

See <a href="https://stackoverflow.com/questions/36840776/is-it-possible-to-disable-jpa-hints-per-particular-query">"Is it possible to disable jpa hints per particular query"</a>. 
Such a query should not be used in 11g.

<pre><code>SELECT * FROM (
 SELECT /*+ FIRST_ROWS */ a.*, ROWNUM rnum FROM (
 SELECT * FROM TABLES INCLUDING JOINS, ORDERING, etc.) a
 WHERE ROWNUM &lt;= 10 )
WHERE rnum &gt; 0;
</code></pre>

But there can be other nuances.

blocks|key|1071216|text|仅使用org.hibernate.dialect.OracleDialect移除10g、9等。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071217|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

use only
org.hibernate.dialect.OracleDialect
Remove 10g,9 etc.

blocks|key|1071228|text|为Oracle11g数据库添加org.hibernate.dialect.OracleDialect。它将解决此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071229|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Add org.hibernate.dialect.OracleDialect for Oracle11g database.
It will resolve this error.

Is there a Hibernate dialect for Oracle Database 11g? Or should I use the <code>org.hibernate.dialect.Oracle10gDialect</code> that ships with Hibernate?

Hibernate dialect for Oracle Database 11g?

数据库

Oracle Database 11g是否有Hibernate方言？或者我应该使用Hibernate附带的org.hibernate.dialect.Oracle10gDialect？

问Oracle Database 11g的Hibernate方言？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle Database 11g的Hibernate方言？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle Database 11g的Hibernate方言？
EN