Resolution:
Description:
============
Test Connection fails when trying to test the JDBC connection from BusinessEvents(BE) Studio. The error message "JDBC Connection - test failed" is displayed.


Environment:
==========

   o TIBCO BusinessEvents 4.0.0


Symptoms:
=========
Studio throws the error message "JDBC Connection - test failed"


Cause:
=====
Required JDBC jars are missing from the classpath.


Resolution:
==========

Solution 1:
----------
----------
Create the folder "thirdparty" at location "&ltBE_4.0_HOME>\be\4.0\studio\eclipse\" and copy the ojdbc.jar if Oracle types are used or sqljdbc.jar if JDBC types are used. After performing this operation, restart the Studio and Test Connection.



Solution 2:
----------

Do the following to add the directories and jar files to the classpath of BusinessEvents Studio.

1. Open the following file for editing:
     BE_HOME/studio/eclipse/configuration/studio.tra

2. Add the libraries to the studio.extended.classpath property. The path delimiter is the semi-colon (;).

3. Append the classpath: with ojdbc.jar if Oracle types are used or sqljdbc.jar if JDBC types are used to the classpath property.
  
4. Restart Studio and Test Connection.

Test Connection fails when trying to test the JDBC connection from BusinessEvents(BE) Studio. The error message "JDBC Connection - test failed" is displayed.