Properties3

#是否启用WSRR[Whether use WSRR] [1:use it   0:does't use]
USEWSRR = 0
#是否记录数据库日志 [Whether save business log to database]
#[2:save log,but not save message 1: save all  0: doesn't save]
WRITEDB = 1

#是否进行安全校验
CHECK_SECURITY = 1
CHECK_PASSWORD_SQL = select userid,username from esb_users where userid = ? and password = ? and tenantid = ? and status = 1
#是否进行访问控制校验
CHECK_ACCESS = 1
CHECK_ACCESS_SQL = select userid,operation from esb_users_function where userid = ? and operation = ? and status = 1
#加密解密KEY[encrypt/decrypt key]
Encrypt_Key = huawei.esb.key


#数据库连接方式 JDBC/DataSource
DbType=JDBC

#JDBC方式后去数据库连接
defaultdb.name=ORACLE
defaultdb.driver=oracle.jdbc.driver.OracleDriver
defaultdb.url=jdbc:oracle:thin:@10.71.107.152:1521:WPSDB
defaultdb.username=esb
defaultdb.password=esb
defaultdb.initnumber=1
defaultdb.maxnumber=4
defaultdb.lockwait=10

#WPS数据源[JNDI DataSource]
DataSource = JDBC/ESB

#是否记录WPS流程日志[Whether save wps business log to database] [1: save  0: doesn't save]
WRITE_BPM_LOG = 1
#查询WPS流程日志SQLSQL[Query wps business log sql]
QUERY_BPM_LOG = select app_name,template_id,instance_id,instance_name,parent_instance_id,parent_instance_name,instance_owner,is_long_flow,stoped_nodeid,msisdn,create_date,status,(select dictname from bpm_dictitem where groupid='BP_STATUS' and dictid=a.status) statusname,status_date,remark from bpm_business_log a where REGEXP_LIKE(a.app_name, ?) and a.create_date between to_date(?,'yyyy-mm-dd') and to_date(?,'yyyy-mm-dd')+1 and REGEXP_LIKE(a.status, ?) and a.status != '-1'
#JDBC查询数据库时返回最大记录数[When query sql with jdbc, Return Max row number]
MAX_ROW = 10001
#操作WPS流程数据的安全用户/密码[The username and password of management WPS business flow]
WPS_SECURITY_USER = admin
WPS_SECURITY_PASS = admin
WPS_SECURITY_REALM = wpsRealm

#WPS权限认证SQL[WPS Authentication SQL Definition]
#CHECK_PASSWORD = select operid userid from operator where operid = ? and password = ?
#QUERY_USER_LIST = select operid userid,opername username from operator where REGEXP_LIKE(operid, ?) and status = 1 and rownum < ?
#QUERY_GROUP_LIST = select roleid groupid,rolename groupname from workgroup where REGEXP_LIKE(roleid, ?) and status = 1 and rownum < ?
#QUERY_GROUP_BYUSER = select roleid groupid from operator_workgroup where operid = ? and status = 1
#QUERY_USER_BYGROUP = select roleid groupid,operid userid from operator_workgroup where roleid = ? and status = 1 and rownum < ?

CHECK_PASSWORD = select userid from bpm_users where userid = ? and password = ?
QUERY_USER_LIST = select userid,username from bpm_users where REGEXP_LIKE(userid, ?) and status = 1 and rownum < ?
QUERY_GROUP_LIST = select groupid,groupname from bpm_groups where REGEXP_LIKE(groupid, ?) and status = 1 and rownum < ?
QUERY_GROUP_BYUSER = select groupid from bpm_user_group where userid = ? and status = 1
QUERY_USER_BYGROUP = select groupid,userid from bpm_user_group where groupid = ? and status = 1 and rownum < ?