java.lang.IllegalArgumentException with java persistance API

Question

I am getting a java.lang.IllegalArgumentException similar to the link given below.To solve it I tried to change the field type from Integer to Long. But still I am getting:

Caused by: java.lang.IllegalArgumentException: Parameter value [5] was not matching type [com.buddhiedge.server.entity.StudyplanCategory]

StudyplanCategory is the entity class.

The problem is similar to the one in the below link. Hibernate - Parameter value [2011] was not matching type [java.lang.Integer]. How to solve? My entity Class is:

@JsonIgnoreProperties({ "studyplanCategoryList", "dropboxzipfile",
        "parentCategory", "createdDate", "updatedDate" })
@JsonPropertyOrder({ "id", "name", "status", "sptTutorialsList" })
@Entity
@Table(name = "studyplan_category", catalog = "buddhiedgeserver_db", schema = "", uniqueConstraints = { @UniqueConstraint(columnNames = { "dropboxzipfile" }) })
@NamedQueries({

        @NamedQuery(name = "StudyplanCategory.findSubStudyPlanById", query = "SELECT s FROM StudyplanCategory s WHERE s.parentCategory=:parentCategory order by updatedDate DESC")})

    public class StudyplanCategory implements Serializable {
        private static final long serialVersionUID = 1L;
        @Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        @Basic(optional = false)
        @NotNull
        @Column(name = "id", nullable = false)
        private Long id;

    }

Please post the relevant code/types, and the complete error message. — Mat
– Mat, Commented Apr 28, 2012 at 9:18
Well, what about the code? The query? Why do you expect your ORM to be able to map "5" to a StudyplanCategory"? — Mat
– Mat, Commented Apr 28, 2012 at 9:24
Hi, I have added the entity class this is the named query.@NamedQuery(name = "StudyplanCategory.findSubStudyPlanById", query = "SELECT s FROM StudyplanCategory s WHERE s.parentCategory=:parentCategory order by updatedDate DESC")}). The field parentcategorey is to be passed where the exception is thrown.Please help. — user1281029
– user1281029, Commented Apr 28, 2012 at 9:29

Bozho · Accepted Answer · 2012-04-28 09:49:49Z

0

It seems you are passing 5 as parameter to the query. If you want to pass an ID rather than an entity, change the query to:

WHERE s.parentCategory.id=:parentCategoryId

answered Apr 28, 2012 at 9:49

Bozho

599k147 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

user1281029 Over a year ago

Ok.But parentCategory is field in the database. Not an object.

user1281029 Over a year ago

Hi Like this,@JoinColumn(name = "parentCategory", referencedColumnName = "id") @ManyToOne private StudyplanCategory parentCategory;

Bozho Over a year ago

exactly. So it is an object. HQL queries refer to your entity model, not your database.

user1281029 Over a year ago

Hi, i tried to change the query like this as you suggested but it throws a Null Pointer Exception because of which the server fails to start.@NamedQuery(name = "StudyplanCategory.findSubStudyPlanById", query = "SELECT s FROM StudyplanCategory s WHERE s.parentCategory.id=:parentCategory.id order by updatedDate DESC")})

user1281029 Over a year ago

hi I again changed to WHERE s.parentCategory.id=:parentCategory.id Now the server starts but org.hibernate.QueryParameterException: could not locate named parameter [parentCategory] on trying to exexute this query. Please check.

|

Collectives™ on Stack Overflow

java.lang.IllegalArgumentException with java persistance API

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related