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

[Strong Liu (JIRA)]

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.next


_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 _ at 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira