{
datastoreIndex = stmt.select(stmt.getMainTableAlias(), tables[0].getDataStoreObjectIdMapping(), true);
}
}
JavaTypeMapping versionMapping = tables[0].getVersionMapping(true);
if (versionMapping != null)
{
// Select the version column (if present)
if (multipleTableCase)
{
versionIndex = stmt.selectVersion("VERSION", true);
}
else if (stmt.getTableExpression(elmIdentifier) != null)
{
versionIndex = stmt.select(elmIdentifier, versionMapping, true);
}
else
{
versionIndex = stmt.select(stmt.getMainTableAlias(), versionMapping, true);
}
}
if (multipleTableCase)
{
// Select application identity columns for the tables involved in the union.
AbstractClassMetaData cmd = storeMgr.getOMFContext().getMetaDataManager().getMetaDataForClass(getCandidateClass(), stmt.getClassLoaderResolver());
if (cmd.getIdentityType() == IdentityType.APPLICATION)
{
prefetchFieldNumbers = new int[cmd.getPKMemberPositions().length];
int fieldCount = cmd.getNoOfInheritedManagedMembers() + cmd.getNoOfManagedMembers();
statementExpressionIndex = new StatementExpressionIndex[fieldCount];
for (int i = 0; i < prefetchFieldNumbers.length; ++i)
{
prefetchFieldNumbers[i] = cmd.getPKMemberPositions()[i];
String fieldName = cmd.getMetaDataForManagedMemberAtAbsolutePosition(prefetchFieldNumbers[i]).getName();
// TODO This only selects one field of the application identity ... as APP_ID.
// If multiple we should have APP_ID1, APP_ID2, etc. It also only looks at the first table
JavaTypeMapping m = tables[0].getFieldMapping(cmd.getMetaDataForManagedMemberAtAbsolutePosition(prefetchFieldNumbers[i]));
if (m != null) // field is not stored in the table, e.g List, Set, etc or is transactional
{
if (m.includeInFetchStatement() && !(m instanceof AbstractContainerMapping))
{
statementExpressionIndex[prefetchFieldNumbers[i]] = new StatementExpressionIndex();
statementExpressionIndex[prefetchFieldNumbers[i]].setMapping(m);
statementExpressionIndex[prefetchFieldNumbers[i]].setExpressionIndex(stmt.selectField(fieldName, "APP_ID", true));
}
}
}
}
// TODO Select fetch plan fields also ? This should be done for all fields that are in *all* subclass tables
}
else
{
// TODO When we have all possible candidates in single table and using discriminator
// we should really select all fields here to save doing the retrieve of the other fields later.
// Currently we only retrieve the fetch-plan/DFG fields for the base candidate class
if (useFetchPlan)
{
// Select all fields in the FetchPlan
// TODO This only utilises the first table. What if we have multiple ?
AbstractClassMetaData cmd = storeMgr.getOMFContext().getMetaDataManager().getMetaDataForClass(getCandidateClass(), stmt.getClassLoaderResolver());
getFetchPlan().manageFetchPlanForClass(cmd);
FetchPlanForClass fpc = getFetchPlan().getFetchPlanForClass(cmd);
int fieldNumbers[] = fpc.getFieldsInActualFetchPlan();
int prefetchFieldCount = 0;
int fieldCount = cmd.getNoOfInheritedManagedMembers() + cmd.getNoOfManagedMembers();
int fn[] = new int[fieldNumbers.length];
statementExpressionIndex = new StatementExpressionIndex[fieldCount];
for (int i = 0; i < fieldNumbers.length; ++i)
{
JavaTypeMapping m = tables[0].getFieldMapping(cmd.getMetaDataForManagedMemberAtAbsolutePosition(fieldNumbers[i]));
if (m != null)
{
// omit fields not stored in the table, e.g. List, Set, etc or transactional
if (m.includeInFetchStatement() && !(m instanceof AbstractContainerMapping))
{
statementExpressionIndex[fieldNumbers[i]] = new StatementExpressionIndex();
statementExpressionIndex[fieldNumbers[i]].setMapping(m);
fn[prefetchFieldCount++] = fieldNumbers[i];
}
}
}
prefetchFieldNumbers = new int[prefetchFieldCount];
System.arraycopy(fn, 0, prefetchFieldNumbers, 0, prefetchFieldCount);
// select the fetch-plan fields to be fetched from the database
if (stmt.getTableExpression(elmIdentifier) != null)
{
Mappings.selectMapping(stmt, elmIdentifier, statementExpressionIndex);
}
else
{
Mappings.selectMapping(stmt, statementExpressionIndex);
}
}
else
{
// if no fetchplan is used and is application identity, select only PK fields
AbstractClassMetaData cmd = storeMgr.getOMFContext().getMetaDataManager().getMetaDataForClass(getCandidateClass(),stmt.getClassLoaderResolver());
if (cmd.getIdentityType() == IdentityType.APPLICATION)
{
prefetchFieldNumbers = new int[cmd.getPKMemberPositions().length];
int fieldCount = cmd.getNoOfInheritedManagedMembers() + cmd.getNoOfManagedMembers();
statementExpressionIndex = new StatementExpressionIndex[fieldCount];
for (int i = 0; i < prefetchFieldNumbers.length; ++i)
{
prefetchFieldNumbers[i] = cmd.getPKMemberPositions()[i];
JavaTypeMapping m = tables[0].getFieldMapping(cmd.getMetaDataForManagedMemberAtAbsolutePosition(prefetchFieldNumbers[i]));
if (m != null) // field is not stored in the table, e.g List, Set, etc or is transactional
{
if (m.includeInFetchStatement() && !(m instanceof AbstractContainerMapping))
{
statementExpressionIndex[prefetchFieldNumbers[i]] = new StatementExpressionIndex();
statementExpressionIndex[prefetchFieldNumbers[i]].setMapping(m);
}
}