[jboss-jira] [JBoss JIRA] (HIBERNATE-105) Hibernate tools on Oralce - update causes problems - table name conflicts

Steve Ebersole (JIRA) issues at jboss.org
Thu Nov 19 10:39:00 EST 2015 

    [ https://issues.jboss.org/browse/HIBERNATE-105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13130932#comment-13130932 ] 

Steve Ebersole commented on HIBERNATE-105:
------------------------------------------

This is not the correct project to report Hibernate issues under. This Jira project is for reporting issues in the integration between Hibernate and WildFly. To report issues in Hibernate, please use https://hibernate.atlassian.net. Thanks.

That said, schema tooling has never really been supported in Hibernate prior to version 5.0.  Before that schema tooling was all considered a best effort dev tool.  If you need this support, please be sure to try 5.0 and report an issue in the correct Jira if you still see a problem.  Thanks

> Hibernate tools on Oralce - update causes problems - table name conflicts
> -------------------------------------------------------------------------
>
>                 Key: HIBERNATE-105
>                 URL: https://issues.jboss.org/browse/HIBERNATE-105
>             Project: Hibernate Integration
>          Issue Type: Bug
>         Environment: [hibernatetool]  INFO [main] (Version.java:15) - Hibernate EntityManager 3.2.1.GA
> [hibernatetool]  INFO [main] (Version.java:15) - Hibernate Annotations 3.2.1.GA
> [hibernatetool]  INFO [main] (Environment.java:514) - Hibernate 3.2.4.sp1.cp03
> Oracle 10g
>            Reporter: Anders Monrad
>            Assignee: Steve Ebersole
>              Labels: hibernatetools, oracle
>
> When we try to do an update on our schema after changing something we get a ORA-01031: insufficient privileges error from Oracle (see exception at the bottom ).
> This seems to happen trying to get some metadata on the CPA.PRODUCT table.
> After investigating this, I found out that we in the Oracle database had another table in another schema called PRODUCT (AHD.PRODUCT), which is granted to public, and therefore visible to our user (CPA). 
> If I remove the public grant on this table, the update works.
> In our persistence.xml setup we have both
>          <property name="hibernate.Schema" value="CPA" />
>          <property name="hibernate.default_schema" value="CPA"/>
> And all statements printed in debug indicate that this is picked up eg. "table found: CPA.ENZYMETYPE"
> It seems that the schema in not used in all queries executed by the hibernatetool. Specifically this seems to happen when calling  DatabaseMetaData.getIndexInfo()
> [hibernatetool] DEBUG [main] (JDBCExceptionReporter.java:69) - could not get table metadata: Product [???]
> [hibernatetool] java.sql.SQLException: ORA-01031: insufficient privileges
> [hibernatetool] 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
> [hibernatetool] 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
> [hibernatetool] 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
> [hibernatetool] 	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
> [hibernatetool] 	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
> [hibernatetool] 	at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
> [hibernatetool] 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
> [hibernatetool] 	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1451)
> [hibernatetool] 	at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3271)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:130)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:35)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)
> [hibernatetool] 	at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:991)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
> [hibernatetool] 	at org.hibernate.tool.hbm2x.Hbm2DDLExporter.doStart(Hbm2DDLExporter.java:77)
> [hibernatetool] 	at org.hibernate.tool.hbm2x.AbstractExporter.start(AbstractExporter.java:95)
> [hibernatetool] 	at org.hibernate.tool.ant.ExporterTask.execute(ExporterTask.java:40)
> [hibernatetool] 	at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:186)
> [hibernatetool] 	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
> [hibernatetool] 	at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
> [hibernatetool] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [hibernatetool] 	at java.lang.reflect.Method.invoke(Method.java:585)
> [hibernatetool] 	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
> [hibernatetool] 	at org.apache.tools.ant.Task.perform(Task.java:348)
> [hibernatetool] 	at org.apache.tools.ant.Target.execute(Target.java:357)
> [hibernatetool] 	at org.apache.tools.ant.Target.performTasks(Target.java:385)
> [hibernatetool] 	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
> [hibernatetool] 	at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
> [hibernatetool] 	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
> [hibernatetool] 	at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
> [hibernatetool] 	at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
> [hibernatetool] 	at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
> [hibernatetool] 	at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
> [hibernatetool]  WARN [main] (JDBCExceptionReporter.java:77) - SQL Error: 1031, SQLState: 42000
> [hibernatetool] ERROR [main] (JDBCExceptionReporter.java:78) - ORA-01031: insufficient privileges
> [hibernatetool] ERROR [main] (SchemaUpdate.java:165) - could not complete schema update
> [hibernatetool] org.hibernate.exception.SQLGrammarException: could not get table metadata: Product
> [hibernatetool] 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
> [hibernatetool] 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> [hibernatetool] 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:105)
> [hibernatetool] 	at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:991)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
> [hibernatetool] 	at org.hibernate.tool.hbm2x.Hbm2DDLExporter.doStart(Hbm2DDLExporter.java:77)
> [hibernatetool] 	at org.hibernate.tool.hbm2x.AbstractExporter.start(AbstractExporter.java:95)
> [hibernatetool] 	at org.hibernate.tool.ant.ExporterTask.execute(ExporterTask.java:40)
> [hibernatetool] 	at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:186)
> [hibernatetool] 	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
> [hibernatetool] 	at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
> [hibernatetool] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [hibernatetool] 	at java.lang.reflect.Method.invoke(Method.java:585)
> [hibernatetool] 	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
> [hibernatetool] 	at org.apache.tools.ant.Task.perform(Task.java:348)
> [hibernatetool] 	at org.apache.tools.ant.Target.execute(Target.java:357)
> [hibernatetool] 	at org.apache.tools.ant.Target.performTasks(Target.java:385)
> [hibernatetool] 	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
> [hibernatetool] 	at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
> [hibernatetool] 	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
> [hibernatetool] 	at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
> [hibernatetool] 	at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
> [hibernatetool] 	at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
> [hibernatetool] 	at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
> [hibernatetool] Caused by: java.sql.SQLException: ORA-01031: insufficient privileges
> [hibernatetool] 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
> [hibernatetool] 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
> [hibernatetool] 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
> [hibernatetool] 	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
> [hibernatetool] 	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
> [hibernatetool] 	at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
> [hibernatetool] 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
> [hibernatetool] 	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1451)
> [hibernatetool] 	at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3271)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:130)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:35)
> [hibernatetool] 	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)
> [hibernatetool] 	... 21 more



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)

More information about the jboss-jira mailing list