Search code examples
javaquerydsl

QueryDSL uniqueResult() is undefined


I have the following code:

import com.querydsl.jpa.impl.JPAQuery;
...
QCustomer customer = QCustomer.customer;
JPAQuery query = new JPAQuery(entityManager);

Customer result = query.from(customer)
                  .where(customer.firstName.eq("Bob"))
                  .uniqueResult(customer);

However, in Eclipse it is saying that uniqueResult is undefined.

pom.xml

<build>
    <plugins>
        <plugin>
        <groupId>com.mysema.maven</groupId>
        <artifactId>apt-maven-plugin</artifactId>
        <version>1.1.3</version>
        <executions>
          <execution>
            <goals>
              <goal>process</goal>
            </goals>
            <configuration>
              <outputDirectory>target/generated-sources/java</outputDirectory>
              <processor>com.querydsl.apt.jpa.JPAAnnotationProcessor</processor>
            </configuration>
          </execution>
        </executions>
        <dependencies>
          <dependency>
            <groupId>com.querydsl</groupId>
            <artifactId>querydsl-apt</artifactId>
            <version>4.0.9</version>
          </dependency>
        </dependencies>
      </plugin>
    </plugins>
</build>

<dependency>
    <groupId>com.querydsl</groupId>
    <artifactId>querydsl-jpa</artifactId>
    <version>4.0.9</version>
</dependency>

<dependency>
    <groupId>com.querydsl</groupId>
    <artifactId>querydsl-apt</artifactId>
    <version>4.0.9</version>
</dependency>

<dependency>
    <groupId>com.querydsl</groupId>
    <artifactId>querydsl-core</artifactId>
    <version>4.0.9</version>
</dependency>

Solution

  • I just went ahead and avoided using JPAQuery and used JPAQueryFactory instead. Below is the new code I used:

    JPAQueryFactory queryFactory = new JPAQueryFactory(entityManager);
    
    QCustomer customer = QCustomer.customer;
    
    List<Study> result = queryFactory.selectFrom(customer)
                                     .where(customer.firstName.eq("Bob"))
                                     .fetchOne();