Databases
StackOverflow2013
Postsdbo
PONHIbernate Newbie: Can someone please explain why NHibernate attempts to execute a database update during CreateQuery execution
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONHIbernate Newbie: Can someone please explain why NHibernate attempts to execute a database update during CreateQuery execution
    primarykey
    data
    text
    <p>Basically, I wish to fetch a filtered set of objects from the database (Oracle 9.2) based on the id property of the object PsalertsEvent. The code being executed is:</p> <pre><code>Public Overloads Function GetAll(ByVal laterThan As Long, ByVal filteredPsalertsEvents As IList) As IList Implements IPsalertsEventRepo.GetAll 'Get all psalerts events with an ID greater then the specified laterThan parameter filteredPsalertsEvents = MyBase.NHibernateSession.CreateQuery("from PsalertsEvent p where p.id &gt; " &amp; laterThan).List Return filteredPsalertsEvents End Function </code></pre> <p>NUnit generates the following text ouput:</p> <p>***** PsalertsIp.Tests.Data.PSALERTSEventRepoTests.CanGetUnprocessedPsalertsEvents</p> <p>NHibernate: select max(psalertsev0_.Id) as col_0_0_ from ALARM_REPLAY_NEW psalertsev0_ NHibernate: select psalertsev0_.Id as Id0_, psalertsev0_.ALARM_SUBSTATION_NAME as ALARM2_0_, psalertsev0_.ALARM_BUSBAR_NUM as ALARM3_0_, psalertsev0_.ALARM_COMPONENT_ALIAS as ALARM4_0_, psalertsev0_.ALARM_NAME as ALARM5_0_, psalertsev0_.ALARM_TEXT as ALARM6_0_, psalertsev0_.ALARM_TIME as ALARM7_0_ from ALARM_REPLAY_NEW psalertsev0_ where psalertsev0_.Id>20118832 NHibernate: UPDATE ALARM_REPLAY_NEW SET ALARM_SUBSTATION_NAME = :p0, ALARM_BUSBAR_NUM = :p1, ALARM_COMPONENT_ALIAS = :p2, ALARM_NAME = :p3, ALARM_TEXT = :p4, ALARM_TIME = :p5 WHERE Id = :p6;:p0 = 'Value Text', :p1 = 0, :p2 = 'Value Text', :p3 = NULL, :p4 = 'CLOSED', :p5 = 10/03/2010 15:06:31, :p6 = 20118833 15:06:56,389 ERROR [TestRunnerThread] AbstractBatcher [(null)]- Could not execute command: UPDATE ALARM_REPLAY_NEW SET ALARM_SUBSTATION_NAME = :p0, ALARM_BUSBAR_NUM = :p1, ALARM_COMPONENT_ALIAS = :p2, ALARM_NAME = :p3, ALARM_TEXT = :p4, ALARM_TIME = :p5 WHERE Id = :p6 Oracle.DataAccess.Client.OracleException ORA-01031: insufficient privileges at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)</p> <p>at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)</p> <p>at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()</p> <p>at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)</p> <p>NUnit passes the test in question, however an error is subsequently generated centered on the oracle exception:</p> <p>Oracle.DataAccess.Client.OracleException ORA-01031: insufficient privileges</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USWill Marcouiller
    1. USPaul Johnson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONHIbernate Newbie: Can someone please explain why NHibernate attempts to execute a database update during CreateQuery execution
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMapping and entity class?
      singulars
      1. PONHIbernate Newbie: Can someone please explain why NHibernate attempts to execute a database update during CreateQuery execution
      1. USPaco
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload