[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-4931) two tests in org.hibernate.test.legacy.MultiTableTest fail on Ingres

[Ray Fan (JIRA)]

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

Ray Fan updated HHH-4931:
-------------------------

    Attachment: IngresDialect.svn.diff

I've updated the base dialect and incorporated some of the previous changes.
I retested using the Ingres9Dialect.

> two tests in org.hibernate.test.legacy.MultiTableTest fail on Ingres
> --------------------------------------------------------------------
>
>                 Key: HHH-4931
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4931
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.5.0-CR-1
>         Environment: ingres 9.3
>            Reporter: Strong Liu
>            Assignee: Strong Liu
>         Attachments: IngresDialect.svn.diff
>
>
>   testMultiTable(org.hibernate.test.legacy.MultiTableTest)
>   testMultiTableGeneratedId(org.hibernate.test.legacy.MultiTableTest)
> -------------------------
> 20:37:55,892  WARN JDBCExceptionReporter:100 - SQL Error: 2925, SQLState: 5000A
> 20:37:55,893 ERROR JDBCExceptionReporter:101 - SELECT: FOR UPDATE clause found in non-updatable SELECT statement. 
>       May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more 
>       than one variable in the FROM clause, at the outermost query level.
> 20:37:55,895  INFO DefaultLoadEventListener:160 - Error performing load command
> org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1]
> 	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:132)
> 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:120)
> 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> 	at org.hibernate.loader.Loader.loadEntity(Loader.java:1921)
> 	at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)
> 	at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
> 	at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3212)
> 	at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
> 	at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
> 	at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
> 	at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403)
> 	at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155)
> 	at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
> 	at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1045)
> 	at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1036)
> 	at org.hibernate.test.legacy.MultiTableTest.testMultiTable(MultiTableTest.java:343)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:585)
> 	at junit.framework.TestCase.runTest(TestCase.java:154)
> 	at org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:125)
> 	at junit.framework.TestCase.runBare(TestCase.java:127)
> 	at org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:63)
> 	at junit.framework.TestResult$1.protect(TestResult.java:106)
> 	at junit.framework.TestResult.runProtected(TestResult.java:124)
> 	at junit.framework.TestResult.run(TestResult.java:109)
> 	at junit.framework.TestCase.run(TestCase.java:118)
> 	at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
> 	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
> 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
> 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
> 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
> Caused by: com.ingres.gcf.util.SqlEx: SELECT: FOR UPDATE clause found in non-updatable SELECT statement. 
>       May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more 
>       than one variable in the FROM clause, at the outermost query level.
> 	at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source)
> 	at com.ingres.gcf.jdbc.JdbcStmt.readError(Unknown Source)
> 	at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source)
> 	at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source)
> 	at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source)
> 	at com.ingres.gcf.jdbc.JdbcPrep.exec(Unknown Source)
> 	at com.ingres.gcf.jdbc.JdbcPrep.executeQuery(Unknown Source)
> 	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
> 	at org.hibernate.loader.Loader.getResultSet(Loader.java:1832)
> 	at org.hibernate.loader.Loader.doQuery(Loader.java:719)
> 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271)
> 	at org.hibernate.loader.Loader.loadEntity(Loader.java:1907)
> 	... 30 more

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira