oracle.lite.sync

Class Consolidator.PubItemProps

java.lang.Object

oracle.lite.sync.Consolidator.PubItemProps

Enclosing class:

Consolidator

public static class Consolidator.PubItemProps
extends java.lang.Object

Specifies properties of a publication item.

See Also:

ConsolidatorManager.createPublicationItem(String name, Consolidator.PubItemProps pi_props)

Field Summary

Fields

Modifier and Type	Field and Description
java.lang.String	cbk_name Specifies the callback package name.
java.lang.String	cbk_owner Specifies the callback package owner.
java.lang.String	cl2log_rec_stmt client sub-query that correlates primary key of the changed records in the log table with consolidator clientid.
boolean	createQPubItemEQ If true and the publication item is Queue type, will create default error queue
java.lang.String	db_inst Specifies the database name against which the pub-item is to be defined i.e. a registered app database name or Consolidator.MAIN_DB for the MAIN database.
boolean	doChangeNtf If true, log based (automatic) publication item will send notifications from server about new/modified records
boolean	isLogBased If true, log based (automatic) publication item will be created
java.lang.String	owner Specifies the synonym owner.
java.lang.String	pk_columns A string specifying the primary keys of a queue based publication item.
java.lang.String	refresh_mode A string specifying the refresh mode: F for fast refresh, C for complete refresh, Q for Queue-based publication item.
java.sql.Connection	rmt_conn A JDBC connection to the remote database where the base object of the synonym resides.
java.lang.String	select_stmt A Specifies a (possibly parameterized) select statement for the new publication item.
boolean	setDfltColOptions If true, default values and not null constraints are replicated to the client
java.lang.String	store Specifies the synonym name.

Constructor Summary

Constructors

Constructor and Description
Consolidator.PubItemProps()

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	toString()

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

cbk_name

public java.lang.String cbk_name

Specifies the callback package name. May be null. This parameter is for advanced use.

cbk_owner

public java.lang.String cbk_owner

Specifies the callback package owner. May be null. This parameter is for advanced use.

cl2log_rec_stmt

public java.lang.String cl2log_rec_stmt

client sub-query that correlates primary key of the changed records in the log table with consolidator clientid.

 For example
 Publication item query is:
 
   SELECT * 
   FROM scott.emp a
   WHERE deptno in
       (select deptno
        from scott.emp b
        where b.empno = :empno )
 
 Assuming that consolidator client id is empno, the client sub-query would be:
 
   SELECT empno as clid$$cs
   FROM scott.clg$emp
   UNION
   SELECT empno as clid$$cs
   FROM scott.emp
   WHERE deptno in
       (select deptno 
       from scott.clg$dept)
 

It's required for the client sub-query to return unique clientids.

createQPubItemEQ

public boolean createQPubItemEQ

If true and the publication item is Queue type, will create default error queue

db_inst

public java.lang.String db_inst

Specifies the database name against which the pub-item is to be defined i.e. a registered app database name or Consolidator.MAIN_DB for the MAIN database. The default is the MAIN database.

doChangeNtf

public boolean doChangeNtf

If true, log based (automatic) publication item will send notifications from server about new/modified records

isLogBased

public boolean isLogBased

If true, log based (automatic) publication item will be created

owner

public java.lang.String owner

Specifies the synonym owner.

pk_columns

public java.lang.String pk_columns

A string specifying the primary keys of a queue based publication item.

refresh_mode

public java.lang.String refresh_mode

A string specifying the refresh mode: F for fast refresh, C for complete refresh, Q for Queue-based publication item. The default is fast refresh.

rmt_conn

public java.sql.Connection rmt_conn

A JDBC connection to the remote database where the base object of the synonym resides. Do not set this parameter if you are using the repository separation feature to define a pub-item against an app database. This parameter is for the older DB link support only.

select_stmt

public java.lang.String select_stmt

A Specifies a (possibly parameterized) select statement for the new publication item.

setDfltColOptions

public boolean setDfltColOptions

If true, default values and not null constraints are replicated to the client

store

public java.lang.String store

Specifies the synonym name.

Constructor Detail

Consolidator.PubItemProps

public Consolidator.PubItemProps()

Method Detail

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object