Business Events: JDBC Connection fails from BE Studio/Runtime

Is the JDBC connection fails while trying to test the from Business events Studio? Even many times while running the BE code in local machine, errors are generated, reflecting failure of the JDBC connection. This is a very common issue. It is observed during the first run, just after the installation of Business Events.

This is due to the fact, Business Events do not comes with preconfigured TRAs for JDBC connection. So, it needs to be configured explicitly.

Follow the below steps to configure JDBC connection.

1. If you are getting this error at design time (while checking the connection from eclipse)

   -- edit studio.tra {location <BE_HOME>\studio\eclipse\configuration}

           edit the property (add the following at the end of the line)

               studio.extended.classpath= C:/tibco/be/5.1/studio/eclipse/thirdparty    {Assuming the JDBC jars are at loacation C:/tibco/be/5.1/studio/eclipse/thirdparty} 

2. If you are getting this error at run time

--edit be-engine.tra

       add property

           tibco.env.JDBC_HOME=C:/tibco/be/5.1/studio/eclipse/thirdparty {Assuming the JDBC jars are at loacation C:/tibco/be/5.1/studio/eclipse/thirdparty}

        and edit property

            tibco.class.path.extended %CUSTOM_EXT_PREPEND_CP%%PSP%%STD_EXT_CP%%PSP%%CUSTOM_EXT_APPEND_CP%%PSP%%JDBC_HOME%

3. If you are the still getting this error, check your Oracle listener is running. Try to connect it from any other application like SQLDeveloper or TIBCO BW etc.