[2.2.1 Java] Custom query problem

[Maffh]

Hello,

Is it possible to use Ebean in the Play! framework with the following query:

SELECT value

 FROM model2

 JOIN model3 ON model2.model1_id=model3.model1_id

model1
id
name

model2
id
model1
value

model3
id
model1

I've tried: Model2Finder.where().join("model1", "model3.model1").findList();

But this gave me the following error "- property [model3.model2] not found on package.model1 for query excluding it."

Thanks in advance!

[Maffh]

I've fixed the problem by using RawSqlBuilder.

 

Op donderdag 24 april 2014 14:50:46 UTC+2 schreef Maffh: