@ColumnTransformer( read = "radiusS / 2.54E0", write = "? * 2.54E0" ) public double getRadiusS() { return radiusS; } public void setRadiusS(double radiusS) { this.radiusS = radiusS; }
@Column(name="diamet") @ColumnTransformer( read = "diamet / 2.54E0", write = "? * 2.54E0" ) public double getDiameter() { return diameter; } public void setDiameter(double diameter) { this.diameter = diameter; }
@Column(name="size_in_cm") @ColumnTransformer( forColumn = "size_in_cm", read = "size_in_cm / 2.54E0", write = "? * 2.54E0" ) public double getSizeInInches() { return sizeInInches; } public void setSizeInInches(double sizeInInches) { this.sizeInInches = sizeInInches; }
@Column(name="kooky") @ColumnTransformer( read = "cast( kooky as VARCHAR )" ) public String getKooky() { return kooky; } public void setKooky(String kooky) { this.kooky = kooky; }
@Column(table = "t_user", name = "pwd_expiry_weeks") @ColumnTransformer( read = "pwd_expiry_weeks * 7.0E0", write = "? / 7.0E0") public Double getPasswordExpiryDays() { return passwordExpiryDays; }
@Column( name = "height_centimeters" ) @ColumnTransformer( read = "height_centimeters / 2.54E0", write = "? * 2.54E0" ) public double getHeightInches() { return heightInches; }
@Audited @Column(name = "size_in_cm") @ColumnTransformer( forColumn = "size_in_cm", read = "size_in_cm / 2.54E0", write = "? * 2.54E0") public double getSizeInInches() { return sizeInInches; }
@Entity(name = "Employee") public static class Employee { @Id private Long id; @NaturalId private String username; @Column(name = "pswd") @ColumnTransformer( read = "decrypt( 'AES', '00', pswd )", write = "encrypt('AES', '00', ?)" ) private String password; private int accessLevel; @ManyToOne(fetch = FetchType.LAZY) private Department department; @ManyToMany(mappedBy = "employees") private List<Project> projects = new ArrayList<>(); //Getters and setters omitted for brevity } //end::mapping-column-read-and-write-example[]
@Column(name = "currency") }) @ColumnTransformer( forColumn = "money", read = "money / 100",
@Entity(name = "Employee") @FetchProfile( name = "employee.projects", fetchOverrides = { @FetchProfile.FetchOverride( entity = Employee.class, association = "projects", mode = FetchMode.JOIN ) } ) //end::fetching-strategies-dynamic-fetching-profile-mapping-example[] public static class Employee { @Id private Long id; @NaturalId private String username; @Column(name = "pswd") @ColumnTransformer( read = "decrypt( 'AES', '00', pswd )", write = "encrypt('AES', '00', ?)" ) private String password; private int accessLevel; @ManyToOne(fetch = FetchType.LAZY) private Department department; @ManyToMany(mappedBy = "employees") private List<Project> projects = new ArrayList<>(); //Getters and setters omitted for brevity }
@ColumnTransformer( read = "decrypt( 'AES', '00', pswd )", write = "encrypt('AES', '00', ?)"
private Long id; @ColumnTransformer( read = "pgp_sym_decrypt(" + " storage, " +