[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-7159) Database keywords causes failure of some tests in org.hibernate.test.collection.custom

[Strong Liu (JIRA)]

    [ https://hibernate.onjira.com/browse/HHH-7159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=45942#comment-45942 ] 

Strong Liu commented on HHH-7159:
---------------------------------

https://issues.jboss.org/browse/JBPAPP-8393

> Database keywords causes failure of some tests in org.hibernate.test.collection.custom
> --------------------------------------------------------------------------------------
>
>                 Key: HHH-7159
>                 URL: https://hibernate.onjira.com/browse/HHH-7159
>             Project: Hibernate ORM
>          Issue Type: Bug
>          Components: testsuite
>    Affects Versions: 4.1.1
>            Reporter: Zbyněk Roubalík
>            Assignee: Strong Liu
>            Priority: Minor
>             Fix For: 4.1.2
>
>
> Keywords 'USER' and 'VALUES' are reserved on many databases.
> * *org.hibernate.test.collection.custom.basic.UserCollectionTypeAnnotationsVariantTest.testBasicOperation*
> {quote}
> org.hibernate.exception.SQLGrammarException: Incorrect syntax near the keyword 'User'.
> Stacktrace
> org.hibernate.exception.SQLGrammarException: Incorrect syntax near the keyword 'User'.
> 	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
> 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
> 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
> 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
> 	at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
> 	at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
> 	at $Proxy32.executeUpdate(Unknown Source)
> 	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)
> 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2849)
> 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3290)
> 	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
> 	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
> 	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)
> 	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:275)
> 	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
> 	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
> 	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1104)
> 	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:315)
> 	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
> 	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
> 	at org.hibernate.test.collection.custom.basic.UserCollectionTypeTest.testBasicOperation(UserCollectionTypeTest.java:55)
> {quote}
> * *org.hibernate.test.collection.custom.parameterized.ParameterizedUserCollectionTypeAnnotationsVariantTest.testBasicOperation*
> {quote}
> org.hibernate.exception.SQLGrammarException: Incorrect syntax near the keyword 'values'.
> Stacktrace
> org.hibernate.exception.SQLGrammarException: Incorrect syntax near the keyword 'values'.
> 	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
> 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
> 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
> 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
> 	at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
> 	at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
> 	at $Proxy32.executeUpdate(Unknown Source)
> 	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)
> 	at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1204)
> 	at org.hibernate.action.internal.CollectionRecreateAction.execute(CollectionRecreateAction.java:58)
> 	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
> 	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)
> 	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:279)
> 	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
> 	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
> 	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1104)
> 	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:315)
> 	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
> 	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
> 	at org.hibernate.test.collection.custom.parameterized.ParameterizedUserCollectionTypeTest.testBasicOperation(ParameterizedUserCollectionTypeTest.java:52)
> {quote}

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