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

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole updated HHH-6836:
--------------------------------

    Fix Version/s:     (was: 4.0.0.Final)
                   4.0.1

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