Error : ORA-01732: data manipulation operation not legal on this view #2828
Unanswered
HakanKaraoglu
asked this question in
Q&A
Replies: 1 comment
-
It might be triggered by auto flush. Most likely you have nullable columns that's are mapped to not nullable properties. It might make NHIbernate believe that your entity is dirty (for instance original loaded value is null but in entity it's stored as 0). But as your view is not updateable just set |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am running a query like below, but when I run this query with different values for the second time, I get an error.
I noticed something like this, the first query works successfully, I even see the select query, but when I run it for the second time, it goes as an update. Although the second query is a select query, it is an interesting situation, frankly I can't understand it.
Method:
Query:
SELECT this_.ID as id1_20_0_, this_.WORKSPACEID as workspaceid2_20_0_, this_.KEYWORDID as keywordid3_20_0_, this_.VARIATIONID as variationid4_20_0_, this_.SOURCEID as sourceid5_20_0_, this_.SOURCECODE as sourcecode6_20_0_, this_.LANGUAGEID as languageid7_20_0_, this_.LANGUAGECODE as languagecode8_20_0_, this_.KEYWORDTEXT as keywordtext9_20_0_, this_.VARIATIONTEXT as variationtext10_20_0_ FROM VIEWNAME this_ WHERE this_.KEYWORDID = ? and this_.SOURCECODE = ? and (this_.LANGUAGECODE = ? or this_.LANGUAGECODE is null)
UPDATE VIEWNAME SET WORKSPACEID = ?, KEYWORDID = ?, VARIATIONID = ?, SOURCEID = ?, SOURCECODE = ?, LANGUAGEID = ?, LANGUAGECODE = ?, KEYWORDTEXT = ?, VARIATIONTEXT = ? WHERE ID = ?
ORA-01732: data manipulation operation not legal on this view,
But i am not sending update query
Beta Was this translation helpful? Give feedback.
All reactions