public static class Consolidator.TemplateItemMetadata
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
java.lang.String |
cbk_name
A string specifying the callback package name.
|
java.lang.String |
cbk_owner
Specifies the callback package owner
|
java.lang.String |
columns
Specifies new names for all publication item columns.
|
boolean |
conf_res_only
Specifies if the attribute conflict_resolution_only of the publication item is true or not.
|
java.lang.String |
conflictRule
Conflict resolution rule type.
|
java.lang.String |
dmlProcedure
DML procedure of the publication item.
|
java.lang.String |
group_fnc
Name of a PL/SQL group function for this publication item.
|
boolean |
isShared
Specifies if the publication item is shared or not.
|
boolean |
isUpdatable
A boolean specifying if the publication item is updatable or not.
|
java.lang.String |
pmode
Specifies the refresh mode:
F for fast refresh, C for complete refresh, Q for Queue-based publication item.
|
java.lang.String |
pubItem
Specifies publication item name.
|
java.lang.String |
resPredicate
restricting-predicate A restricting predicate can be assigned to a publication
item as it is added to a publication.
|
java.lang.String |
template
Specifies publication name.
|
int |
weight
Table weight is an integer property of association between publications and publication items.
|
Constructor and Description |
---|
Consolidator.TemplateItemMetadata(java.lang.String template,
java.lang.String pubItem,
java.lang.String columns,
java.lang.String disabled_dml,
java.lang.String resPredicate,
int weight,
java.lang.String conflictRule,
java.lang.String dmlProcedure,
java.lang.String dml_proc_type,
java.lang.String shared,
java.lang.String group_fnc,
java.lang.String pmode,
java.lang.String cbk_owner,
java.lang.String cbk_name) |
public java.lang.String cbk_name
public java.lang.String cbk_owner
public java.lang.String columns
public boolean conf_res_only
public java.lang.String conflictRule
S defines the server as the winner in conflict resolution. Default setting. C Defines the client as the winner in conflict resolution.
public java.lang.String dmlProcedure
public java.lang.String group_fnc
( CLIENT in VARCHAR2, PUBLICATION in VARCHAR2, ITEM in VARCHAR2 ) return VARCHAR2.The returned value should uniquely identify client's group. For example, if client A belongs to group GroupA and client B belongs to group GroupB, the group function F could return:
F ('A','SUBSCRIPTION','PI_NAME') = 'GroupA' F ('B','SUBSCRIPTION','PI_NAME') = 'GroupB'The implicit assumption of the grouping function is that all the members of GroupA group share the same data. The same is true for the clients in GroupB. The use of group function is to uniquely identify a group of users with the same data for a particular PUBLICATION ITEM. An example of a grouping function that groups employees by their departments is:
Function GET_EMP_GROUP_ID (
clientid in varchar2,
publication in varchar2,
item in varchar2
) return varchar2 is
group_val_id varchar2(30);
begin
select DEPTNO into group_val_id
from EMP where EMPNO = clientid;
return group_val_id;
end;
NOTE: this function assumes that EMPNO is the Consolidator clientid.
If the group_fnc is not specified, the default grouping is based on subscription parameters.public boolean isShared
public boolean isUpdatable
public java.lang.String pmode
public java.lang.String pubItem
public java.lang.String resPredicate
public java.lang.String template
public int weight
INSERT operations are executed first, from lowest to highest table weight order. DELETE operations are executed next, from highest to lowest table weight order. UPDATE operations are executed last, from lowest to highest table weight order.
public Consolidator.TemplateItemMetadata(java.lang.String template, java.lang.String pubItem, java.lang.String columns, java.lang.String disabled_dml, java.lang.String resPredicate, int weight, java.lang.String conflictRule, java.lang.String dmlProcedure, java.lang.String dml_proc_type, java.lang.String shared, java.lang.String group_fnc, java.lang.String pmode, java.lang.String cbk_owner, java.lang.String cbk_name)
public java.lang.String toString()
toString
in class java.lang.Object
public void validate(java.sql.Connection conn) throws java.lang.Throwable
java.lang.Throwable