| Hi:
I have see any demo for the multiTenant of mutiple database. But can't solve my problem because I have only single database and all tables have tencent column to choose it. I had see hibernate 5 supported
MultiTenancyStrategy#DISCRIMINATOR but i don't see any demo or code to show it? `AbstractDataSourceBasedMultiTenantConnectionProviderImpl` is used to choose database. but i want to use a column like it.
I had use filter to appove it. but i think it's not a correct solution.
The base entity like this. the orgRrn is my tencent identifier.
```java
package com.newbiest.base.model; import com.newbiest.base.ui.model.*;
import com.newbiest.base.utils.StringUtils;
import com.newbiest.base.utils.ThreadLocalContext;
import com.newbiest.security.model.NBAuthority;
import com.newbiest.security.model.NBOrg;
import com.newbiest.security.model.NBUser;
import lombok.*;
import lombok.experimental.Accessors;
import org.hibernate.annotations.FilterDef;
import org.hibernate.annotations.ParamDef;
import org.hibernate.annotations.Where; import javax.persistence.*;
import java.io.Serializable; /**
- 所有的POJO基类
- Created by guoxunbo on 2017/9/7.
*/
@MappedSuperclass
@Accessors(chain = true)
@NoArgsConstructor
@ToString
//@Where(clause=NBBase.SQL_AVAILABLE_OBJ_CONDITION) 当前的@where无效。无法应用到子类。需要每个类都定义。计划在hibernate6.X上实现
//@FilterDef(name = "multi-tenant", parameters = @ParamDef(name = "orgRrn", type = "long"))
public class NBBase implements Serializable, Cloneable {
private static final long serialVersionUID = -4455314847475119658L; public static final String AVAILABLE_OBJ_CONDITION = " activeFlag = 'Y'";
public static final String SQL_AVAILABLE_OBJ_CONDITION = " ACTIVE_FLAG = 'Y'"; public static final String ORG_CONDITION = " (orgRrn = :orgRrn OR orgRrn = 0)"; // public static final String SQL_BASE_CONDITION = " ACTIVE_FLAG = 'Y' AND (ORG_RRN = :orgRrn OR ORG_RRN = 0) "; /**
- 懒加载时候使用：注意使用many.size()方法获得many对象
- 这个表示将one对象上所有属性都获取以及获取多对象
*/
public static final String LAZY_LOAD_PROP = "javax.persistence.loadgraph";
/**
- 懒加载时候使用：注意使用many.size()方法获得many对象
- 这个表示只one对象上的多对象
*/
public static final String LAZY_FETCH_PROP = "javax.persistence.fetchgraph";
public static final String LANGUAGE_CHINESE = "Chinese";
public static final String LANGUAGE_ENGLISH = "English"; @Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name="OBJECT_RRN")
@Setter
@Getter
protected Long objectRrn; @Column(name="ORG_RRN")
@Getter
protected Long orgRrn = 0L; @Column(name="ACTIVE_FLAG")
@Setter
@Getter
protected String activeFlag = StringUtils.YES; public Boolean getActiveFlag() { return StringUtils.YES.equalsIgnoreCase(activeFlag); } public void setActiveFlag(Boolean activeFlag) { this.activeFlag = activeFlag ? StringUtils.YES : StringUtils.NO; } @PrePersist
protected void prePersist() {
if (this instanceof NBTable || this instanceof NBTab || this instanceof NBField
| this instanceof NBReferenceTable |
this instanceof NBSystemReferenceName |
| this instanceof NBMessage |
this instanceof NBUser |
this instanceof NBAuthority |
| this instanceof NBParameter |
this instanceof NBTree) { this.orgRrn = NBOrg.GLOBAL_ORG_RRN; } else { this.orgRrn = ThreadLocalContext.getOrgRrn(); } } |
@Override
public Object clone() throws CloneNotSupportedException { NBBase nbBase = (NBBase) super.clone(); nbBase.setObjectRrn(null); return nbBase; } } ```
Thank you |
