In BusinessEvents 4.0.0, exception "java.lang.RuntimeException: jdbcResource /Folder/YYY.sharedjdbc not found" is thrown when Database Concepts(DB Concepts) is used.

In BusinessEvents 4.0.0, exception "java.lang.RuntimeException: jdbcResource /Folder/YYY.sharedjdbc not found" is thrown when Database Concepts(DB Concepts) is used.

book

Article ID: KB0088690

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
============
In BusinessEvents 4.0.0, exception "java.lang.RuntimeException: jdbcResource /Folder/YYY.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

Issue/Introduction

In BusinessEvents 4.0.0, exception "java.lang.RuntimeException: jdbcResource /Folder/YYY.sharedjdbc not found" is thrown when Database Concepts(DB Concepts) is used.