Modifier and Type	Class and Description
public static class	DeferredConstraintsMemory.CheckInfo Info needed for check constraints
private static class	DeferredConstraintsMemory.ForeignKeyInfo
private static class	DeferredConstraintsMemory.UniquePkInfo Info needed for unique and primary key constraints
public abstract static class	DeferredConstraintsMemory.ValidationInfo Class hierarchy carrying the information we need to validate some deferred constraint.

Access	Constructor and Description
public	DeferredConstraintsMemory()

Method Summary

Modifier and Type	Method and Description
public static void	compressOrTruncate(LanguageConnectionContext lcc, UUID tableId, String tableName)
public static Enumeration<Object>	getDeferredCheckConstraintLocations(Activation activation, UUID validatingBaseTableUUID)
private static BackingStoreHashtable	makeDeferredHashTable(final TransactionController tc, final int cols)
public static BackingStoreHashtable	Returns: the hash table (for caching by client to minimize lookups) rememberCheckViolations(final LanguageConnectionContext the language connection context lcc, UUID the id of the target table basetableId, final String the schema of the target table schemaName, final String the target table name tableName, BackingStoreHashtable client cached value deferredCheckViolations, final List<UUID> offending constraint(s) violatingCheckConstraints, final RowLocation the duplicate row to be saved in the hash table for later checking offendingRow, DeferredConstraintsMemory.CheckInfo[] OUT parameter: the allocated CheckInfo result) Save the row location of an offending row (one or more check constraints were violated) in a hash table (which may spill to disk) for later checking, typically on transaction commit, or upon request.
public static BackingStoreHashtable	Returns: the hash table (for caching by client to minimize lookups) rememberDuplicate(final LanguageConnectionContext the language connection context lcc, BackingStoreHashtable client cached value deferredRowsHashTable, UUID the id of the unique or primary key constraint constraintId, final DataValueDescriptor[] the duplicate row to be saved in the hash table for later checking insertRow) Save the contents of an constraint supporting index row in a hash table (which may spill to disk) for later checking, typically on transaction commit, or upon request.
public static BackingStoreHashtable	Returns: value to cache rememberFKViolation(final LanguageConnectionContext the language connection context lcc, BackingStoreHashtable cached client copy deferredRowsHashTable, final UUID the UUID of the foreign key constraint fkId, final DataValueDescriptor[] the row in the supporting index which contains the key which is not present in the referenced index. indexRow, String the schema of the table schemaName, String the table being modified that has a FK. tableName) Make note of a violated foreign key constraint, i.e. the referenced key is not present

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Detail

DeferredConstraintsMemory	back to summary
public DeferredConstraintsMemory()

Method Detail

compressOrTruncate	back to summary
public static void compressOrTruncate(LanguageConnectionContext lcc, UUID tableId, String tableName) throws StandardException

getDeferredCheckConstraintLocations	back to summary
public static Enumeration<Object> getDeferredCheckConstraintLocations(Activation activation, UUID validatingBaseTableUUID) throws StandardException

makeDeferredHashTable	back to summary
private static BackingStoreHashtable makeDeferredHashTable(final TransactionController tc, final int cols) throws StandardException

rememberCheckViolations back to summary

rememberCheckViolations	back to summary
public static BackingStoreHashtable rememberCheckViolations(final LanguageConnectionContext lcc, UUID basetableId, final String schemaName, final String tableName, BackingStoreHashtable deferredCheckViolations, final List<UUID> violatingCheckConstraints, final RowLocation offendingRow, DeferredConstraintsMemory.CheckInfo[] result) throws StandardException Save the row location of an offending row (one or more check constraints were violated) in a hash table (which may spill to disk) for later checking, typically on transaction commit, or upon request. The row locations are subject to invalidation, cf. `CheckInfo#setInvalidatedRowLocations`. Parameters lcc:LanguageConnectionContext the language connection context basetableId:UUID the id of the target table schemaName:String the schema of the target table tableName:String the target table name deferredCheckViolations:BackingStoreHashtable client cached value violatingCheckConstraints:List<UUID> offending constraint(s) offendingRow:RowLocation the duplicate row to be saved in the hash table for later checking result:DeferredConstraintsMemory.CheckInfo[] OUT parameter: the allocated CheckInfo Returns:BackingStoreHashtable the hash table (for caching by client to minimize lookups) Exceptions StandardException: standard error policy

public static BackingStoreHashtable rememberCheckViolations(final LanguageConnectionContext lcc, UUID basetableId, final String schemaName, final String tableName, BackingStoreHashtable deferredCheckViolations, final List<UUID> violatingCheckConstraints, final RowLocation offendingRow, DeferredConstraintsMemory.CheckInfo[] result) throws StandardException

Save the row location of an offending row (one or more check constraints were violated) in a hash table (which may spill to disk) for later checking, typically on transaction commit, or upon request. The row locations are subject to invalidation, cf. CheckInfo#setInvalidatedRowLocations.

Parameters

lcc:LanguageConnectionContext: the language connection context
basetableId:UUID: the id of the target table
schemaName:String: the schema of the target table
tableName:String: the target table name
deferredCheckViolations:BackingStoreHashtable: client cached value
violatingCheckConstraints:List<UUID>: offending constraint(s)
offendingRow:RowLocation: the duplicate row to be saved in the hash table for later checking
result:DeferredConstraintsMemory.CheckInfo[]: OUT parameter: the allocated CheckInfo

Returns:BackingStoreHashtable

the hash table (for caching by client to minimize lookups)

Exceptions

StandardException:: standard error policy

rememberDuplicate	back to summary
public static BackingStoreHashtable rememberDuplicate(final LanguageConnectionContext lcc, BackingStoreHashtable deferredRowsHashTable, UUID constraintId, final DataValueDescriptor[] insertRow) throws StandardException Save the contents of an constraint supporting index row in a hash table (which may spill to disk) for later checking, typically on transaction commit, or upon request. Parameters lcc:LanguageConnectionContext the language connection context deferredRowsHashTable:BackingStoreHashtable client cached value constraintId:UUID the id of the unique or primary key constraint insertRow:DataValueDescriptor[] the duplicate row to be saved in the hash table for later checking Returns:BackingStoreHashtable the hash table (for caching by client to minimize lookups) Exceptions StandardException: standard error policy

rememberDuplicate

back to summary

public static BackingStoreHashtable rememberDuplicate(final LanguageConnectionContext lcc, BackingStoreHashtable deferredRowsHashTable, UUID constraintId, final DataValueDescriptor[] insertRow) throws StandardException

Save the contents of an constraint supporting index row in a hash table (which may spill to disk) for later checking, typically on transaction commit, or upon request.

Parameters

lcc:LanguageConnectionContext: the language connection context
deferredRowsHashTable:BackingStoreHashtable: client cached value
constraintId:UUID: the id of the unique or primary key constraint
insertRow:DataValueDescriptor[]: the duplicate row to be saved in the hash table for later checking

Returns:BackingStoreHashtable

the hash table (for caching by client to minimize lookups)

Exceptions

StandardException:: standard error policy

rememberFKViolation	back to summary
public static BackingStoreHashtable rememberFKViolation(final LanguageConnectionContext lcc, BackingStoreHashtable deferredRowsHashTable, final UUID fkId, final DataValueDescriptor[] indexRow, String schemaName, String tableName) throws StandardException Make note of a violated foreign key constraint, i.e. the referenced key is not present Parameters lcc:LanguageConnectionContext the language connection context deferredRowsHashTable:BackingStoreHashtable cached client copy fkId:UUID the UUID of the foreign key constraint indexRow:DataValueDescriptor[] the row in the supporting index which contains the key which is not present in the referenced index. schemaName:String the schema of the table tableName:String the table being modified that has a FK. Returns:BackingStoreHashtable value to cache

rememberFKViolation

back to summary

public static BackingStoreHashtable rememberFKViolation(final LanguageConnectionContext lcc, BackingStoreHashtable deferredRowsHashTable, final UUID fkId, final DataValueDescriptor[] indexRow, String schemaName, String tableName) throws StandardException

Make note of a violated foreign key constraint, i.e. the referenced key is not present

Parameters

lcc:LanguageConnectionContext: the language connection context
deferredRowsHashTable:BackingStoreHashtable: cached client copy
fkId:UUID: the UUID of the foreign key constraint
indexRow:DataValueDescriptor[]: the row in the supporting index which contains the key which is not present in the referenced index.
schemaName:String: the schema of the table
tableName:String: the table being modified that has a FK.

Returns:BackingStoreHashtable

value to cache

org.apache.derby.impl.sql.execute back to summary

public Class DeferredConstraintsMemory.CheckInfo

Class Inheritance

extends ValidationInfo

java.lang.Object
org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo
org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.CheckInfo

Info needed for check constraints

Field Summary

Modifier and Type	Field and Description
private List<UUID>	culprits
private boolean	invalidatedDueToCompress
private final String	schemaName
private final String	tableName

Inherited from org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo:: infoRows

Constructor Summary

Access	Constructor and Description
public	CheckInfo(final BackingStoreHashtable infoRows, final String schemaName, final String tableName, final List<UUID> culprits)

Method Summary

Modifier and Type	Method and Description
public void	addCulprits(List<UUID> newCulprits)
public List<UUID>	getCulprints()
public boolean	isInvalidated()
public void	possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn.
public void	setInvalidatedRowLocations()
private void	validateCheck(final LanguageConnectionContext lcc, final UUID constraintId, final boolean rollbackOnError)
public final void	validateConstraint(LanguageConnectionContext The language connection context lcc, UUID If not `null`, check only for this constraint. This is used when switching mode to immediate. If `null`, we check all check constraints, i.e. at commit or if we have `SET CONSTRAINT ALL IMMEDIATE`. constraintId, boolean If `true` and a violation occurs, throw and exception that will cause rollback. rollbackOnError) Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint. Validate one or more CHECK constraints on a table.

Field Detail

culprits	back to summary
private List<UUID> culprits

invalidatedDueToCompress	back to summary
private boolean invalidatedDueToCompress

schemaName	back to summary
private final String schemaName

tableName	back to summary
private final String tableName

Constructor Detail

CheckInfo	back to summary
public CheckInfo(final BackingStoreHashtable infoRows, final String schemaName, final String tableName, final List<UUID> culprits)

Method Detail

addCulprits	back to summary
public void addCulprits(List<UUID> newCulprits)

getCulprints	back to summary
public List<UUID> getCulprints()

isInvalidated	back to summary
public boolean isInvalidated()

possiblyValidateOnReturn	back to summary
public void possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) throws StandardException Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn. Annotations @Override

possiblyValidateOnReturn

back to summary

public void possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) throws StandardException

Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn.

Annotations

@Override

setInvalidatedRowLocations	back to summary
public void setInvalidatedRowLocations()

validateCheck	back to summary
private void validateCheck(final LanguageConnectionContext lcc, final UUID constraintId, final boolean rollbackOnError) throws StandardException

validateConstraint back to summary

validateConstraint	back to summary
public final void validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError) throws StandardException Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint. Validate one or more CHECK constraints on a table. Implementation Note We remember violations for a row by storing its row location in a disk based hash table, similar to what we do for the index location for primary key and unique constraints. As far as which constraints caused which violations, constraints are only presently remembered as having caused "one or more violations", i.e. for any violating row, we do not know at checking time exactly which constraint caused a problem for that exact row. So, for any given constraint which was violated in the transaction we visit all rows which had one or more violations and check again. This could be improved upon by remembering for each violating row the exact set of constraint(s) that saw a violation. Still, this is much faster than a full table scan in most use cases. We use a special internal query option to achieve this. The row locations may not be usable if Derby does a compress or otherwise makes them invalid. In that case we resort to a full table scan. Parameters lcc:LanguageConnectionContext The language connection context constraintId:UUID If not `null`, check only for this constraint. This is used when switching mode to immediate. If `null`, we check all check constraints, i.e. at commit or if we have `SET CONSTRAINT ALL IMMEDIATE`. rollbackOnError:boolean If `true` and a violation occurs, throw and exception that will cause rollback. Annotations @Override Exceptions StandardException: Default error policy See Also `ValidateCheckConstraintResultSet`

public final void validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError) throws StandardException

Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint.

Validate one or more CHECK constraints on a table.

Implementation Note

We remember violations for a row by storing its row location in a disk based hash table, similar to what we do for the index location for primary key and unique constraints. As far as which constraints caused which violations, constraints are only presently remembered as having caused "one or more violations", i.e. for any violating row, we do not know at checking time exactly which constraint caused a problem for that exact row. So, for any given constraint which was violated in the transaction we visit all rows which had one or more violations and check again. This could be improved upon by remembering for each violating row the exact set of constraint(s) that saw a violation. Still, this is much faster than a full table scan in most use cases. We use a special internal query option to achieve this. The row locations may not be usable if Derby does a compress or otherwise makes them invalid. In that case we resort to a full table scan.

Parameters

lcc:LanguageConnectionContext: The language connection context
constraintId:UUID: If not null, check only for this constraint. This is used when switching mode to immediate. If null, we check all check constraints, i.e. at commit or if we have SET CONSTRAINT ALL IMMEDIATE.
rollbackOnError:boolean: If true and a violation occurs, throw and exception that will cause rollback.

Annotations

@Override

Exceptions

StandardException:: Default error policy

See Also

ValidateCheckConstraintResultSet

org.apache.derby.impl.sql.execute back to summary

private Class DeferredConstraintsMemory.ForeignKeyInfo

Class Inheritance

extends ValidationInfo

java.lang.Object
org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo
org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ForeignKeyInfo

Field Summary

Modifier and Type	Field and Description
private final UUID	fkId the UUID of the foreign constraint
private final String	schemaName
private final String	tableName

Inherited from org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo:: infoRows

Constructor Summary

Access	Constructor and Description
public	ForeignKeyInfo(final BackingStoreHashtable infoRows, UUID fkId, String schemaName, String tableName)

Method Summary

Modifier and Type	Method and Description
public UUID	getFkId()
public void	possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn.
public final void	validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError) Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint.
private void	validateForeignKey(LanguageConnectionContext lcc, boolean rollbackOnError)

Field Detail

fkId	back to summary
private final UUID fkId the UUID of the foreign constraint

schemaName	back to summary
private final String schemaName

tableName	back to summary
private final String tableName

Constructor Detail

ForeignKeyInfo	back to summary
public ForeignKeyInfo(final BackingStoreHashtable infoRows, UUID fkId, String schemaName, String tableName)

Method Detail

getFkId	back to summary
public UUID getFkId()

possiblyValidateOnReturn	back to summary
public void possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) throws StandardException Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn. Annotations @Override

possiblyValidateOnReturn

back to summary

public void possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) throws StandardException

Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn.

Annotations

@Override

validateConstraint	back to summary
public final void validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError) throws StandardException Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint. Annotations @Override

validateConstraint

back to summary

public final void validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError) throws StandardException

Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint.

Annotations

@Override

validateForeignKey	back to summary
private void validateForeignKey(LanguageConnectionContext lcc, boolean rollbackOnError) throws StandardException

org.apache.derby.impl.sql.execute back to summary

private Class DeferredConstraintsMemory.UniquePkInfo

Class Inheritance

extends ValidationInfo

java.lang.Object
org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo
org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.UniquePkInfo

Info needed for unique and primary key constraints

Field Summary

Modifier and Type	Field and Description
private final UUID	constraintId

Inherited from org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo:: infoRows

Constructor Summary

Access	Constructor and Description
public	UniquePkInfo(BackingStoreHashtable infoRows, UUID constraintId)

Method Summary

Modifier and Type	Method and Description
public final void	possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn.
public final void	validateConstraint(LanguageConnectionContext The language connection context lcc, UUID Not used by this constraint type constraintId, boolean `true` if we should roll back the transaction if we see a violation of the constraint rollbackOnError) Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint. Validate one primary key or unique constraint
private void	validateUniquePK(final LanguageConnectionContext lcc, final BackingStoreHashtable ht, final boolean rollbackOnError)

Field Detail

constraintId	back to summary
private final UUID constraintId

Constructor Detail

UniquePkInfo	back to summary
public UniquePkInfo(BackingStoreHashtable infoRows, UUID constraintId)

Method Detail

possiblyValidateOnReturn	back to summary
public final void possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) throws StandardException Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn. Annotations @Override

possiblyValidateOnReturn

back to summary

public final void possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) throws StandardException

Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.possiblyValidateOnReturn.

Annotations

@Override

validateConstraint back to summary

validateConstraint	back to summary
public final void validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError) throws StandardException Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint. Validate one primary key or unique constraint Parameters lcc:LanguageConnectionContext The language connection context constraintId:UUID Not used by this constraint type rollbackOnError:boolean `true` if we should roll back the transaction if we see a violation of the constraint Annotations @Override

public final void validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError) throws StandardException

Implements abstract org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo.validateConstraint.

Validate one primary key or unique constraint

Parameters

lcc:LanguageConnectionContext: The language connection context
constraintId:UUID: Not used by this constraint type
rollbackOnError:boolean: true if we should roll back the transaction if we see a violation of the constraint

Annotations

@Override

validateUniquePK	back to summary
private void validateUniquePK(final LanguageConnectionContext lcc, final BackingStoreHashtable ht, final boolean rollbackOnError) throws StandardException

org.apache.derby.impl.sql.execute back to summary

public abstract Class DeferredConstraintsMemory.ValidationInfo

Class Inheritance

extends Object

java.lang.Object
org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ValidationInfo

Known Direct Subclasses

org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.UniquePkInfo, org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.CheckInfo, org.apache.derby.impl.sql.execute.DeferredConstraintsMemory.ForeignKeyInfo

Class hierarchy carrying the information we need to validate some deferred constraint. For unique and primary key constraints, we only need the index row. For check constraints we need the target table name, schema name and some other info also.

Field Summary

Modifier and Type	Field and Description
public final BackingStoreHashtable	infoRows

Constructor Summary

Access	Constructor and Description
public	ValidationInfo(final BackingStoreHashtable infoRows)

Method Summary

Modifier and Type	Method and Description
public abstract void	possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller)
public abstract void	validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

infoRows	back to summary
public final BackingStoreHashtable infoRows

Constructor Detail

ValidationInfo	back to summary
public ValidationInfo(final BackingStoreHashtable infoRows)

Method Detail

possiblyValidateOnReturn	back to summary
public abstract void possiblyValidateOnReturn(LanguageConnectionContext lcc, SQLSessionContext nested, SQLSessionContext caller) throws StandardException

validateConstraint	back to summary
public abstract void validateConstraint(LanguageConnectionContext lcc, UUID constraintId, boolean rollbackOnError) throws StandardException

public final Class DeferredConstraintsMemory

Nested and Inner Type Summary

Constructor Summary

Method Summary

Constructor Detail

Method Detail

public Class DeferredConstraintsMemory.CheckInfo

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

private Class DeferredConstraintsMemory.ForeignKeyInfo

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

private Class DeferredConstraintsMemory.UniquePkInfo

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public abstract Class DeferredConstraintsMemory.ValidationInfo

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail