nl.knowledgeplaza.util
Class JdbcUtil.SyncDescriptor

java.lang.Object
  nl.knowledgeplaza.util.JdbcUtil.SyncDescriptor

Enclosing class:

JdbcUtil

public static class JdbcUtil.SyncDescriptor
extends java.lang.Object

Class that provides all data needed for the synchronizeTableFullOneWay methods. The methods in this class can be overridden so it allows some tweaking (especially in the get..Values() methods that are used by the statements).

Field Summary

static java.lang.String	COMMITEVERY_PROPERTY_ID
static java.lang.String	FROMCONNECTION_PROPERTY_ID
static java.lang.String	FROMFIELDS_PROPERTY_ID
static java.lang.String	FROMKEYS_PROPERTY_ID
static java.lang.String	FROMTABLENAME_PROPERTY_ID
static java.lang.String	ID_PROPERTY_ID
static java.lang.String	TOCONNECTION_PROPERTY_ID
static java.lang.String	TOFIELDS_PROPERTY_ID
static java.lang.String	TOKEYS_PROPERTY_ID
static java.lang.String	TOTABLENAME_PROPERTY_ID

Constructor Summary

JdbcUtil.SyncDescriptor()

Method Summary

void	afterDelete()
void	afterInsertUpdate()
void	beforeDelete()
void	beforeInsertUpdate()
int	getCommitEvery() CommitEvery:
java.lang.String	getDeleteInToSql()
LinearMap<java.lang.String,java.lang.Object>	getDeleteInToValues(java.sql.ResultSet resultSet)
java.lang.String	getExistsInFromSql()
java.lang.String	getExistsInFromSql(java.lang.String whereclause)
LinearMap<java.lang.String,java.lang.Object>	getExistsInFromValues(java.sql.ResultSet resultSet)
java.lang.String	getExistsInToSql()
LinearMap<java.lang.String,java.lang.Object>	getExistsInToValues(java.sql.ResultSet resultSet)
java.sql.Connection	getFromConnection() FromConnection:
java.lang.String[]	getFromFields() FromFields:
LinearMap<java.lang.String,java.lang.Object>	getFromFieldValues(java.sql.ResultSet resultSet)
java.lang.String[]	getFromKeys() FromKeys:
LinearMap<java.lang.String,java.lang.Object>	getFromKeyValues(java.sql.ResultSet resultSet)
java.lang.String	getFromTablename() FromTablename:
java.lang.String	getId() Id:
java.lang.String	getInsertInToSql()
LinearMap<java.lang.String,java.lang.Object>	getInsertInToValues(java.sql.ResultSet resultSet)
java.lang.String	getSelectInFromSql()
java.lang.String	getSelectInFromSql(java.lang.String whereclause)
java.lang.String	getSelectInToSql()
java.lang.String	getSelectInToSql(java.lang.String whereclause)
java.sql.Connection	getToConnection() ToConnection:
java.lang.String[]	getToFields() ToFields:
LinearMap<java.lang.String,java.lang.Object>	getToFieldValues(java.sql.ResultSet resultSet)
java.lang.String[]	getToKeys() ToKeys:
LinearMap<java.lang.String,java.lang.Object>	getToKeyValues(java.sql.ResultSet resultSet)
java.lang.String	getToTablename() ToTablename:
java.lang.String	getUpdateInToSql()
LinearMap<java.lang.String,java.lang.Object>	getUpdateInToValues(java.sql.ResultSet resultSet)
void	setCommitEvery(int value)
void	setFromConnection(java.sql.Connection value)
void	setFromFields(java.lang.String... value)
void	setFromKeys(java.lang.String... value)
void	setFromTablename(java.lang.String value)
void	setId(java.lang.String value)
void	setToConnection(java.sql.Connection value)
void	setToFields(java.lang.String... value)
void	setToKeys(java.lang.String... value)
void	setToTablename(java.lang.String value)
JdbcUtil.SyncDescriptor	withCommitEvery(int value)
JdbcUtil.SyncDescriptor	withFromConnection(java.sql.Connection value)
JdbcUtil.SyncDescriptor	withFromFields(java.lang.String... value)
JdbcUtil.SyncDescriptor	withFromKeys(java.lang.String... value)
JdbcUtil.SyncDescriptor	withFromTablename(java.lang.String value)
JdbcUtil.SyncDescriptor	withId(java.lang.String value)
JdbcUtil.SyncDescriptor	withToConnection(java.sql.Connection value)
JdbcUtil.SyncDescriptor	withToFields(java.lang.String... value)
JdbcUtil.SyncDescriptor	withToKeys(java.lang.String... value)
JdbcUtil.SyncDescriptor	withToTablename(java.lang.String value)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ID_PROPERTY_ID

public static final java.lang.String ID_PROPERTY_ID

See Also:

Constant Field Values

FROMCONNECTION_PROPERTY_ID

public static final java.lang.String FROMCONNECTION_PROPERTY_ID

See Also:

Constant Field Values

FROMTABLENAME_PROPERTY_ID

public static final java.lang.String FROMTABLENAME_PROPERTY_ID

See Also:

Constant Field Values

FROMFIELDS_PROPERTY_ID

public static final java.lang.String FROMFIELDS_PROPERTY_ID

See Also:

Constant Field Values

FROMKEYS_PROPERTY_ID

public static final java.lang.String FROMKEYS_PROPERTY_ID

See Also:

Constant Field Values

TOCONNECTION_PROPERTY_ID

public static final java.lang.String TOCONNECTION_PROPERTY_ID

See Also:

Constant Field Values

TOTABLENAME_PROPERTY_ID

public static final java.lang.String TOTABLENAME_PROPERTY_ID

See Also:

Constant Field Values

TOFIELDS_PROPERTY_ID

public static final java.lang.String TOFIELDS_PROPERTY_ID

See Also:

Constant Field Values

TOKEYS_PROPERTY_ID

public static final java.lang.String TOKEYS_PROPERTY_ID

See Also:

Constant Field Values

COMMITEVERY_PROPERTY_ID

public static final java.lang.String COMMITEVERY_PROPERTY_ID

See Also:

Constant Field Values

Constructor Detail

JdbcUtil.SyncDescriptor

public JdbcUtil.SyncDescriptor()

Method Detail

getId

public java.lang.String getId()

Id:

setId

public void setId(java.lang.String value)

withId

public JdbcUtil.SyncDescriptor withId(java.lang.String value)

getFromConnection

public java.sql.Connection getFromConnection()

FromConnection:

setFromConnection

public void setFromConnection(java.sql.Connection value)

withFromConnection

public JdbcUtil.SyncDescriptor withFromConnection(java.sql.Connection value)

getFromTablename

public java.lang.String getFromTablename()

FromTablename:

setFromTablename

public void setFromTablename(java.lang.String value)

withFromTablename

public JdbcUtil.SyncDescriptor withFromTablename(java.lang.String value)

getFromFields

public java.lang.String[] getFromFields()

FromFields:

setFromFields

public void setFromFields(java.lang.String... value)

withFromFields

public JdbcUtil.SyncDescriptor withFromFields(java.lang.String... value)

getFromFieldValues

public LinearMap<java.lang.String,java.lang.Object> getFromFieldValues(java.sql.ResultSet resultSet)
                                                                throws java.sql.SQLException

Parameters:

resultSet -

Returns:

Throws:

java.sql.SQLException

getFromKeys

public java.lang.String[] getFromKeys()

FromKeys:

setFromKeys

public void setFromKeys(java.lang.String... value)

withFromKeys

public JdbcUtil.SyncDescriptor withFromKeys(java.lang.String... value)

getFromKeyValues

public LinearMap<java.lang.String,java.lang.Object> getFromKeyValues(java.sql.ResultSet resultSet)
                                                              throws java.sql.SQLException

Parameters:

resultSet -

Returns:

Throws:

java.sql.SQLException

getToConnection

public java.sql.Connection getToConnection()

ToConnection:

setToConnection

public void setToConnection(java.sql.Connection value)

withToConnection

public JdbcUtil.SyncDescriptor withToConnection(java.sql.Connection value)

getToTablename

public java.lang.String getToTablename()

ToTablename:

setToTablename

public void setToTablename(java.lang.String value)

withToTablename

public JdbcUtil.SyncDescriptor withToTablename(java.lang.String value)

getToFields

public java.lang.String[] getToFields()

ToFields:

setToFields

public void setToFields(java.lang.String... value)

withToFields

public JdbcUtil.SyncDescriptor withToFields(java.lang.String... value)

getToFieldValues

public LinearMap<java.lang.String,java.lang.Object> getToFieldValues(java.sql.ResultSet resultSet)
                                                              throws java.sql.SQLException

Parameters:

resultSet -

Returns:

Throws:

java.sql.SQLException

getToKeys

public java.lang.String[] getToKeys()

ToKeys:

setToKeys

public void setToKeys(java.lang.String... value)

withToKeys

public JdbcUtil.SyncDescriptor withToKeys(java.lang.String... value)

getToKeyValues

public LinearMap<java.lang.String,java.lang.Object> getToKeyValues(java.sql.ResultSet resultSet)
                                                            throws java.sql.SQLException

Parameters:

resultSet -

Returns:

Throws:

java.sql.SQLException

getSelectInFromSql

public java.lang.String getSelectInFromSql(java.lang.String whereclause)

Returns:

Throws:

java.sql.SQLException

getSelectInFromSql

public java.lang.String getSelectInFromSql()

getSelectInToSql

public java.lang.String getSelectInToSql(java.lang.String whereclause)

Returns:

Throws:

java.sql.SQLException

getSelectInToSql

public java.lang.String getSelectInToSql()

getExistsInToSql

public java.lang.String getExistsInToSql()

Returns:

Throws:

java.sql.SQLException

getExistsInToValues

public LinearMap<java.lang.String,java.lang.Object> getExistsInToValues(java.sql.ResultSet resultSet)
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getExistsInFromSql

public java.lang.String getExistsInFromSql(java.lang.String whereclause)

Returns:

Throws:

java.sql.SQLException

getExistsInFromSql

public java.lang.String getExistsInFromSql()

getExistsInFromValues

public LinearMap<java.lang.String,java.lang.Object> getExistsInFromValues(java.sql.ResultSet resultSet)
                                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getDeleteInToSql

public java.lang.String getDeleteInToSql()

Returns:

Throws:

java.sql.SQLException

getDeleteInToValues

public LinearMap<java.lang.String,java.lang.Object> getDeleteInToValues(java.sql.ResultSet resultSet)
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getInsertInToSql

public java.lang.String getInsertInToSql()

Returns:

Throws:

java.sql.SQLException

getInsertInToValues

public LinearMap<java.lang.String,java.lang.Object> getInsertInToValues(java.sql.ResultSet resultSet)
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpdateInToSql

public java.lang.String getUpdateInToSql()

Returns:

Throws:

java.sql.SQLException

getUpdateInToValues

public LinearMap<java.lang.String,java.lang.Object> getUpdateInToValues(java.sql.ResultSet resultSet)
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getCommitEvery

public int getCommitEvery()

CommitEvery:

setCommitEvery

public void setCommitEvery(int value)

withCommitEvery

public JdbcUtil.SyncDescriptor withCommitEvery(int value)

beforeInsertUpdate

public void beforeInsertUpdate()

afterInsertUpdate

public void afterInsertUpdate()

beforeDelete

public void beforeDelete()

afterDelete

public void afterDelete()