Select Query always runs into RuntimeException

Question

I always run into RuntimeException when i invoke following query:

val app = from(appTable)(app => where (app.id === application_ID)
      select(app)).single

This query always throws a RuntimeException:

java.lang.RuntimeException: next called with no rows available

What is wrong with my query?

Answer 1

single means that you expect one and only one result of query. If resultset is empty you receive this exception. Use headOption method instead of single.