Native query causing null pointer exception

Question

At this point I am very confused. I have a controller that uses my DAO to run a query, but it is giving me a null pointer exception. I have been solving error after error but can't seem to get to the root of them all.

Controller:

DAO d = new DAO();
List<objects> foo = d.callQuery(new object());

DAO:

        Calendar cal = new GregorianCalendar();
    cal.set(cal.get(Calendar.YEAR), cal.get(Calendar.MONTH), cal.get(Calendar.DAY_OF_MONTH), 0, 0, 0);

    Date begin = new Date(cal.getTimeInMillis());
    Date end = new Date(cal.getTimeInMillis());

    String theQuery = "SELECT * from table1";
    Query query = em.createNativeQuery(theQuery).setParameter("begin", begin).setParameter("end", end);

Error leads me to this line: Query query = em.createNativeQuery(theQuery).setParameter("begin", begin).setParameter("end", end);

What could possibly be null? Note: this is not my full query, my full query is working and contains both parameters.

I printed begin and end and they both gave me the expected results. The stack trace leads me from the second line of my controller to the create query line.

The stack trace leads me from the second line of my controller to the create query line. @Reimeus — Jordan.J.D
– Jordan.J.D, Commented May 6, 2014 at 17:10
what parameters you trying insert? your query haven't any parameters — Aliaksei Bulhak
– Aliaksei Bulhak, Commented May 6, 2014 at 17:21
@AlekseiBulgak please read my note:"Note: this is not my full query, my full query is working and contains both parameters." — Jordan.J.D
– Jordan.J.D, Commented May 6, 2014 at 17:22
Is it possible to split up that long string of method calls into discrete calls? That might aid with debugging — awksp
– awksp, Commented May 6, 2014 at 17:45

Lucia Manescau · Accepted Answer · 2014-05-06 17:18:23Z

1

I feel like I need more information, but trying to give you some clue:

How do you get the em object? Maybe em is null...
The query that you are using, is "SELECT * from table1"? I ask it because you are setting parameters to a query that doesn´t have parameters.

I hope these questions can help.

answered May 6, 2014 at 17:18

Lucia Manescau

5016 silver badges6 bronze badges

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

1 Comment

Jordan.J.D Over a year ago

I did not want to share my full query, but I know for a fact that it works because it has worked and remains unchanged. I will try to debug for em, that may be the problem. Indeed, my entity manager is null.

Collectives™ on Stack Overflow

Native query causing null pointer exception

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related