can we use subquery in .list() of a main query in QueryDSL? Please reply ASAP.

[pradeep gupta]

Here is the java code snippet what I am trying to do.

SQLQuery query1 = new SQLQuery(conn, configuration); 

SQLSubQuery sql = new SQLSubQuery().from(user).where(user.firstName.eq("Pradeep"));

List<List<String>> tupleList = query1.from(user).list(sql.list(user.firstName));

The last line is having a null pointer exception.

with cause = null java.lang.NullPointerException: null at com.mysema.query.sql.JavaTypeMapping.findType(JavaTypeMapping.java:129) ~[querydsl-sql-3.6.1.jar:na] at com.mysema.query.sql.JavaTypeMapping.getType(JavaTypeMapping.java:108) ~[querydsl-sql-3.6.1.jar:na] at com.mysema.query.sql.Configuration.getType(Configuration.java:316) ~[querydsl-sql-3.6.1.jar:na] at com.mysema.query.sql.Configuration.get(Configuration.java:208) ~[querydsl-sql-3.6.1.jar:na] at com.mysema.query.sql.AbstractSQLQuery.get(AbstractSQLQuery.java:111) ~[querydsl-sql-3.6.1.jar:na] at com.mysema.query.sql.AbstractSQLQuery.list(AbstractSQLQuery.java:347) ~[querydsl-sql-3.6.1.jar:na]

[timowest]

What kind of SQL do you want to express?

[pradeep gupta]

The actual sql is different but I want to achieve an equivalent of 

select (select distinct USER.first_name from USER USER where USER.first_name = 'Pradeep') from USER USER

List<List<String>> tupleList = query1.from(user).list(sql.distinct().list(user.firstName));

Above line is creating the same query in the logs.

[DEBUG] com.mysema.query.sql.AbstractSQLQuery - select (select distinct USER.first_name from USER USER where USER.first_name = ?) from USER USER

But execution is getting terminated by throwing null pointer exception with the mentioned stacktrace.

Please note the query is returning result when I am executing it in database directly.

[pradeep gupta]

@Timo.....I am still waiting for a solution. Please help me.

On Thursday, 5 November 2015 13:23:50 UTC+5:30, pradeep gupta wrote:

[timowest]

Hi, sorry for the delay.

The following works:

List<List<String>> tupleList = query1.from(user).unique(sql.list(user.firstName));

I will fix the list behaviour for subqueries.

[pradeep gupta]

Hi Timo,

Thanks for your reply. Above code snippet is replica what I am trying to do. Actual code is different. In that I need 

query.list(subquery.list(...), ....)

So I think until you fix that in your next release, I will not be able to proceed further.

Please comment if you have any suggestion.

On Thursday, 5 November 2015 13:23:50 UTC+5:30, pradeep gupta wrote:

[timowest]

Sorry, my fix example was wrong, try:

List<List<String>> tupleList = query1.from(user).list(sql.unique(user.firstName));