How to resolve java.lang.ClassCastException while processing Sys refcursor?

Question

I have the below code

StoredProcedureQuery storedProcedure = em.createStoredProcedureQuery("pkg_p.proc_p");
         storedProcedure.getResultList();

stored proc returns a ref cursor equivalent to the below query

 select 1 as id_col, 'My Name ' as name , 1000 as sal from dual;

I have a pojo class MyTable which is equivalent to the result set return type of the query

 public class MyTable {
 private Long idCol;
 private String name;
 private Long sal;

 /// setter and getters omitted for brevity

}

for(Object[]row: resultSet)
        {
MyTable mt = new MyTable ();
mt.setIdCol((Long)row[0]);  ///throw class cast exception
}

How to resolve the below error

Request processing failed; nested exception is java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Long

Even though row[0] has Long values like 1,2,10,687 etc

You can change the Data-Type Long to Number for both idCol and sal or you can simply cast the value to Long by invoking longValue() method on the object. — ninja.coder
– ninja.coder, Commented Oct 26, 2018 at 11:13
what is the the problem? idCol has integer value in DB .why spring is treating as Big Decimal? — Oracle Mokey
– Oracle Mokey, Commented Oct 26, 2018 at 11:25

SamHoque · Accepted Answer · 2018-10-26 13:29:40Z

2

You can't cast Big Decimal to Long how ever you can get the Long value from it using

row[0].longValue()

if that doesn't work cast row to big decimal and

(BigDecimal) row[0].longValue()

so your code would look something like this

mt.setIdCol((BigDecimal)row[0].longValue());

or try to change the loop to

for(BigDecimal[] row : resultSet)

if you don't want to use casting

after reading your comments.

    for(Object[] row: resultSet) {
        MyTable mt = new MyTable();
        if(resultSet instanceof BigDecimal) {
            mt.setIdCol((BigDecimal)row[0].longValue());
        } else if (resultSet instanceof String){
            ....
        }
    }

edited Oct 26, 2018 at 13:29

answered Oct 26, 2018 at 11:13

SamHoque

3,1743 gold badges17 silver badges47 bronze badges

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

8 Comments

Oracle Mokey Over a year ago

Thanks it seems sping is by default treating any numeric value as Big Decimal.Right?

Oracle Mokey Over a year ago

i am not able to row[0].longValue() .Eclipse doesnt give option

SamHoque Over a year ago

Do you have the correct case? try mt.setIdCol(row[0].longValue()); if that doesn't work cast it to BigDecimal like this Do you have the correct case? try mt.setIdCol((BigDecimal )row[0].longValue()); ``

SamHoque Over a year ago

Edited answer let me know if you are still having problems

SamHoque Over a year ago

I have provided a variety of solutions for you to try and see what you like eclipse wasn't giving you the option because the loop item was an Object.

|

Collectives™ on Stack Overflow

How to resolve java.lang.ClassCastException while processing Sys refcursor?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related