nl.knowledgeplaza.util
Class JdbcUtil.SyncDescriptor

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

Enclosing class:

JdbcUtil

public static class JdbcUtil.SyncDescriptor
extends 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 String	COMMITEVERY_PROPERTY_ID
static String	FROMCONNECTION_PROPERTY_ID
static String	FROMFIELDS_PROPERTY_ID
static String	FROMKEYS_PROPERTY_ID
static String	FROMTABLENAME_PROPERTY_ID
static String	ID_PROPERTY_ID
static String	TOCONNECTION_PROPERTY_ID
static String	TOFIELDS_PROPERTY_ID
static String	TOKEYS_PROPERTY_ID
static String	TOTABLENAME_PROPERTY_ID

Constructor Summary

JdbcUtil.SyncDescriptor()

Method Summary

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

See Also:

Constant Field Values

FROMCONNECTION_PROPERTY_ID

public static final String FROMCONNECTION_PROPERTY_ID

See Also:

Constant Field Values

FROMTABLENAME_PROPERTY_ID

public static final String FROMTABLENAME_PROPERTY_ID

See Also:

Constant Field Values

FROMFIELDS_PROPERTY_ID

public static final String FROMFIELDS_PROPERTY_ID

See Also:

Constant Field Values

FROMKEYS_PROPERTY_ID

public static final String FROMKEYS_PROPERTY_ID

See Also:

Constant Field Values

TOCONNECTION_PROPERTY_ID

public static final String TOCONNECTION_PROPERTY_ID

See Also:

Constant Field Values

TOTABLENAME_PROPERTY_ID

public static final String TOTABLENAME_PROPERTY_ID

See Also:

Constant Field Values

TOFIELDS_PROPERTY_ID

public static final String TOFIELDS_PROPERTY_ID

See Also:

Constant Field Values

TOKEYS_PROPERTY_ID

public static final String TOKEYS_PROPERTY_ID

See Also:

Constant Field Values

COMMITEVERY_PROPERTY_ID

public static final String COMMITEVERY_PROPERTY_ID

See Also:

Constant Field Values

Constructor Detail

JdbcUtil.SyncDescriptor

public JdbcUtil.SyncDescriptor()

Method Detail

getId

public String getId()

Id:

setId

public void setId(String value)

withId

public JdbcUtil.SyncDescriptor withId(String value)

getFromConnection

public Connection getFromConnection()

FromConnection:

setFromConnection

public void setFromConnection(Connection value)

withFromConnection

public JdbcUtil.SyncDescriptor withFromConnection(Connection value)

getFromTablename

public String getFromTablename()

FromTablename:

setFromTablename

public void setFromTablename(String value)

withFromTablename

public JdbcUtil.SyncDescriptor withFromTablename(String value)

getFromFields

public String[] getFromFields()

FromFields:

setFromFields

public void setFromFields(String... value)

withFromFields

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

getFromFieldValues

public LinearMap<String,Object> getFromFieldValues(ResultSet resultSet)
                                            throws SQLException

Parameters:

resultSet -

Returns:

Throws:

SQLException

getFromKeys

public String[] getFromKeys()

FromKeys:

setFromKeys

public void setFromKeys(String... value)

withFromKeys

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

getFromKeyValues

public LinearMap<String,Object> getFromKeyValues(ResultSet resultSet)
                                          throws SQLException

Parameters:

resultSet -

Returns:

Throws:

SQLException

getToConnection

public Connection getToConnection()

ToConnection:

setToConnection

public void setToConnection(Connection value)

withToConnection

public JdbcUtil.SyncDescriptor withToConnection(Connection value)

getToTablename

public String getToTablename()

ToTablename:

setToTablename

public void setToTablename(String value)

withToTablename

public JdbcUtil.SyncDescriptor withToTablename(String value)

getToFields

public String[] getToFields()

ToFields:

setToFields

public void setToFields(String... value)

withToFields

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

getToFieldValues

public LinearMap<String,Object> getToFieldValues(ResultSet resultSet)
                                          throws SQLException

Parameters:

resultSet -

Returns:

Throws:

SQLException

getToKeys

public String[] getToKeys()

ToKeys:

setToKeys

public void setToKeys(String... value)

withToKeys

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

getToKeyValues

public LinearMap<String,Object> getToKeyValues(ResultSet resultSet)
                                        throws SQLException

Parameters:

resultSet -

Returns:

Throws:

SQLException

getSelectInFromSql

public String getSelectInFromSql(String whereclause)

Returns:

Throws:

SQLException

getSelectInFromSql

public String getSelectInFromSql()

getSelectInToSql

public String getSelectInToSql(String whereclause)

Returns:

Throws:

SQLException

getSelectInToSql

public String getSelectInToSql()

getExistsInToSql

public String getExistsInToSql()

Returns:

Throws:

SQLException

getExistsInToValues

public LinearMap<String,Object> getExistsInToValues(ResultSet resultSet)
                                             throws SQLException

Throws:

SQLException

getExistsInFromSql

public String getExistsInFromSql(String whereclause)

Returns:

Throws:

SQLException

getExistsInFromSql

public String getExistsInFromSql()

getExistsInFromValues

public LinearMap<String,Object> getExistsInFromValues(ResultSet resultSet)
                                               throws SQLException

Throws:

SQLException

getDeleteInToSql

public String getDeleteInToSql()

Returns:

Throws:

SQLException

getDeleteInToValues

public LinearMap<String,Object> getDeleteInToValues(ResultSet resultSet)
                                             throws SQLException

Throws:

SQLException

getInsertInToSql

public String getInsertInToSql()

Returns:

Throws:

SQLException

getInsertInToValues

public LinearMap<String,Object> getInsertInToValues(ResultSet resultSet)
                                             throws SQLException

Throws:

SQLException

getUpdateInToSql

public String getUpdateInToSql()

Returns:

Throws:

SQLException

getUpdateInToValues

public LinearMap<String,Object> getUpdateInToValues(ResultSet resultSet)
                                             throws SQLException

Throws:

SQLException

getCommitEvery

public int getCommitEvery()

CommitEvery:

setCommitEvery

public void setCommitEvery(int value)

withCommitEvery

public JdbcUtil.SyncDescriptor withCommitEvery(int value)

beforeInsertUpdate

public void beforeInsertUpdate()
                        throws SQLException

Throws:

SQLException

afterInsertUpdate

public void afterInsertUpdate()
                       throws SQLException

Throws:

SQLException

beforeDelete

public void beforeDelete()
                  throws SQLException

Throws:

SQLException

afterDelete

public void afterDelete()
                 throws SQLException

Throws:

SQLException

beforeDeleteRecord

public void beforeDeleteRecord(LinearMap<String,Object> resultset)
                        throws SQLException

Throws:

SQLException

afterDeleteRecord

public void afterDeleteRecord(LinearMap<String,Object> resultset)
                       throws SQLException

Throws:

SQLException