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.