Форум программистов [Powered by Invision Power Board]

Код


javax.persistence.EntityNotFoundException: Unable to find jpa.entity.Solution with id jpa.entity.SolutionPK[solutionId=4, taskId=2002, moduleId=1846]
        at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:113)
...

Код


em.createQuery("select o from Fieldvalue o where " +
                "o.id.solutionId = :solutionId"
                )
                .setParameter("solutionId", solutionId.intValue())
                .getResultList()

Код


...
@Entity
@Table(name = "Fieldvalue")
public class Fieldvalue extends Serializable {

    @EmbeddedId
    private FieldvaluePK id;
    ...

    @ManyToOne
    @JoinColumns({        
        @JoinColumn(name = "TASK_ID", nullable=false, insertable = false, updatable = false)
        , @JoinColumn(name = "SOLUTION_ID", nullable=false, insertable = false, updatable = false)
    , @JoinColumn(name = "MODULE_ID", nullable=false, insertable = false, updatable = false)
    })
    
    private Solution solution;
...
}
@Embeddable
public class FieldvaluePK implements Serializable {

    @Basic(optional = false)
    @Column(name = "TASK_ID")
    private int taskId;

    @Basic(optional = false)
    @Column(name = "SOLUTION_ID")
    private int solutionId;

    @Basic(optional = false)
    @Column(name = "MODULE_ID")
    private int moduleId;

    @Basic(optional = false)
    @Column(name = "FIELD_ID")
    private int fieldId;
...
}
...
public class Solution implements Serializable {

    @EmbeddedId
    protected SolutionPK solutionPK;
...
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "solution")
    private List<Fieldvalue> fieldvalueCollection = new ArrayList<Fieldvalue>();
...
}
...
@Embeddable
public class SolutionPK implements Serializable {
    @Basic(optional = false)
    @Column(name = "TASK_ID")
    private Integer taskId;
    @Basic(optional = false)
    @Column(name = "SOLUTION_ID")
    private Integer solutionId;
    @Basic(optional = false)
    @Column(name = "MODULE_ID")
    private Integer moduleId;
...
}

Код


public class CurrencyRatePk implements Serializable {

    @Temporal(TemporalType.DATE)
    private Date arcDate;
    private Long currencyId;

// getters & setters

//    public boolean equals(Object o) 
  //  public int hashCode()
}


@Entity
@IdClass(CurrencyRatePk.class)
public class CurrencyRate implements Serializable {
    @Id
    private Date arcDate;
    @Id
    private Long currencyId;

    private Double rate;

    private Long base;

// getters & setters

}

Код


em.createQuery("select o from Fieldvalue o where " +
                "o.solutionId = :solutionId"
                )

Код


select solution0_.MODULE_ID as MODULE1_14_1_, solution0_.SOLUTION_ID as SOLUTION2_14_1_, solution0_.TASK_ID as TASK3_14_1_, 
solution0_.CALCULATION_DURATION as CALCULAT4_14_1_, solution0_.CALCULATION_TIME_START as CALCULAT5_14_1_, solution0_.FREQUENCY 
as FREQUENCY14_1_, solution0_.STATE as STATE14_1_, solution0_.VERIFICATIONCOUNT as VERIFICA8_14_1_, analytical1_.MODULE_ID as 
MODULE1_0_0_, analytical1_.AUTHOR as AUTHOR0_0_, analytical1_.INTERFACECLASS as INTERFAC3_0_0_, analytical1_.MODULENAME as 
MODULENAME0_0_, analytical1_.RELEASEDATE as RELEASED5_0_0_, analytical1_.VERSION as VERSION0_0_ 
from SOLUTION solution0_ inner join ANALYTICALMODULE analytical1_ on 
solution0_.MODULE_ID=analytical1_.MODULE_ID where solution0_.MODULE_ID=? and solution0_.SOLUTION_ID=? and solution0_.TASK_ID=?

Код


...
public class Fieldvalue implements Serializable {
...
    @ManyToOne
    @JoinColumns({
        @JoinColumn(name = "MODULE_ID", nullable=false, insertable = false, updatable = false)
        , @JoinColumn(name = "SOLUTION_ID", nullable=false, insertable = false, updatable = false)
        , @JoinColumn(name = "TASK_ID", nullable=false, insertable = false, updatable = false)
    })

    private Solution solution;
...
}