[Midpoint-dev] Reg repository config with Oracle DB
Sowmya Venkateswaran
vsowmya at udel.edu
Mon Jun 12 17:37:22 CEST 2017
Thanks for your response. I understood what you mentioned from the logs,
but what I do not understand is what privileges need to be assigned for the
user. From the wiki, I thought the midpoint user only had to have 'connect'
and 'resource' privileges. Is there a document that lists all privileges
for the DB midpoint user?
On Mon, Jun 12, 2017 at 10:46 AM, ANDRES PARDO <tinpardo at gmail.com> wrote:
> The user that you are using doesn't have privileges on USERS Tablespace.
>
>
>
>
> Caused by: java.sql.BatchUpdateException: ORA-01950: no privileges on
> tablespace 'USERS'
>
>
> Mauricio Pardo Agudelo
> Public Key PGP
>
> On Mon, Jun 12, 2017 at 9:44 AM, Sowmya Venkateswaran <vsowmya at udel.edu>
> wrote:
>
>> 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.StandardSQLExceptionConvert
>> er.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.perfo
>> rmExecution(BatchingBatch.java:136) ~[hibernate-core-4.3.11.Final.
>> jar:4.3.11.Final]
>> at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExe
>> cuteBatch(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.execu
>> teBatch(JdbcCoordinatorImpl.java:226) ~[hibernate-core-4.3.11.Final.
>> jar:4.3.11.Final]
>> at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.pre
>> pareStatement(StatementPreparerImpl.java:95)
>> ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>> t(AbstractEntityPersister.java:3108) ~[hibernate-core-4.3.11.Final.
>> jar:4.3.11.Final]
>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>> t(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.p
>> erformExecutions(AbstractFlushingEventListener.java:350)
>> ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
>> at org.hibernate.event.internal.DefaultFlushEventListener.onFlu
>> sh(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.JdbcTransacti
>> on.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.addObje
>> ctAttempt(ObjectUpdater.java:135) ~[repo-sql-impl-3.5.jar:na]
>> at com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.addO
>> bject(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(Orac
>> lePreparedStatement.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.executeBa
>> tch(NewProxyPreparedStatement.java:1135) ~[c3p0-0.9.2.1.jar:0.9.2.1]
>> at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.perfo
>> rmExecution(BatchingBatch.java:127) ~[hibernate-core-4.3.11.Final.
>> jar:4.3.11.Final]
>>
>> -- Thanks
>> Sowmya Shankar
>> Applications Programmer
>> IT- Web Development
>>
>>
>> _______________________________________________
>> midPoint-dev mailing list
>> midPoint-dev at lists.evolveum.com
>> http://lists.evolveum.com/mailman/listinfo/midpoint-dev
>>
>>
>
--
Sowmya Shankar
Applications Programmer
IT- Web Development
University of Delaware
(302)-831-4025
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.evolveum.com/pipermail/midpoint-dev/attachments/20170612/dc32247d/attachment-0001.html>
More information about the midPoint-dev
mailing list