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


Environment:
==========
TIBCO BusinessEvents 4.0.0 Studio
Oracle 10g 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.

References:
==========
For more information refer to the section entitled Database Concepts in "tib_be_data_modeling_developers_guide.pdf" under &ltTibco_4.0_HOME>/doc/data_modeling/pdf