Hibernate MYSQL native query throws ClassCastException

Question

Retrieving integer value from table using Hibernate, following exception occurred,

java.lang.ClassCastException: java.lang.Integer cannot be cast to pojo.Datasetstatus

String q1="SELECT datasetstatusID from datasetstatus where DatasetID='"+meta_dataset+"'";
Query query=session.createSQLQuery(q1);
List<Datasetstatus> dobj=query.list();
for(Datasetstatus dobj1: dobj) {        
    System.out.println("Value   :: "+dobj1.getDatasetStatusId());
    }

Pojo class format,

    public class Datasetstatus implements java.io.Serializable {

    private Integer datasetStatusId;    
    private String datasetId;

    public Datasetstatus(String datasetId) {
        this.datasetId = datasetId;
    }

    public Integer getDatasetStatusId() {
        return this.datasetStatusId;
    }

    public void setDatasetStatusId(Integer datasetStatusId) {
        this.datasetStatusId = datasetStatusId;
    }

    public String getDatasetId() {
        return this.datasetId;
    }

    public void setDatasetId(String datasetId) {
        this.datasetId = datasetId;
    }
}

If any suggestions for solving this problem

Can you update your code showing us all the annotations on the Pojo class? Which line is your code crashing on? — Tim Biegeleisen
– Tim Biegeleisen, Commented May 5, 2015 at 10:11
for(Datasetstatus dobj1: dobj) { System.out.println("Value :: "+dobj1.getDatasetStatusId()); }, i checked code crash on for loop ( Elements retrieve integer format) — Prakash P
– Prakash P, Commented May 5, 2015 at 10:17

Vlad Mihalcea · Accepted Answer · 2015-05-05 10:20:31Z

1

You need to change your query to this:

List<Integer> dobj=
    (List<Integer>) session.createSQLQuery(
        "SELECT ds.datasetstatusID " +
        "from datasetstatus ds " +
        "where ds.datasetId = :dataSetId")
    .setParameter("dataSetId", meta_dataset)
    .list();

The datasetstatusID is an integer not a Datasetstatus.

If you want to return Datasetstatus instead, the your query would be:

List<Datasetstatus> dobj=
    (List<Datasetstatus>) session.createSQLQuery(
    "SELECT ds " +
    "from datasetstatus ds " +
    "where ds.datasetId = :dataSetId")
.setParameter("dataSetId", meta_dataset)
.list();

answered May 5, 2015 at 10:20

Vlad Mihalcea

156k85 gold badges599 silver badges984 bronze badges

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

Comments

Tim Biegeleisen · Accepted Answer · 2015-05-05 10:19:58Z

1

There appears to be a problem with your query. You used the following SQL:

SELECT datasetstatusID from datasetstatus where DatasetID = meta_dataset

But you should be using HQL instead:

from datasetstatus d where d.datasetID = meta_dataset

Here is your modified code:

String q1 = "from datasetstatus d where d.datasetID = :datasetID";
Query query = session.createSQLQuery(q1)
.setParameter("datasetID", meta_dataset);
List<Datasetstatus> dobj = query.list();
for (Datasetstatus dobj1 : dobj) {        
    System.out.println("Value   :: " + dobj1.getDatasetStatusId());
}

answered May 5, 2015 at 10:19

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Comments

PS Kumar · Accepted Answer · 2015-05-07 04:30:51Z

1

You are access particular attribute from the pojo class not an pojo object, then only you are facing java.lang.Integer cannot be cast to pojo.Datasetstatus you can try,

 String q1="SELECT a from datasetstatus as a whereDatasetID='"+meta_dataset+"'";
Query query=session.createQuery(q1);
    List<Datasetstatus> dobj=(List<Datasetstatus>) query.list();
    for(Datasetstatus dobj1: dobj) {        
        System.out.println("Value   :: "+dobj1.getDatasetStatusId());
   }

if you try the above code you will get a answer. or you can try below code as well,

String q1="SELECT a.datasetstatusID from datasetstatus as a whereDatasetID='"+meta_dataset+"'";
    Query query=session.createSQLQuery(q1);
        List<Object[]> dobj=query.list();
        for(Object dobj1: dobj) {        
            System.out.println("Value   :: "+dobj1.get[0]);
       }

edited May 7, 2015 at 4:30

answered May 7, 2015 at 4:09

PS Kumar

2,4766 gold badges33 silver badges45 bronze badges

2 Comments

Prakash P Over a year ago

Senthil create chat room after add me in chat room, i can't create chat room, need 100 reputation points

Prakash P Over a year ago

Senthil i checked first code not working it throws java.lang.ClassCastException

Alpesh Jikadra · Accepted Answer · 2015-05-07 06:56:25Z

0

If you are retrieving the single column value then ideally you should not go for POJO Class instead of that you can directly cast it to List<Integer>

List<Integer> dobj = query.list();

for(Integer dobj1: dobj) {        
    System.out.println("Value   :: "+dobj1);
}

This will solve your problem

answered May 7, 2015 at 6:56

Alpesh Jikadra

1,7224 gold badges18 silver badges41 bronze badges

1 Comment

Prakash P Over a year ago

I checked your code but not working. exception occured "Could not extract ResultSet"

Collectives™ on Stack Overflow

Hibernate MYSQL native query throws ClassCastException

4 Answers 4

Comments

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related