Null pointer exception when getting the value from query in java

Question

I am fetching the value using query

SELECT t.revision_no 
FROM (
    SELECT MAX( CONVERT( revision_no, signed INT ) ) AS revision_no 
    FROM atps_dc 
    WHERE DATE =  '"+date+"' 
    GROUP BY CONVERT( revision_no, signed INT )) 
INNER JOIN atps_dc t 
ON t.revision_no = r.revision_no AND t.date =  '"+date+"'";

and trying to set this value using this

bA.setRev_no(rs2.getString("revision_no"));

but the compiler is giving the null pointer exception. Please help me, how can I resolve it.

Thanks in advance.

Community · Accepted Answer · 2017-05-23 10:33:20Z

1

compiler doesn't give NullPointerException it is RuntimeException, You are pointing bA to null and then trying to invoke method on it and so the NullPointerException

DC_ChangeA bA=null; 
bA.setRev_no(rs2.getString("revision_no"));

try DC_ChangeA bA = new DC_ChangeA() or proper initialization in the place of DC_ChangeA bA = null

See

Why does Java have a "NullPointerException" when there are no pointers in Java?

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Jun 18, 2014 at 18:07

Jigar Joshi

241k42 gold badges409 silver badges446 bronze badges

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

Collectives™ on Stack Overflow

Null pointer exception when getting the value from query in java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related