Configuring custom JDBC driver at designtime and docker runtime

Configuring custom JDBC driver at designtime and docker runtime

book

Article ID: KB0080614

calendar_today

Updated On:

Products Versions
TIBCO BusinessWorks Container Edition 2.3.1,2.3.2

Description

This article will provide steps to Configure Teradata DB drivers

Issue/Introduction

Configuring custom JDBC driver at designtime and runtime (docker platform)

Resolution

Design-Time:

Note: 
1. the two jar files mentioned under the Jar File textbox in the JDBC Shared Resource need to be available under the BWCE_HOME/bwce/2.3/config/deisgn/thridparty folder. These two jar files are available in the custom.jdbc.driver package (from the Teradata_app.zip) under lib folder. 
2. Under Business Studio Preferences - JDBC - select "Allow use of custom driver" option
3. Go to JDBC resource, select "custom.jdbc.driver" in database driver, provide DB URL. In DataBase Driver, provide "com.teradata.jdbc.TeraDriver" and provide DataBase name.
4. In Jar file tab, provide names of the two jar files e.g terajdbc4.jar,tdgssconfig.jar
5. Test Connection.


Run-Time:

1. Right click on application module and go to Export-->'Plug-in Development ->deployable Plug-ins and fragments'. Export this in any directory.
2. This will generate and OSGI bundle which is helpful in runtime.
3. Copy this jar in the directory where EAR and Dockerfile is present.
4. Use below Dockerfile snip to create an application image along with Teradata driver.

++++++++++++++++++++++++
FROM tibco/bwce_232:latest
MAINTAINER Tibco
ADD myOwn.application_1.0.0.ear /
COPY *.jar /resources/addons/jars/
+++++++++++++++++++++++++

Attachments

Configuring custom JDBC driver at designtime and docker runtime get_app