class cast exception in hibernate

Question

Test.java

public static void main(String[] args) {
    System.out.println("Enter reporting manager empid");
    Scanner sc = new Scanner(System.in);
    Integer in = sc.nextInt();
Session session=new  AnnotationConfiguration().configure().buildSessionFactory().openSession();
 Query query=session.createQuery("select count(*)from MisRecords where empReportingManagerId=:i");
 query.setParameter("i", in);
    List<MisRecords> list=query.list();{
    for(MisRecords employee:list){
        //  System.out.println(employee.getFirstName());
        //  System.out.println(employee.getLastName());
         // System.out.println(employee.getEmpId());
          System.out.println(employee.getFirstName()+" "+ employee.getEmpId()+ " "+employee.getEmpReportingManagerId());

     }
MisRecords.java

@Entity
@Table(name="dat_emprecords")
public class MisRecords {
@Id
@GeneratedValue
@Column(name="pk_EmpRec_Idx")
    int id;

    @Column(name="EmpRec_EmpFName")
    String firstName;
    @Column(name="EmpRec_EmpLName")
    String lastName;
    @Column(name="fk_EmpRec_EmpID")
    int empId;
    @Column(name="fk_emprec_empreportingmgrid")
    int empReportingManagerId;

//output Enter reporting manager empid 1 log4j:WARN No appenders could be found for logger (org.hibernate.cfg.annotations.Version). log4j:WARN Please initialize the log4j system properly. Exception in thread "main" java.lang.ClassCastException: java.lang.Long cannot be cast to com.saurabh.MisRecords at com.saurabh.Test.main(Test.java:17)

When i am trying to run i am getting this classCastException ,Don't know why? please help. thanks in advance.

check out this link..it might help you with your issue..

Abdullah Mohammad Motiullah
– Abdullah Mohammad Motiullah

2015-06-02 05:04:33 +00:00
Commented Jun 2, 2015 at 5:04 — Abdullah Mohammad Motiullah
– Abdullah Mohammad Motiullah, Commented Jun 2, 2015 at 5:04

Kennedy Oliveira · Accepted Answer · 2015-06-02 04:39:03Z

3

You are getting a long from your query because you are using select count, if you wanna retrieve all the entities use from entity or select e from entity e

answered Jun 2, 2015 at 4:39

Kennedy Oliveira

2,3012 gold badges22 silver badges26 bronze badges

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

Comments

Amit Das · Accepted Answer · 2015-06-02 04:53:28Z

3

You have used count(*) in your query. Thats why it will give result as a long value. if you want to get only count then you can execute the query and after that do query.iterate() and take the first result in long variable.

answered Jun 2, 2015 at 4:53

Amit Das

1,1075 gold badges17 silver badges45 bronze badges

2 Comments

saurabh Over a year ago

int a=( (Long) session.createQuery("select count(*) from MisRecords where empReportingManagerId=1").iterate().next() ).intValue(); ,i found this solution ,but here i am hard coding the id,how i can provide value from scanner

Amit Das Over a year ago

You can use direct variable name in the query. like this - int a=( (Long) session.createQuery("select count(*) from MisRecords where empReportingManagerId="+VARIABLE_NAME).iterate().next() ).intValue();

shruti1810 · Accepted Answer · 2015-06-02 05:04:05Z

3

Your query is returning the count of results which is long. Please do :

select * from MisRecords where empReportingManagerId=:i

insetad of

select count(*)from MisRecords where empReportingManagerId=:i to get the results from the query.

If you want the count, you can do the following:

Query query=session.createQuery("select count(*)from MisRecords where empReportingManagerId=:i");
query.setParameter("i", in);
Iterator itr =query.iterator();
int i = 0;
if(itr.hasNext()){
    i = itr.next().intValue();
}

edited Jun 2, 2015 at 5:04

answered Jun 2, 2015 at 4:38

shruti1810

4,0452 gold badges18 silver badges28 bronze badges

5 Comments

saurabh Over a year ago

i want to see how many records are there instead to select all records

shruti1810 Over a year ago

Then you should not be doing the following operation on that : List<MisRecords> list=query.list(); As you know the result of the query is Long and not MisRecords.

shruti1810 Over a year ago

You might do a query.iterate() and take the first result in the Long variable.

saurabh Over a year ago

int a=( (Long) session.createQuery("select count(*) from MisRecords where empReportingManagerId=1").iterate().next() ).intValue(); ,i found this solution ,but here i am hard coding the id,how i can provide value from scanner

saurabh Over a year ago

its correct but this answer Query query=session.createQuery("select count(*)from MisRecords where empReportingManagerId=:i"); Long recordCount = (Long) query.uniqueResult(); is more efficient ,i will upvote your answer but.

Gaurang Patel · Accepted Answer · 2015-06-02 06:40:11Z

2

As you mentioned in the comment, I see that you are trying to see record count,

i want to see how many records are there instead to select all records

For that use below code snippet,

Query query=session.createQuery("select count(*)from MisRecords where empReportingManagerId=:i");
Long recordCount = (Long) query.uniqueResult();

answered Jun 2, 2015 at 6:40

Gaurang Patel

4,5606 gold badges31 silver badges32 bronze badges

Comments

Chandu D · Accepted Answer · 2015-06-02 11:18:09Z

0

I think its better for u

Long value=hibernateTemplate.find(""select count(*)from MisRecords where empReportingManagerId=?,i);

answered Jun 2, 2015 at 11:18

Chandu D

5013 silver badges17 bronze badges

Collectives™ on Stack Overflow

class cast exception in hibernate

5 Answers 5

Comments

2 Comments

5 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

2 Comments

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related