@Entity @Table(name = "PRODUCT_DIGITAL", schema=SchemaConstant.SALESMANAGER_SCHEMA, uniqueConstraints= @UniqueConstraint(columnNames = {"PRODUCT_ID", "FILE_NAME"})) public class DigitalProduct extends SalesManagerEntity<Long, DigitalProduct> { @Id @Column(name = "PRODUCT_DIGITAL_ID") @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "PRODUCT_DGT_SEQ_NEXT_VAL") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column(name="FILE_NAME",nullable=false) private String productFileName;
@Id @GeneratedValue(strategy = GenerationType.TABLE, generator = "MINIMAL_TBL") @TableGenerator( name = "MINIMAL_TBL", table = TBL_NAME ) public Long getId() { return id; }
/** * Sample of table generator * * @author Emmanuel Bernard */ @TableGenerator(name = "EMP_GEN", table = "GENERATOR_TABLE", pkColumnName = "pkey", valueColumnName = "hi", pkColumnValue = "Ball", allocationSize = 10) @Entity @SuppressWarnings("serial") public class Ball implements Serializable { private Integer id; @Id @GeneratedValue(strategy = GenerationType.TABLE, generator = "EMP_GEN") @Column(name = "ball_id") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } }
@Entity(name = "TestEntity") @Table(name = "TEST_ENTITY") @TableGenerator(name = "tableGenerator", table = "ID_TABLE_GENERATOR", pkColumnName = "PK", pkColumnValue = "TEST_ENTITY_ID", valueColumnName = "VALUE", allocationSize = 3, initialValue = INITIAL_VALUE) public static class TestEntity { Long id; @Id @GeneratedValue(strategy = GenerationType.TABLE, generator = "tableGenerator") public Long getId() { return id; } public void setId(Long id) { this.id = id; } }
@Entity @Table (name="ORDER_ATTRIBUTE" , schema=SchemaConstant.SALESMANAGER_SCHEMA) public class OrderAttribute extends SalesManagerEntity<Long, OrderAttribute> { @Id @Column(name = "ORDER_ATTRIBUTE_ID", unique=true, nullable=false) @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "ORDER_ATTR_ID_NEXT_VALUE") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column (name ="IDENTIFIER", nullable=false) private String key; @Column (name ="VALUE", nullable=false) private String value;
@Entity @Table(name = "tbl_dog") @TableGenerator(name = "DogGen", table = "GENERATOR_TABLE", pkColumnName = "pkey", valueColumnName = "hi", pkColumnValue = "Dog", allocationSize = 10) public class Dog {
/** * Sample of table generator * * @author Emmanuel Bernard */ @TableGenerator(name = "EMP_GEN", table = "GENERATOR_TABLE", pkColumnName = "pkey", valueColumnName = "hi", pkColumnValue = "Ball", allocationSize = 10) @Entity @SuppressWarnings("serial") public class Ball implements Serializable { private Integer id; @Id @GeneratedValue(strategy = GenerationType.TABLE, generator = "EMP_GEN") @Column(name = "ball_id") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } }
@Entity @Table(name = "GEOZONE", schema=SchemaConstant.SALESMANAGER_SCHEMA) @Id @Column(name = "GEOZONE_ID") @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "GEOZONE_SEQ_NEXT_VAL") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column(name = "GEOZONE_NAME") private String name; @Column(name = "GEOZONE_CODE") private String code;
/** * @author Emmanuel Bernard */ @Entity @NamedQuery(name = "manufacturer.findAll", query = "from Manufacturer where 1 = 2") @TableGenerator(name = "generator", table = "this is a broken name with select from and other SQL keywords") public class Manufacturer { private Integer id; private Set<Model> models = new HashSet<Model>(); @Id public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @OneToMany public Set<Model> getModels() { return models; } public void setModels(Set<Model> models) { this.models = models; } }
@Entity @Table (name="ORDER_PRODUCT_DOWNLOAD", schema=SchemaConstant.SALESMANAGER_SCHEMA) public class OrderProductDownload extends SalesManagerEntity<Long, OrderProductDownload> implements Serializable { private static final long serialVersionUID = -8935511990745477240L; @Id @Column (name="ORDER_PRODUCT_DOWNLOAD_ID") @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "ORDER_PRODUCT_DL_ID_NEXT_VALUE") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; private OrderProduct orderProduct; @Column(name = "ORDER_PRODUCT_FILENAME", nullable = false) private String orderProductFilename; @Column(name = "DOWNLOAD_MAXDAYS", nullable = false) private Integer maxdays = DEFAULT_DOWNLOAD_MAX_DAYS;
/** * @author Emmanuel Bernard */ @Entity @IdClass(SocialSecurityNumber.class) @DiscriminatorValue("Moral") @SequenceGenerator(name = "seq") @TableGenerator(name = "table") public class SocialSecurityMoralAccount { public String number; public String countryCode; }
@Entity @Table(name="CUSTOMER_OPTION_SET", schema=SchemaConstant.SALESMANAGER_SCHEMA, uniqueConstraints={ @UniqueConstraint(columnNames={ @Id @Column(name = "CUSTOMER_OPTIONSET_ID", unique=true, nullable=false) @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "CUST_OPTSET_SEQ_NEXT_VAL") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column(name="SORT_ORDER") private Integer sortOrder = new Integer(0);
@Entity @Table(name = "ZONE", schema=SchemaConstant.SALESMANAGER_SCHEMA) public class Zone extends SalesManagerEntity<Long, Zone>{ private static final long serialVersionUID = 1L; @Id @Column(name="ZONE_ID") @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "ZONE_SEQ_NEXT_VAL") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column(name = "ZONE_CODE", unique=true, nullable = false) private String code;
@Entity public static class ExplicitTableGeneratorImplicitNameEntity { /** * This entity has an explicit {@link javax.persistence.TableGenerator} defined, * but does not define {@link javax.persistence.TableGenerator#table()}. In * this case, the generator-name ("my_id_table") */ @Id @GeneratedValue( strategy = GenerationType.TABLE, generator = "my_id_table" ) @javax.persistence.TableGenerator( name = "my_id_table", allocationSize = 25 ) public Integer id; public String name; }
@Entity @Table(name = "ORDER_ACCOUNT", schema = SchemaConstant.SALESMANAGER_SCHEMA) public class OrderAccount extends SalesManagerEntity<Long, OrderAccount> { private static final long serialVersionUID = -2429388347536330540L; @Id @Column(name = "ORDER_ACCOUNT_ID", unique = true, nullable = false) @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "ORDER_ACCOUNT_ID_NEXT_VALUE") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column(name = "ORDER_ACCOUNT_START_DATE", nullable = false, length = 0) private Date orderAccountStartDate; @Column(name = "ORDER_ACCOUNT_END_DATE", length = 0) private Date orderAccountEndDate;
@Entity @Table(name = "PRODUCT_RELATIONSHIP", schema=SchemaConstant.SALESMANAGER_SCHEMA) public class ProductRelationship extends SalesManagerEntity<Long, ProductRelationship> implements Serializable { private static final long serialVersionUID = -9045331138054246299L; @Id @Column(name = "PRODUCT_RELATIONSHIP_ID", unique=true, nullable=false) @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "PRODUCT_RELATION_SEQ_NEXT_VAL") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; private Product relatedProduct = null; @Column(name="CODE") private String code; @Column(name="ACTIVE") private boolean active = true;
@Entity @Table(name="CUSTOMER_ATTRIBUTE", schema=SchemaConstant.SALESMANAGER_SCHEMA, uniqueConstraints={ @UniqueConstraint(columnNames={ private static final long serialVersionUID = -6537491946539803265L; @Id @Column(name = "CUSTOMER_ATTRIBUTE_ID", unique=true, nullable=false) @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "CUST_ATTR_SEQ_NEXT_VAL") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; private CustomerOptionValue customerOptionValue; @Column(name="CUSTOMER_ATTR_TXT_VAL") private String textValue;
@Entity @Table(name = "TAX_CLASS", schema = SchemaConstant.SALESMANAGER_SCHEMA,uniqueConstraints= @UniqueConstraint(columnNames = {"MERCHANT_ID", "TAX_CLASS_CODE"}) ) public class TaxClass extends SalesManagerEntity<Long, TaxClass> { @Id @Column(name = "TAX_CLASS_ID", unique=true, nullable=false) @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "TX_CLASS_SEQ_NEXT_VAL") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column(name="TAX_CLASS_CODE", nullable=false, length=10) private String code; @Column(name = "TAX_CLASS_TITLE" , nullable=false , length=32 ) private String title;
@Entity @Table(name = "CURRENCY", schema = SchemaConstant.SALESMANAGER_SCHEMA) @Cacheable public class Currency extends SalesManagerEntity<Long, Currency> implements Serializable { private static final long serialVersionUID = -999926410367685145L; @Id @Column(name = "CURRENCY_ID") @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "CURRENCY_SEQ_NEXT_VAL") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column(name = "CURRENCY_CURRENCY_CODE" ,nullable = false, unique = true) private java.util.Currency currency; @Column(name = "CURRENCY_SUPPORTED") private Boolean supported = true;
@Entity @Table (name="ORDER_PRODUCT" , schema=SchemaConstant.SALESMANAGER_SCHEMA) public class OrderProduct extends SalesManagerEntity<Long, OrderProduct> { private static final long serialVersionUID = 176131742783954627L; @Id @Column (name="ORDER_PRODUCT_ID") @TableGenerator(name = "TABLE_GEN", table = "SM_SEQUENCER", pkColumnName = "SEQ_NAME", valueColumnName = "SEQ_COUNT", pkColumnValue = "ORDER_PRODUCT_ID_NEXT_VALUE") @GeneratedValue(strategy = GenerationType.TABLE, generator = "TABLE_GEN") private Long id; @Column (name="PRODUCT_SKU") private String sku; @Column (name="PRODUCT_NAME" , length=64 , nullable=false) private String productName;