[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-6836) some test failures on Oracle

some test failures on Oracle ---------------------------- Key: HHH-6836 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6836 Project: Hibernate Core Issue Type: Bug Components: testsuite Reporter: Strong Liu Assignee: Strong Liu Priority: Minor Fix For: 4.0.0.Final _org.hibernate.test.annotations.manytoonewithformula.ManyToOneWithFormulaTest#testManyToOneFromNonPkToNonPk_ this test fails due to it has a _substring_ function in its Formula which oracle doesn't support (Oracle uses _substr_ instead) _org.hibernate.test.criteria.ComplexJoinAliasTest_ fails due to "identifier too long", moving the inner classes out. _org.hibernate.test.generatedkeys.seqidentity.SequenceIdentityTest_ this test has a _@RequiresDialect( Oracle9iDialect.class )_ on it, and it is supposed to test generated keys, but in _Oracle9iDialect_, the property Environment.USE_GET_GENERATED_KEYS is set to false by default, which causes hibernate throws _AssertionFailure_ by org.hibernate.engine.jdbc.internal.StatementPreparerImpl.checkAutoGeneratedKeysSupportEnabled() _org.hibernate.test.annotations.manytoonewithformula.ManyToOneWithFormulaTest.testManyToOneFromNonPkToNonPk_ is failed due to "ORA-00942: table or view does not exist" the ddl generated is like this {code} Unsuccessful: create table product (id number(10,0) not null, description varchar2(255 char) not null, product_idnf char(18) not null unique, primary key (id), unique (product_idnf)) ERROR SchemaExport:427 - ORA-02261: such unique or primary key already exists in the table {code} _org.hibernate.test.stateless.fetching.StatelessSessionFetchingTest.testDynamicFetch_ fails due to 'resource' is a keyword on oracle which causes create table failed.