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.