I am getting the following exception while executing a select query from

an oracle table view .

There is no complex mapping.

All the columns of the table are mapped correctly to a simple pojo object


The query i am trying to execute is a select query but i can see an sql

update query generated by hibernate printed in the console.

Its trying to update the view and end up in the following exception .

can anyone suggest a solution to this problem.




[java] 2006-10-09 23:17:43,220 1828129 [ExecuteThread: '14' for queue: 'def
ault'] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1031, SQLSta
te: 42000
[java] 2006-10-09 23:17:43,220 1828129 [ExecuteThread: '14' for queue: 'def
ault'] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01031: insufficient
privileges

[java] 2006-10-09 23:17:43,220 1828129 [ExecuteThread: '14' for queue: 'def
ault'] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1031, SQLSta
te: 42000
[java] 2006-10-09 23:17:43,220 1828129 [ExecuteThread: '14' for queue: 'def
ault'] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01031: insufficient
privileges

[java] 2006-10-09 23:17:43,220 1828129 [ExecuteThread: '14' for queue: 'def
ault'] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
[java] org.hibernate.exception.SQLGrammarException: could not update: [com.
schwab.sps.domain.ReportVO#17]
[java] at org.hibernate.exception.SQLStateConverter.convert(Ljava.sql.S
QLException;Ljava.lang.String;Ljava.lang.String;)Lorg.hibernate.JDBCException;(S
QLStateConverter.java:67)
[java] at org.hibernate.exception.JDBCExceptionHelper.convert(Lorg.hibe
rnate.exception.SQLExceptionConverter;Ljava.sql.SQLException;Ljava.lang.String;L
java.lang.String;)Lorg.hibernate.JDBCException;(JDBCExceptionHelper.java:43)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.update
(Ljava.io.Serializable;[Ljava.lang.Object;[Ljava.lang.Object;Ljava.lang.Object;[
ZILjava.lang.Object;Ljava.lang.Object;Ljava.lang.String;Lorg.hibernate.engine.Se
ssionImplementor;)Z(AbstractEntityPersister.java:2222)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.update
OrInsert(Ljava.io.Serializable;[Ljava.lang.Object;[Ljava.lang.Object;Ljava.lang.
Object;[ZILjava.lang.Object;Ljava.lang.Object;Ljava.lang.String;Lorg.hibernate.e
ngine.SessionImplementor;)V(AbstractEntityPersister.java:2118)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.update
(Ljava.io.Serializable;[Ljava.lang.Object;[IZ[Ljava.lang.Object;Ljava.lang.Objec
t;Ljava.lang.Object;Ljava.lang.Object;Lorg.hibernate.engine.SessionImplementor;)
V(AbstractEntityPersister.java:2374)
[java] at org.hibernate.action.EntityUpdateAction.execute()V(EntityUpda
teAction.java:91)
[java] at org.hibernate.engine.ActionQueue.execute(Lorg.hibernate.actio
n.Executable;)V(ActionQueue.java:248)
[java] at org.hibernate.engine.ActionQueue.executeActions(Ljava.util.Li
st;)V(ActionQueue.java:232)
[java] at org.hibernate.engine.ActionQueue.executeActions()V(ActionQueu
e.java:140)
[java] at org.hibernate.event.def.AbstractFlushingEventListener.perform
Executions(Lorg.hibernate.event.EventSource;)V(AbstractFlushingEventListener.jav
a:297)
[java] at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoF
lush(Lorg.hibernate.event.AutoFlushEvent;)V(DefaultAutoFlushEventListener.java:4
1)
[java] at org.hibernate.impl.SessionImpl.autoFlushIfRequired(Ljava.util
.Set;)Z(SessionImpl.java:954)
[java] at org.hibernate.impl.SessionImpl.list(Ljava.lang.String;Lorg.hi
bernate.engine.QueryParameters;)Ljava.util.List;(SessionImpl.java:1099)
[java] at org.hibernate.impl.QueryImpl.list()Ljava.util.List;(QueryImpl
.java:79)