Error in building SQL statement

Question

While running this code:

note = noteDAO.queryForFirst(
    noteDAO.queryBuilder().where().notIn("id",
        noteStateDAO.queryBuilder().distinct().selectColumns("noteId")
        .prepare())
    .prepare());

... I've got following exception:

Problems executing Android query: SELECT * FROM `notes` WHERE `id` NOT IN 
     (MappedStatement: SELECT DISTINCT `noteId` FROM `note_states`)

Any ideas of what is MappedStatement in that SQL?

Gray · Accepted Answer · 2013-07-24 19:33:52Z

1

You've solved you problem it seems, but I thought I'd provide some more information.

The Where.notIn(...) method takes either objects or a QueryBuilder argument. By doing a prepare(), it turns it into a MappedQuery which was passed as an Object unfortunately.

As you mention, if your remove the prepare(), it will use the QueryBuilder arguments. See the javadocs for notIn(String, QueryBuilder).

I've added better checking against passing in a prepared query in ORMLite version 4.43.

edited Jul 24, 2013 at 19:33

answered Oct 5, 2012 at 22:19

Gray

117k24 gold badges305 silver badges360 bronze badges

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

Comments

Sergey Metlov · Accepted Answer · 2012-10-05 22:07:14Z

0

Ok, found by myself. No need to prepare the inner subselect query:

note = noteDAO.queryForFirst(
    noteDAO.queryBuilder().where().notIn("id",
        noteStateDAO.queryBuilder().distinct().selectColumns("noteId")
        /*.prepare()*/)
    .prepare());

answered Oct 5, 2012 at 22:07

Sergey Metlov

26.5k28 gold badges97 silver badges154 bronze badges

Collectives™ on Stack Overflow

Error in building SQL statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related