[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:all-tabpanel ]

Steve Ebersole closed HIBERNATE-105.
------------------------------------
    Resolution: Rejected


> 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