org.julp.db

Class PKCache

java.lang.Object

org.julp.db.PKCache

All Implemented Interfaces:

java.io.Serializable

public class PKCache
extends java.lang.Object
implements java.io.Serializable

Retrieves and caches PrimaryKeys from DatabaseMetaData or user input

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected java.util.Map<java.lang.String,java.util.Set<java.lang.String>>	pkCache Key for each table

Method Summary

Modifier and Type	Method and Description
static PKCache	getInstance()
java.util.Set<java.lang.String>	getPrimaryKey(java.sql.Connection connection, java.lang.String catalog, java.lang.String schema, java.lang.String table) Retrieves PK from DatabaseMetaData and put it in cache.
java.util.Set<java.lang.String>	getPrimaryKey(java.lang.String catalog, java.lang.String schema, java.lang.String table) Retrieves PK from cache.
java.util.Set<java.lang.String>	populatePrimaryKey(java.sql.Connection connection, java.lang.String catalog, java.lang.String schema, java.lang.String table, java.util.Set<java.lang.String> additionalColumns) Retrieves PK from DatabaseMetaData, add additional columns to it and put it in cache
java.util.Set<java.lang.String>	populatePrimaryKey(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.util.Set<java.lang.String> additionalColumns) Retrieves PK from cache, add additional columns to it and put it in cache.
void	setPrimaryKey(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.util.Set<java.lang.String> pk)

Methods inherited from class java.lang.Object

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

Field Detail

pkCache

protected java.util.Map<java.lang.String,java.util.Set<java.lang.String>> pkCache

Key for each table

Method Detail

getInstance

public static PKCache getInstance()

setPrimaryKey

public void setPrimaryKey(java.lang.String catalog,
                          java.lang.String schema,
                          java.lang.String table,
                          java.util.Set<java.lang.String> pk)

populatePrimaryKey

public java.util.Set<java.lang.String> populatePrimaryKey(java.lang.String catalog,
                                                          java.lang.String schema,
                                                          java.lang.String table,
                                                          java.util.Set<java.lang.String> additionalColumns)

Retrieves PK from cache, add additional columns to it and put it in cache. If PK is not in cache returns null

populatePrimaryKey

public java.util.Set<java.lang.String> populatePrimaryKey(java.sql.Connection connection,
                                                          java.lang.String catalog,
                                                          java.lang.String schema,
                                                          java.lang.String table,
                                                          java.util.Set<java.lang.String> additionalColumns)

Retrieves PK from DatabaseMetaData, add additional columns to it and put it in cache

getPrimaryKey

public java.util.Set<java.lang.String> getPrimaryKey(java.lang.String catalog,
                                                     java.lang.String schema,
                                                     java.lang.String table)

Retrieves PK from cache. If PK is not in cache returns null

getPrimaryKey

public java.util.Set<java.lang.String> getPrimaryKey(java.sql.Connection connection,
                                                     java.lang.String catalog,
                                                     java.lang.String schema,
                                                     java.lang.String table)

Retrieves PK from DatabaseMetaData and put it in cache. If PK is in cache returns PK from cache