JAVA, SQL exception while retrieving a value

Question

I am using Netbeans 6.9.1, and glassfish 3.1, the DB is MySql.

There is a table in the database called HotelNames, i need to write a SQL and pass the Hotel name to get its hotel ID. I get an exception which i am unable to solve.

    @Override
public int GetHotelID(String hotellName) {
   Query query  = em.createNativeQuery("select ID from HotelNames where hotName ='"+ hotellName+"'");
    String hotelID =  (String) query.getSingleResult();

    return Integer.parseInt(hotelID );
}

The exception i get points to the SQL i wrote in the above code

Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.String

MySQL create table looks like;

CREATE TABLE HotelNames (`ID` BIGINT NOT NULL AUTO_INCREMENT, `hotName` VARCHAR(255), PRIMARY KEY (`ID`));

I think its because of the BIGINT in the SQL and int in the code that's causing this, but i am unable to solve this.

The error is not in the return, its the line above. But, why do you try to parse a BigInt to String and then to Int? — Jacob
– Jacob, Commented Aug 1, 2011 at 6:52

Alex Gitelman · Accepted Answer · 2011-08-01 06:58:29Z

4

You may want to do something like this

Number hotelID =  (Number) query.getSingleResult();
return hotelID.intValue();

answered Aug 1, 2011 at 6:58

Alex Gitelman

24.8k7 gold badges54 silver badges50 bronze badges

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

Comments

phlogratos · Accepted Answer · 2011-08-01 06:59:56Z

0

Your query returns an BigInteger. So you can get an int like that:

        return ((BigInteger)  query.getSingleResult()).intValue();

answered Aug 1, 2011 at 6:59

phlogratos

14k1 gold badge35 silver badges38 bronze badges

Comments

sudmong · Accepted Answer · 2011-08-01 06:54:11Z

0

java.math.BigInteger cannot be cast to java.lang.String - You are trying to convert the ID to string, which is BigInteger.. See String hotelID = (String) query.getSingleResult();

answered Aug 1, 2011 at 6:54

sudmong

2,03613 silver badges12 bronze badges

Comments

RanRag · Accepted Answer · 2011-08-01 07:07:15Z

0

BigInteger bg = new BigInteger();
bg = query.getSingleResult();
String hotelId = bg.toString();

I hope this explains more.....you can also do it in one line if you wish to...

answered Aug 1, 2011 at 7:07

RanRag

49.8k39 gold badges119 silver badges172 bronze badges

Collectives™ on Stack Overflow

JAVA, SQL exception while retrieving a value

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related