[Midpoint-dev] Reg repository config with Oracle DB

[Sowmya Venkateswaran]

Hi

I am trying to connect midpoint to an Oracle database and followed the
instructions at
https://wiki.evolveum.com/display/midPoint/Oracle+11g and
https://wiki.evolveum.com/display/midPoint/Repository+Configuration
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..

org.hibernate.exception.SQLGrammarException: could not execute batch
        at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:136)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:114)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:163)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:226)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:95)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3108)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
        at
com.evolveum.midpoint.repo.sql.helpers.ObjectUpdater.addObjectAttempt(ObjectUpdater.java:135)
~[repo-sql-impl-3.5.jar:na]
        at
com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.addObject(SqlRepositoryServiceImpl.java:376)
[repo-sql-impl-3.5.jar:na]
        at
com.evolveum.midpoint.task.quartzimpl.cluster.NodeRegistrar.createNodeObject(NodeRegistrar.java:104)
[task-quartz-impl-3.5.jar:na]
        at
com.evolveum.midpoint.task.quartzimpl.cluster.ClusterManager.createNodeObject(ClusterManager.java:110)
[task-quartz-impl-3.5.jar:na]
        at
com.evolveum.midpoint.task.quartzimpl.Initializer.init(Initializer.java:90)
[task-quartz-impl-3.5.jar:na]
        at
com.evolveum.midpoint.task.quartzimpl.TaskManagerQuartzImpl.init(TaskManagerQuartzImpl.java:206)
[task-quartz-impl-3.5.jar:na]
........
Caused by: java.sql.BatchUpdateException: ORA-01950: no privileges on
tablespace 'USERS'

        at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296)
~[oracle.jar:11.2.0.2.0]
        at
oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216)
~[oracle.jar:11.2.0.2.0]
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135)
~[c3p0-0.9.2.1.jar:0.9.2.1]
        at
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:127)
~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]

-- Thanks
Sowmya Shankar
Applications Programmer
IT- Web Development
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.evolveum.com/pipermail/midpoint-dev/attachments/20170612/0516c39d/attachment.html>