Databases
StackOverflow2013
Postsdbo
POHibernate ObjectNotFoundException Inconsistency
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHibernate ObjectNotFoundException Inconsistency
    primarykey
    data
    text
    <p>I have the following one-to-one (optional) relationship between two entities:</p> <pre><code>@Entity @Table(name = "HLTH_RQRMT") public class Requirement { ... @OneToOne(mappedBy = "healthRequirement", cascade = CascadeType.ALL) private HealthRequirementSystemIdentifier requirementSystemId; ... public HealthRequirementSystemIdentifier getRequirementSystemId() { return requirementSystemId; } } @Entity @Table(name = "HLTH_RQRMT_SYS_IDNTFR") public class HealthRequirementSystemIdentifier { @OneToOne(fetch = FetchType.LAZY) @JoinColumn(name = "Hlth_Rqrmt_Id", nullable = false) private Requirement healthRequirement; } </code></pre> <p>After the requirement is loaded from the database, the identifier is checked:</p> <pre><code>//Load will always return a result (or exception) - works correctly. Requirement requirement = (Requirement) getSession().load(Requirement.class, id); //This is where the exception is thrown if (requirement.getRequirementSystemId() == null) </code></pre> <p>When there is an identifier, the code works fine in all environments. When there is no identifier, it works fine in unit tests and locally (confirmed by testing against the production database). When there is no identifier in production, the following error is thrown:</p> <pre><code>org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [Requirement#250583] at org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(SessionFactoryImpl.java:419) at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154) at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143) at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174) at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190) at Requirement_$$_javassist_66.getRequirementSystemId(Requirement_$$_javassist_66.java) at mypackage.myclass.processResponse(MyServiceImpl.java:244) </code></pre> <p>I can trigger the above error in unit tests by added the property <code>optional=false</code> to the mapping annotation.</p> <p>What could cause the results to be different between unit tests and production? The default value of the <code>optional</code> property is true, which is why it works correctly in unit tests. If I add the property <code>optional=true</code>, it has no impact on the unit tests, but is it likely to fix the issue in production?</p> <p>I am aware of the annotation <code>@NotFound(action=NotFoundAction.IGNORE)</code>, but I'd prefer to understand the cause of the problem before ignoring it.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJ Barclay
    1. USJ Barclay
    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
    1. This table or related slice is empty.
    1. COthis might indicate a spurious HealthRequirementSystemIdentifier row referencing a non-existing Requirement id. Execute a select query on production to check for this inconsistency
      singulars
      1. POHibernate ObjectNotFoundException Inconsistency
      1. USᴳᵁᴵᴰᴼ
    2. COThe database would not allow that as it would violate foreign key integrity. Still, I ran the query and this is not the case. Thank you for the suggestion though.
      singulars
      1. POHibernate ObjectNotFoundException Inconsistency
      1. USJ Barclay
    3. COWell, your exception tells you that hibernate cannot find a Requirement instance with @Id 250583; it might happen for other reasons besides integrity inconsistency, like concurrency or a badly caught exception, but that's rare. The stacktrace and relevant code can make the situation more clear. Which is the underlying database?
      singulars
      1. POHibernate ObjectNotFoundException Inconsistency
      1. USᴳᵁᴵᴰᴼ
 

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