How do I locate my JDBC JAR file path from the tool using it?

  • 4 May 2023
  • 1 reply

Userlevel 1

I need to locate the file path my tool is referencing the CData JDBC Driver from.


I needed to manually move it in the past to a new location outside the installation directory to get the tool to use it, but after time have forgotten where that path was. 


Best answer by Brooks E 4 May 2023, 19:56

View original

1 reply

Userlevel 1

You can locate various details related to your system information, including the path the JAR file is located on said system, by querying the sys_information System Table.

The Location property in said sys_information table gives the precise location of the file path that the JDBC JAR file is running from. 

An example of the relevant query to run for that can be found below: 

SELECT Location FROM sys_information