Configuring Sybase Database by Using Custom JDBC Driver

You can configure Sybase Database by using the custom JDBC driver.

Procedure

Note: Follow the same steps to configure the Sybase database by using JDBC custom driver on TIBCO BusinessWorks™ Container Edition Studio.

  1. In TIBCO Business Studio, go to Windows and click Preferences.
  2. Select the option Allow use of custom driver under BusinessWorks > Palettes > JDBC, click Apply, and then click OK.
    Setting Custom Driver
  3. Create a new JDBC connection resource and select custom.jdbc.driver from the Database Driver list. Enter the Driver details and user credentials in the project that you have created.
    Driver Details and User Credentials
  4. Click Test Connection. A pop-up window is displayed.
    Test Connection Pop-up
  5. Click OK. A new Plug-in Project with a prepopulated project name is displayed. Click Next.
    Plug-in Details
  6. Click Finish. A custom project is created in the workspace named as com.tibco.custom.driver.project.name with compilation errors.
    Errors
  7. Go to JDBC connection resource and click Test Connection again. A connection is established successfully.
    JDBC Connection

    After the connection is established successfully, delete the custom plug-in project "com.tibco.custom.driver.project.name" from the workspace that was created earlier and run the activity. The activity runs successfully.
    Note: If the custom project is not present in the workspace and if you click again on the Test Connection button in the JDBC Connection shared resource, then every time the custom project is created in the workspace as mentioned in the steps in this section. You have to delete the same custom project before running the activity.