|
xmlBlaster 2.2.0 contributions API | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.xmlBlaster.contrib.replication.impl.SpecificDefault org.xmlBlaster.contrib.replication.impl.SpecificPostgres
public class SpecificPostgres
Field Summary |
---|
Fields inherited from class org.xmlBlaster.contrib.replication.impl.SpecificDefault |
---|
blockLoop, COMMIT_NO, COMMIT_YES, dbMetaHelper, dbPool, info, initialUpdater, isDbWriteable, replacer, replaceVariable, replPrefix, replVersion, ROLLBACK_NO, ROLLBACK_YES, transformer |
Fields inherited from interface org.xmlBlaster.contrib.replication.I_DbSpecific |
---|
NEEDS_PUBLISHER_KEY, WIPEOUT_ALL, WIPEOUT_FUNCTIONS, WIPEOUT_INDEXES, WIPEOUT_NO_TABLES, WIPEOUT_ONLY_TABLES, WIPEOUT_PACKAGES, WIPEOUT_PROCEDURES, WIPEOUT_SEQUENCES, WIPEOUT_SYNONYMS, WIPEOUT_TABLES, WIPEOUT_TRIGGERS, WIPEOUT_VIEWS |
Constructor Summary | |
---|---|
SpecificPostgres()
Not doing anything. |
Method Summary | |
---|---|
void |
addSchemaToWatch(java.sql.Connection conn,
java.lang.String catalog,
java.lang.String schema)
Adds a schema to be watched. |
java.lang.String |
createTableFunction(SqlDescription infoDescription,
java.lang.String functionName)
This method creates a function to be associated to a trigger to detect INSERT DELETE and UPDATE operations on a particular table. |
java.lang.String |
createTableTrigger(SqlDescription infoDescription,
TableToWatchInfo tableToWatch)
This method creates a trigger to detect INSERT DELETE and UPDATE operations on a particular table. |
protected java.lang.String |
createVariableSqlPart(SqlDescription description,
java.lang.String prefix)
|
java.lang.StringBuffer |
getColumnStatement(SqlColumn colInfoDescription)
Helper method used to construct the CREATE TABLE statement part belonging to a single COLUMN. |
java.lang.String |
getContentFromGuid(java.lang.String guid,
java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
I_AttributeTransformer transformer)
This is used for cases where it was not possible to retrieve the (new) content of an entry synchronously in the PL/SQL Code. |
boolean |
removeTrigger(java.lang.String triggerName,
java.lang.String tableName,
boolean isSchemaTrigger)
removes the specified trigger from the specified table. |
protected boolean |
sequenceExists(java.sql.Connection conn,
java.lang.String sequenceName)
returns true if the sequence exists already. |
protected boolean |
triggerExists(java.sql.Connection conn,
java.lang.String sequenceName)
returns true if the trigger exists already. |
boolean |
triggerExists(java.sql.Connection conn,
TableToWatchInfo tableToWatch)
Checks wether a trigger really exists or not. |
int |
wipeoutSchema(java.lang.String catalog,
java.lang.String schema,
boolean[] objectsToWipeout)
Cleans up the complete schema. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public SpecificPostgres()
Method Detail |
---|
public java.lang.StringBuffer getColumnStatement(SqlColumn colInfoDescription)
colInfoDescription
-
protected java.lang.String createVariableSqlPart(SqlDescription description, java.lang.String prefix)
col
- prefix
- can be 'old' or 'new'
public java.lang.String createTableFunction(SqlDescription infoDescription, java.lang.String functionName)
infoDescription
- the info object containing the necessary information for the
table.
public java.lang.String createTableTrigger(SqlDescription infoDescription, TableToWatchInfo tableToWatch)
infoDescription
- the info object containing the necessary information for the
table.
public void addSchemaToWatch(java.sql.Connection conn, java.lang.String catalog, java.lang.String schema) throws java.lang.Exception
catalog
- schema
-
java.lang.Exception
public boolean removeTrigger(java.lang.String triggerName, java.lang.String tableName, boolean isSchemaTrigger)
I_DbSpecific
isSchemaTrigger
- true if the trigger to be removed is a schema trigger.
public int wipeoutSchema(java.lang.String catalog, java.lang.String schema, boolean[] objectsToWipeout) throws java.lang.Exception
I_DbSpecific
objectsToWipeout
- a boolean[] array containing 9 elements telling wether the specified objects of a certain
type have to be wiped out or not. For the relationship between position and meaning see the static variables.
If you pass null here all object types are wiped out.
java.lang.Exception
public java.lang.String getContentFromGuid(java.lang.String guid, java.lang.String catalog, java.lang.String schema, java.lang.String table, I_AttributeTransformer transformer) throws java.lang.Exception
I_DbSpecific
guid
- the unique Id identifying this entry. This is needed. Can not be nullcatalog
- can be nullschema
- can be nulltable
- must be defined (can not be null).transformer
- An optional plugin
java.lang.Exception
org.xmlBlaster.contrib.replication.I_DbSpecific#getContentFromGuid(java.lang.String, java.lang.String, java.lang.String, java.lang.String)
protected boolean sequenceExists(java.sql.Connection conn, java.lang.String sequenceName) throws java.lang.Exception
sequenceExists
in class SpecificDefault
java.lang.Exception
protected boolean triggerExists(java.sql.Connection conn, java.lang.String sequenceName) throws java.lang.Exception
triggerExists
in class SpecificDefault
java.lang.Exception
public boolean triggerExists(java.sql.Connection conn, TableToWatchInfo tableToWatch) throws java.lang.Exception
I_DbSpecific
tableToWatch
- The object containing the table to be checked for trigger
java.lang.Exception
- If an exception occurs in the backend.org.xmlBlaster.contrib.replication.I_DbSpecific#triggerExists(org.xmlBlaster.contrib.replication.TableToWatchInfo)
|
xmlBlaster 2.2.0 contributions API | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |