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

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

book

Article ID: KB0088681

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
============
In BusinessEvents 4.0.1, the 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  to the Database URIs for Database concepts under the 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.1_HOME>/doc/data_modeling/pdf

Issue/Introduction

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