Package com.ibm.fhir.persistence.jdbc.db2

Class Db2ResourceReferenceDAO

java.lang.Object

com.ibm.fhir.persistence.jdbc.dao.impl.ResourceReferenceDAO

com.ibm.fhir.persistence.jdbc.db2.Db2ResourceReferenceDAO

All Implemented Interfaces:

IResourceReferenceDAO, java.lang.AutoCloseable

public class Db2ResourceReferenceDAO
extends ResourceReferenceDAO

Db2-specific extension of the ResourceReferenceDAO to work around some SQL syntax and Postgres concurrency issues

Field Summary

Fields inherited from class com.ibm.fhir.persistence.jdbc.dao.impl.ResourceReferenceDAO

BATCH_SIZE

Constructor Summary

Constructors

Constructor	Description
Db2ResourceReferenceDAO(IDatabaseTranslator t, java.sql.Connection c, java.lang.String schemaName, ICommonTokenValuesCache cache, java.lang.String adminSchemaName, INameIdCache<java.lang.Integer> parameterNameCache)	Public constructor

Method Summary

Modifier and Type	Method	Description
void	doCanonicalValuesUpsert(java.lang.String paramList, java.util.Collection<java.lang.String> sortedURLS)	Insert any missing values into the common_canonical_values table
void	doCodeSystemsUpsert(java.lang.String paramList, java.util.Collection<java.lang.String> sortedSystemNames)	Insert any missing values into the code_systems table
protected void	doCommonTokenValuesUpsert(java.lang.String paramList, java.util.Collection<CommonTokenValue> sortedTokenValues)	Execute the insert (upsert) into the common_token_values table for the given collection of values.
protected void	insertResourceProfiles(java.lang.String resourceType, java.util.Collection<ResourceProfileRec> profiles)
protected void	insertResourceSecurity(java.lang.String resourceType, java.util.Collection<ResourceTokenValueRec> xrefs)	Insert _security parameters to the resource-specific xx_SECURITY table
protected void	insertResourceTags(java.lang.String resourceType, java.util.Collection<ResourceTokenValueRec> xrefs)	Insert the tags referenced by the given collection of token value records
protected void	insertResourceTokenRefs(java.lang.String resourceType, java.util.Collection<ResourceTokenValueRec> xrefs)	Insert the values in the resource-type-specific _resource_token_refs table.
protected void	insertSystemResourceProfiles(java.lang.String resourceType, java.util.Collection<ResourceProfileRec> profiles)	Insert PROFILE parameters
protected void	insertSystemResourceSecurity(java.lang.String resourceType, java.util.Collection<ResourceTokenValueRec> xrefs)	Insert _security parametes to the whole-system LOGICAL_REOURCE_SECURITY table
protected void	insertSystemResourceTags(java.lang.String resourceType, java.util.Collection<ResourceTokenValueRec> xrefs)	Insert _tag parameters to the whole-system LOGICAL_RESOURCE_TAGS table
protected void	insertSystemResourceTokenRefs(java.lang.String resourceType, java.util.Collection<ResourceTokenValueRec> xrefs)	Insert any whole-system parameters to the token_refs table
protected int	readOrAddParameterNameId(java.lang.String parameterName)	Fetch the id for the given parameter name from the database, creating a new entry if required.

Methods inherited from class com.ibm.fhir.persistence.jdbc.dao.impl.ResourceReferenceDAO

addNormalizedValues, close, doCodeSystemsFetch, flush, getCache, getConnection, getParameterNameId, getResourceReferenceCache, getSchemaName, getTranslator, persist, readCanonicalId, readCommonTokenValueId, readCommonTokenValueIdList, readCommonTokenValueIds, upsertCanonicalValues, upsertCodeSystems, upsertCommonTokenValues

Methods inherited from class java.lang.Object

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

Constructor Detail

Db2ResourceReferenceDAO

public Db2ResourceReferenceDAO(IDatabaseTranslator t,
                               java.sql.Connection c,
                               java.lang.String schemaName,
                               ICommonTokenValuesCache cache,
                               java.lang.String adminSchemaName,
                               INameIdCache<java.lang.Integer> parameterNameCache)

Public constructor

Parameters:

t -

c -

schemaName -

cache -

Method Detail

doCodeSystemsUpsert

public void doCodeSystemsUpsert(java.lang.String paramList,
                                java.util.Collection<java.lang.String> sortedSystemNames)

Description copied from class: ResourceReferenceDAO

Insert any missing values into the code_systems table

Specified by:

doCodeSystemsUpsert in class ResourceReferenceDAO

doCanonicalValuesUpsert

public void doCanonicalValuesUpsert(java.lang.String paramList,
                                    java.util.Collection<java.lang.String> sortedURLS)

Description copied from class: ResourceReferenceDAO

Insert any missing values into the common_canonical_values table

Specified by:

doCanonicalValuesUpsert in class ResourceReferenceDAO

doCommonTokenValuesUpsert

protected void doCommonTokenValuesUpsert(java.lang.String paramList,
                                         java.util.Collection<CommonTokenValue> sortedTokenValues)

Description copied from class: ResourceReferenceDAO

Execute the insert (upsert) into the common_token_values table for the given collection of values. Note, this insert from negative outer join requires the database concurrency implementation to be correct. This does not work for Postgres, hence Postgres gets its own implementation of this method

Specified by:

doCommonTokenValuesUpsert in class ResourceReferenceDAO

insertResourceTokenRefs

protected void insertResourceTokenRefs(java.lang.String resourceType,
                                       java.util.Collection<ResourceTokenValueRec> xrefs)

Description copied from class: ResourceReferenceDAO

Insert the values in the resource-type-specific _resource_token_refs table. This is a simple batch insert because all the FKs have already been resolved and updated in the ResourceTokenValueRec records

Overrides:

insertResourceTokenRefs in class ResourceReferenceDAO

insertSystemResourceTokenRefs

protected void insertSystemResourceTokenRefs(java.lang.String resourceType,
                                             java.util.Collection<ResourceTokenValueRec> xrefs)

Description copied from class: ResourceReferenceDAO

Insert any whole-system parameters to the token_refs table

Overrides:

insertSystemResourceTokenRefs in class ResourceReferenceDAO

insertResourceProfiles

protected void insertResourceProfiles(java.lang.String resourceType,
                                      java.util.Collection<ResourceProfileRec> profiles)

Overrides:

insertResourceProfiles in class ResourceReferenceDAO

insertSystemResourceProfiles

protected void insertSystemResourceProfiles(java.lang.String resourceType,
                                            java.util.Collection<ResourceProfileRec> profiles)

Description copied from class: ResourceReferenceDAO

Insert PROFILE parameters

Overrides:

insertSystemResourceProfiles in class ResourceReferenceDAO

insertResourceTags

protected void insertResourceTags(java.lang.String resourceType,
                                  java.util.Collection<ResourceTokenValueRec> xrefs)

Description copied from class: ResourceReferenceDAO

Insert the tags referenced by the given collection of token value records

Overrides:

insertResourceTags in class ResourceReferenceDAO

insertSystemResourceTags

protected void insertSystemResourceTags(java.lang.String resourceType,
                                        java.util.Collection<ResourceTokenValueRec> xrefs)

Description copied from class: ResourceReferenceDAO

Insert _tag parameters to the whole-system LOGICAL_RESOURCE_TAGS table

Overrides:

insertSystemResourceTags in class ResourceReferenceDAO

insertResourceSecurity

protected void insertResourceSecurity(java.lang.String resourceType,
                                      java.util.Collection<ResourceTokenValueRec> xrefs)

Description copied from class: ResourceReferenceDAO

Insert _security parameters to the resource-specific xx_SECURITY table

Overrides:

insertResourceSecurity in class ResourceReferenceDAO

insertSystemResourceSecurity

protected void insertSystemResourceSecurity(java.lang.String resourceType,
                                            java.util.Collection<ResourceTokenValueRec> xrefs)

Description copied from class: ResourceReferenceDAO

Insert _security parametes to the whole-system LOGICAL_REOURCE_SECURITY table

Overrides:

insertSystemResourceSecurity in class ResourceReferenceDAO

readOrAddParameterNameId

protected int readOrAddParameterNameId(java.lang.String parameterName)
                                throws FHIRPersistenceDBConnectException,
                                       FHIRPersistenceDataAccessException

Description copied from class: ResourceReferenceDAO

Fetch the id for the given parameter name from the database, creating a new entry if required.

Specified by:

readOrAddParameterNameId in class ResourceReferenceDAO

Returns:

Throws:

FHIRPersistenceDBConnectException

FHIRPersistenceDataAccessException