How to identify the deployed version of the HXTT Text JDBC Driver in RSA Identity Governance & Lifecycle
4 years ago
Originally Published: 2020-07-08
Article Number
000056550
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.0, 7.1.1, 7.2.0
Platform/Application Server: WildFly, WebSphere, WebLogic
 
Issue
The HXTT Text JDBC Driver is used by RSA Identity Governance & Lifecycle for collectors that use the Database Source Type CSV File to collect data from text files. (Collectors > {Collector type} > Create {Collector type} Collector > Data Source Type: CSV File.)

At times RSA Identity Governance & Lifecycle Customer Support may ask for the exact version of the HXTT Text JDBC Driver file that is deployed. This RSA Knowledge Base Article explains how to determine the version of the HXTT Text JDBC Driver on all RSA Identity Governance & Lifecycle platforms.
 
Resolution
The following commands may be used to identify the location of the deployed version of the HXTT Text JDBC Driver and print out the manifest file showing the version of the driver.

WildFly

As the oracle user, execute the following commands to determine the location of the jar file and the location and contents of the manifest file on WildFly.
find $AVEKSA_HOME/wildfly/ -name "Text_JDBC*.jar" -print
unzip -p `find $AVEKSA_HOME/wildfly/ -name "Text_JDBC*.jar" -print` META-INF/MANIFEST.MF

WebSphere

As the oracle user, execute the following commands to determine the location of the jar file and the location and contents of the manifest file on WebSphere.
find /opt/IBM/WebSphere/AppServer/ -name "Text_JDBC*.jar" -print
unzip -p `find /opt/IBM/WebSphere/AppServer/ -name "Text_JDBC*.jar" -print` META-INF/MANIFEST.MF

WebLogic

As the oracle user, execute the following commands to determine the location of the jar file and the location and contents of the manifest file on WebLogic. Note that for WebLogic you may need to modify the command to point to the actual location of your WebLogic deployment.

find /user_projects/domains/ -name "Text_JDBC*.jar" -print
unzip -p `find /user_progects/domains/ -name "Text_JDBC*.jar" -print` META-INF/MANIFEST.MF

 

Example on WildFly:

# find $AVEKSA_HOME/wildfly/ -name "Text_JDBC*.jar" -print
/home/oracle/wildfly/standalone/tmp/vfs/deployment/deployment3a370c3679c5ca68/aveksa.war-595c31543f670531
/WEB-INF/LocalAgent/common/lib/Text_JDBC42.jar

# unzip -p `find $AVEKSA_HOME/wildfly/ -name "Text_JDBC*.jar" -print` META-INF/MANIFEST.MF
Manifest-Version: 1.0
Created-By: HXTT Version Robot
Main-Class: com.hxtt.sql.admin.Admin

Name: com/hxtt/sql/text/
Implementation-Title: com.hxtt.sql.text
Copyright: Yonghong Zhao
Implementation-Version: 7.0.067 on January 31, 2020
Specification-Vendor: Heng Xing Tian Tai Lab
Specification-Title: HXTT Text (CSV) JDBC 4.2 Package
Comment: JDBC 4.2 Package for plain text, binary file, CSV
Specification-Version: 7.0.067 on January 31, 2020
Implementation-URL: http://www.hxtt.com/text.html
Implementation-Vendor: Heng Xing Tian Tai Lab

Name: com/hxtt/sql/admin/
Implementation-Title: com.hxtt.sql.admin
Copyright: Yonghong Zhao
Implementation-Version: 0.5 on January 31, 2020
Specification-Vendor: Heng Xing Tian Tai Lab
Specification-Title: HXTT Database Admin
Comment: HXTT Database Admin
Specification-Version: 0.5 on January 31, 2020
Implementation-URL: http://www.hxtt.com/text/dbadmin.html
Implementation-Vendor: Heng Xing Tian Tai Lab