Resolution:
Description:
============
In TIBCO BusinessEvents 4.x and 5.x, exception "java.lang.RuntimeException: jdbcResource YYYY.sharedjdbc not found" is thrown when Database Concepts(DB Concepts) is used.


Environment:
==========
TIBCO BusinessEvents 4.x and 5.x
Oracle Database

Symptoms:
=========
BE Engine throws the following exception -

at com.tibco.cep.runtime.model.exception.impl.BEExceptionImpl: java.lang.RuntimeException: jdbcResource /Folder/YYY.sharedjdbc not found
    at com.tibco.cep.modules.db.service.JDBCConnectionPoolManager.getJDBCConnection(JDBCConnectionPoolManager.java:59)
    at com.tibco.cep.modules.db.functions.JDBCHelper.setCurrentConn(JDBCHelper.java:729)
    at com.tibco.cep.modules.db.functions.JDBCHelper.setCurrentConnection(JDBCHelper.java:121)
    at be.gen.Rules.InputFeedEvent$InputFeedEvent_a.execute(InputFeedEvent.java:34)
    at com.tibco.cep.kernel.core.rete.ReteWM.resolveConflict(ReteWM.java:311)
    at com.tibco.cep.kernel.core.rete.ReteWM.executeRules(ReteWM.java:1365)
    at com.tibco.cep.runtime.session.impl.RuleSessionImpl.preprocessPassthru(RuleSessionImpl.java:962)
    at com.tibco.cep.runtime.scheduler.impl.WorkerBasedControllerV2.executeTask(WorkerBasedControllerV2.java:354)
    at com.tibco.cep.runtime.scheduler.impl.WorkerBasedControllerV2$WorkerTask.run(WorkerBasedControllerV2.java:386)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at com.tibco.cep.runtime.util.CustomBEManagedThread.run(CustomBEManagedThread.java:23)



Resolution:
==========
Check the following two configurations in the CDD file of the project.

1). In the CDD file add JDBC Uri in to the Database URIs for Database concepts under Cluster tab. Note that URI should not contain the root folder. For example, if the project name is ABC and JDBC resource XYZ is under folder "SharedResources" then URI to be added would be -   /SharedResources/XYZ.sharedjdbc

2). Check the "Enable DB Concepts" option in the configuration of processing unit.

3). Also please check if the JDBC_RESOURCE metadata property of db concept is properly set to the corresponding jdbcResource .