eclipselink重复相同查询上千次，然后出现stackoverflow异常

Question

我有一个jsf项目，它以前已经在oracle application server上部署过多次，它使用eclipse link 2.2.0，在最近的一个新安装中，站点在从DB加载数据时崩溃，因为它不停地执行相同的查询上千次，然后抛出stackoverflow异常

public ClassDescriptor buildTLEntityPCDAODescriptor() {
    RelationalDescriptor descriptor = new RelationalDescriptor();
    descriptor.setJavaClass(com.its.tabs.tpc.layers.dal.entity.toplink.TLEntityPCDAO.class);
    descriptor.addTableName("TPC_ENTITIES");
    descriptor.addPrimaryKeyFieldName("TPC_ENTITIES.ENTITY_ID");

    // Inheritance Properties.

    // Descriptor Properties.
    descriptor.useSoftCacheWeakIdentityMap();
    descriptor.setIdentityMapSize(100);
    descriptor.useRemoteSoftCacheWeakIdentityMap();
    descriptor.setRemoteIdentityMapSize(100);
    descriptor.setSequenceNumberFieldName("TPC_ENTITIES.ENTITY_ID");
    descriptor.setSequenceNumberName("SEQ_ENTITIES");
    descriptor.setAlias("TLEntityPCDAO");

    // Cache Invalidation Policy
    TimeToLiveCacheInvalidationPolicy policy = new TimeToLiveCacheInvalidationPolicy(1);
    policy.setShouldUpdateReadTimeOnUpdate(false);
    descriptor.setCacheInvalidationPolicy(policy);

    // Query Manager.
    descriptor.getQueryManager().checkCacheForDoesExist();

    DirectToFieldMapping descriptionMapping = new DirectToFieldMapping();
    descriptionMapping.setAttributeName("description");
    descriptionMapping.setFieldName("TPC_ENTITIES.DESCRIPTION");
    descriptor.addMapping(descriptionMapping);

    DirectToFieldMapping serviceProviderCodeMapping = new DirectToFieldMapping();
    serviceProviderCodeMapping.setAttributeName("serviceProviderCode");
    serviceProviderCodeMapping.setFieldName("TPC_ENTITIES.SERVICE_PROVIDER_CODE");
    descriptor.addMapping(serviceProviderCodeMapping);

    DirectToFieldMapping entity_idMapping = new DirectToFieldMapping();
    entity_idMapping.setAttributeName("entity_id");
    entity_idMapping.setNullValue(new Long(0));
    entity_idMapping.setFieldName("TPC_ENTITIES.ENTITY_ID");
    descriptor.addMapping(entity_idMapping);

    DirectToFieldMapping idMapping = new DirectToFieldMapping();
    idMapping.setAttributeName("id");
    idMapping.readOnly();
    idMapping.setFieldName("TPC_ENTITIES.ENTITY_ID");
    descriptor.addMapping(idMapping);

    DirectToFieldMapping levelIdMapping = new DirectToFieldMapping();
    levelIdMapping.setAttributeName("levelId");
    levelIdMapping.setNullValue(new Long(0)); //changed from -1 to 0
    levelIdMapping.setFieldName("TPC_ENTITIES.LEVEL_ID");
    descriptor.addMapping(levelIdMapping);

    DirectToFieldMapping lookupIdMapping = new DirectToFieldMapping();
    lookupIdMapping.setAttributeName("lookupId");
    lookupIdMapping.setNullValue(new Long(0)); //changed from -1 to 0
    lookupIdMapping.setFieldName("TPC_ENTITIES.LOOKUP_ID");
    descriptor.addMapping(lookupIdMapping);

    DirectToFieldMapping levelDepthMapping = new DirectToFieldMapping();
    levelDepthMapping.setAttributeName("levelDepth");
    levelDepthMapping.setFieldName("TPC_ENTITIES.LEVEL_DEPTH");
    descriptor.addMapping(levelDepthMapping);

    DirectToFieldMapping entity_sequenceMapping = new DirectToFieldMapping();
    entity_sequenceMapping.setAttributeName("entity_sequence");
    entity_sequenceMapping.setNullValue(new Long(0));
    entity_sequenceMapping.setFieldName("TPC_ENTITIES.ENTITY_SEQUENCE");
    descriptor.addMapping(entity_sequenceMapping);

    DirectToFieldMapping entity_typeMapping = new DirectToFieldMapping();
    entity_typeMapping.setAttributeName("entity_type");
    entity_typeMapping.setFieldName("TPC_ENTITIES.ENTITY_TYPE");
    descriptor.addMapping(entity_typeMapping);

    DirectToFieldMapping nameMapping = new DirectToFieldMapping();
    nameMapping.setAttributeName("name");
    nameMapping.setFieldName("TPC_ENTITIES.NAME");
    descriptor.addMapping(nameMapping);

    DirectToFieldMapping parent_entity_idMapping = new DirectToFieldMapping();
    parent_entity_idMapping.setAttributeName("parent_entity_id");
    parent_entity_idMapping.setNullValue(new Long(0)); //changed from -1 to 0
    parent_entity_idMapping.setFieldName("TPC_ENTITIES.PARENT_ENTITY_ID");
    descriptor.addMapping(parent_entity_idMapping);

    AggregateObjectMapping auditFieldsMapping = new AggregateObjectMapping();
    auditFieldsMapping.setAttributeName("auditFields");
    auditFieldsMapping.setReferenceClass(com.its.tabs.architecture.dal.persistency.AuditFields.class);
    auditFieldsMapping.setIsNullAllowed(false);
    auditFieldsMapping.addFieldNameTranslation("TPC_ENTITIES.CREATED_BY", "createdBy->DIRECT");
    auditFieldsMapping.addFieldNameTranslation("TPC_ENTITIES.MODIFIED_BY", "modifiedBy->DIRECT");
    auditFieldsMapping.addFieldNameTranslation("TPC_ENTITIES.CREATED_DATE", "createdDate->DIRECT");
    auditFieldsMapping.addFieldNameTranslation("TPC_ENTITIES.MODIFIED_DATE", "modifiedDate->DIRECT");
    descriptor.addMapping(auditFieldsMapping);

    OneToManyMapping entitesMapping = new OneToManyMapping();
    entitesMapping.setAttributeName("entites");
    entitesMapping.setReferenceClass(com.its.tabs.tpc.layers.dal.entity.toplink.TLEntityPCDAO.class);
    entitesMapping.useTransparentCollection();
    entitesMapping.useCollectionClass(org.eclipse.persistence.indirection.IndirectList.class);
    entitesMapping.addTargetForeignKeyFieldName("TPC_ENTITIES.PARENT_ENTITY_ID", "TPC_ENTITIES.ENTITY_ID");
    descriptor.addMapping(entitesMapping);

    OneToManyMapping entityattributesMapping = new OneToManyMapping();
    entityattributesMapping.setAttributeName("entityattributes");
    entityattributesMapping.setReferenceClass(com.its.tabs.tpc.layers.dal.entityattributes.toplink.TLEntityAttributesDAO.class);
    entityattributesMapping.useTransparentCollection();
    entityattributesMapping.useCollectionClass(org.eclipse.persistence.indirection.IndirectList.class);
    entityattributesMapping.addTargetForeignKeyFieldName("TPC_ENTITY_ATTRIBUTES.ENTITY_ID", "TPC_ENTITIES.ENTITY_ID");
    descriptor.addMapping(entityattributesMapping);

    OneToOneMapping entityLevelIdMapping = new OneToOneMapping();
    entityLevelIdMapping.setAttributeName("levels");
    entityLevelIdMapping.setReferenceClass(TLLevelsDAO.class);
    entityLevelIdMapping.useProxyIndirection();
    entityLevelIdMapping.readOnly();
    entityLevelIdMapping.addForeignKeyFieldName("TPC_ENTITIES.LEVEL_ID", "TPC_LEVELS.LEVEL_ID");
    descriptor.addMapping(entityLevelIdMapping);

    OneToOneMapping entityLookupIdMapping = new OneToOneMapping();
    entityLookupIdMapping.setAttributeName("lookups");
    entityLookupIdMapping.setReferenceClass(TLLookupDAO.class);
    entityLookupIdMapping.useProxyIndirection();
    entityLookupIdMapping.readOnly();
    entityLookupIdMapping.addForeignKeyFieldName("TPC_ENTITIES.LOOKUP_ID", "TPC_LOOKUP.LOOKUP_ID");
    descriptor.addMapping(entityLookupIdMapping);

    return descriptor;
}

        List<EntityPCEntity> entityList      = new ArrayList<EntityPCEntity>();            
        entityList = (List<EntityPCEntity>)this.getTABSEntityManagerFinder().getEclipseLinkAdapter().readMultipleDAOs(TLEntityPCDAO.class);

       return entityList;

例外

Answer 1

如果您查看您的失效策略：

TimeToLiveCacheInvalidationPolicy policy = new TimeToLiveCacheInvalidationPolicy(1);
policy.setShouldUpdateReadTimeOnUpdate(false);
descriptor.setCacheInvalidationPolicy(policy);

您已经将它设置为在一毫秒内无效，可能在它完成读入之前。虽然我看不到更多关于对象模型或正在执行的查询的信息，但这可能是问题的一个很大的原因，因为这意味着对该对象的任何引用几乎总是无效的，并被迫再次查询它。