Skip to content

Instantly share code, notes, and snippets.

...
import static com.blogspot.vardlokkur.domain.QEmployee.employee;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import org.springframework.beans.factory.annotation.Autowired;
import com.blogspot.vardlokkur.domain.EmployeeNameProjection;
import com.blogspot.vardlokkur.domain.QEmployeeNameProjection;
package com.blogspot.vardlokkur.domain;
import java.io.Serializable;
import javax.annotation.concurrent.Immutable;
import com.mysema.query.annotations.QueryProjection;
@Immutable
public class EmployeeNameProjection implements Serializable {
...
import static com.blogspot.vardlokkur.domain.QEmployee.employee;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import org.springframework.beans.factory.annotation.Autowired;
import com.blogspot.vardlokkur.domain.EmployeeNameProjection;
import com.blogspot.vardlokkur.domain.EmployeeNameProjectionFactory
package com.blogspot.vardlokkur.domain;
import static com.blogspot.vardlokkur.domain.QEmployee.employee;
import com.mysema.query.Tuple;
import com.mysema.query.types.MappingProjection;
public class EmployeeNameProjectionFactory extends MappingProjection<EmployeeNameProjection> {
public EmployeeNameProjectionFactory() {
...
import static com.blogspot.vardlokkur.domain.QEmployee.employee;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import org.springframework.beans.factory.annotation.Autowired;
import com.blogspot.vardlokkur.domain.EmployeeNameProjection;
package com.blogspot.vardlokkur.domain;
import java.io.Serializable;
import javax.annotation.concurrent.Immutable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
package com.blogspot.vardlokkur.domain;
import java.io.Serializable;
import javax.annotation.concurrent.Immutable;
@Immutable
public class EmployeeNameProjection implements Serializable {
private final Long employeeId;
package com.blogspot.vardlokkur.domain;
...
import org.joda.money.Money;
@Entity
@Table(name = "EMPLOYEE")
public class Employee implements Serializable {
...
/**
* Provides the domain model.
*
* @author Warlock
*/
@org.hibernate.annotations.TypeDef(name = "money", defaultForType = Money.class, typeClass = PersistentMoneyAmount.class)
package com.blogspot.vardlokkur.domain;
import org.jadira.usertype.moneyandcurrency.joda.PersistentMoneyAmount;
import org.joda.money.Money;
@vardlokkur
vardlokkur / gist:3340316
Created August 13, 2012 12:46
SQL query used for fetching rows from 6 to 10
select * from (
select
row_.*, rownum rownum_
from (
select
employee0_.EMPLOYEE_ID as EMPLOYEE1_0_, employee0_.DATE_OF_BIRTH as DATE2_0_,
employee0_.EMPLOYEE_NAME as EMPLOYEE3_0_
from EMPLOYEE employee0_
order by employee0_.EMPLOYEE_NAME
) row_