<div dir="ltr">Hi<div><br></div><div>I am trying to connect midpoint to an Oracle database and followed the instructions at </div><div><a href="https://wiki.evolveum.com/display/midPoint/Oracle+11g">https://wiki.evolveum.com/display/midPoint/Oracle+11g</a> and </div><div><a href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration">https://wiki.evolveum.com/display/midPoint/Repository+Configuration</a></div><div>I also ran the SQL script to create the tables manually in my DB. However, I am getting an error as below. Any help or feedback will be very helpful..</div><div><br></div><div><div>org.hibernate.exception.SQLGrammarException: could not execute batch</div><div>        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:136) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:114) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:163) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:226) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:95) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3108) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div><div>        at com.evolveum.midpoint.repo.sql.helpers.ObjectUpdater.addObjectAttempt(ObjectUpdater.java:135) ~[repo-sql-impl-3.5.jar:na]</div><div>        at com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.addObject(SqlRepositoryServiceImpl.java:376) [repo-sql-impl-3.5.jar:na]</div><div>        at com.evolveum.midpoint.task.quartzimpl.cluster.NodeRegistrar.createNodeObject(NodeRegistrar.java:104) [task-quartz-impl-3.5.jar:na]</div><div>        at com.evolveum.midpoint.task.quartzimpl.cluster.ClusterManager.createNodeObject(ClusterManager.java:110) [task-quartz-impl-3.5.jar:na]</div><div>        at com.evolveum.midpoint.task.quartzimpl.Initializer.init(Initializer.java:90) [task-quartz-impl-3.5.jar:na]</div><div>        at com.evolveum.midpoint.task.quartzimpl.TaskManagerQuartzImpl.init(TaskManagerQuartzImpl.java:206) [task-quartz-impl-3.5.jar:na]</div></div><div>........</div><div><div><div>Caused by: java.sql.BatchUpdateException: ORA-01950: no privileges on tablespace 'USERS'</div><div><br></div><div>        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296) ~[oracle.jar:11.2.0.2.0]</div><div>        at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216) ~[oracle.jar:11.2.0.2.0]</div><div>        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135) ~[c3p0-0.9.2.1.jar:0.9.2.1]</div><div>        at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:127) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]</div></div><div><br></div>-- Thanks<br><div class="gmail_signature"><div dir="ltr">Sowmya Shankar<div>Applications Programmer</div><div>IT- Web Development</div><div><br></div></div></div>
</div></div>