Skip to main content
Solved

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

  • May 4, 2023
  • 1 reply
  • 596 views

Forum|alt.badge.img

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

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

1 reply

Forum|alt.badge.img
  • Author
  • Employee
  • Answer
  • May 4, 2023

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