How to undeploy and redeploy JDBC-ODBC Bridge adapter in TIBCO Data Virtualization?

How to undeploy and redeploy JDBC-ODBC Bridge adapter in TIBCO Data Virtualization?

book

Article ID: KB0077164

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.0 and above

Description

This article talks about the steps to undeploy and redeploy the JDBC-ODBC adapter.

Issue/Introduction

How to undeploy and redeploy JDBC-ODBC Bridge adapter in TIBCO Data Virtualization?

Resolution

To undeploy the current JDBC-ODBC driver: 

Open command prompt, navigate to [TDV SERVER_INSTALL_DIRECTORY]\bin and run the following command: 

> server_util.bat -server <enter_server_name> -port <enter_TDV_base port> -user <enter_admin_username> -password <enter_admin_password> -undeploy -name JDBCODBC -version 1

Example for reference:

> server_util.bat -server localhost -port 9400 -user admin -password password -undeploy -name JDBCODBC -version 1

Sample Output: 

Listening for transport dt_socket at address: 8005
Success

Note:
The key here is to pass the right name of the adapter. In this case, it is JDBCODBC.
At this point, you will observe that the JDBC-ODBC Bridge adapter is no longer available for selection while creating the data source. 
 

To deploy the JDBC- ODBC Bridge driver:

1. Copy the latest .jar (example: jdbcodbc.jar) file to [TDV SERVER_INSTALL_DIRECTORY]\bin folder

2. Open command prompt, navigate to [TDV SERVER_INSTALL_DIRECTORY]\bin and run the following command: 

> server_util.bat -server -server <enter_server_name> -port <enter_TDV_base port> -user <enter_admin_username> -password <enter_admin_password> -deploy -package <my_adapter_name>.jar

Example for reference:    

server_util.bat -server localhost -port 9400 -user admin -password password -deploy -package JDBCODBC.jar

Sample Output:     

Listening for transport dt_socket at address: 8005
Success