Harvest uses ODBC and JDBC to communicate with the database
Article ID: 281717
Updated On:
Products
Issue/Introduction
How is the communication between Harvest and the DB? Does it use ODBC or JDBC? Why?
Environment
Harvest Software Change Manager all versions
Resolution
Communication between Harvest SCM Server is written in the C programming language, so its connection to the database uses ODBC. The GUI clients (Workbench, Administrator Tool) and the plugins use the SCM Server to connect to the database, so ODBC is used there. Harweb uses both ODBC through the SCM Server and JDBC directly to the database.
The reason for Harweb to use both ODBC and JDBC is that some parts of Harweb use the traditional client's command line utilities. Those route to the Harvest server side which will use it's ODBC connection to deal with the database. Other parts of Harweb deal with the database directly and require the JDBC connection to do that. Harweb doesn't have it's own separate ODBC connection but does require its own JDBC connection.
Feedback
