Is there an installer for the jdbc drivers on Windows

Question

Question

Michael McNab · Jan 5, 2023

Hi ,

I am trying to work out how to install the intersystems-jdbc-3.3.1.jar file onto a windows server to set up a connection between athrid party application and an Iris database.

Is there an installer ? the java -jar etc command does not work "could not load main class " . Added the folder to the system path .

Running Eclipse temurin but I do not work with java at all, other than these very specific points where need to get applications to run .

If someone could point me to a guide or instruction that would be of great assitance

Cheers

Michael

Discussion (6)4

Log in or sign up to continue

score 0 · Answer 1 · 2023-01-05T02:10:16-05:00

In a third party application, there's usually a driver configuration page, you need to add IRIS driver there. That is done by one of two ways:

Providing a path to IRIS jdbc jar
Placing IRIS jdbc jar in a special folder for all jdbc jars.

score 0 · Answer 2 · 2023-01-05T02:10:55-05:00

What exactly do you want to achieve?

JDBC Drivers are not applications, so, there is nothing to execute, it is supposed to be used by another application, which can work with JDBC drivers.

score 2 · Answer 3 · 2023-01-05T08:24:23-05:00

In addition to what Eduard and Dmitry have said, you may find this resource helpful: Setting Up JDBC Connections. Enjoy!

score 0 · Answer 4 · 2023-01-06T02:23:21-05:00

Some pointers which may be useful:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

https://intersystems-community.github.io/iris-driver-distribution/

score 0 · Answer 5 · 2023-01-15T16:13:36-05:00

Thank you all for your assistance .

The jars were placed in the application jar library path added etc , so it appears the problem lies with the application .

The url syntax was setup as is described in the documentation.

Installers are commonly used for the installation of ODBC drives and the request was around that context to try and 'force' the app to recognise it .

Thanks for the help and the links

Regards

Michael

score 0 · Answer 6 · 2023-01-26T14:19:03-05:00

As someone else indicated applications will normally have a configuration page for the driver.

In dBeaver for example when you setup a connection there is a "Driver Settings" button

Clicking on this will allow you to configure a JDBC driver for connecting. To start you would go to the libraries tab and point at the InterSystems JDBC jar file as shown below. Your path would look something like c:/InterSystemsJDBC/intersystems-jdc-3.2.0.jar (your folder may be different).

Finally on the Settings tab you would indicate the class name and other connection settings

If you are trying to connect programaticaly you can use whatever library you wish and provide the same type information. Here is an example in Python using the JayDeBe API library.

    IRIS_JARFILE = "c:\JDBCdrivers\intersystems-jdbc-3.2.0.jar"
    IRIS_DRIVER = "com.intersystems.jdbc.IRISDriver"

    JDBC_JARFILES = [IRIS_JARFILE]
    # Database settings - this should be in a config file somewhere
    # credentials.MyCreds = ["username","password"]
    dbConn = jaydebeapi.connect(IRIS_DRIVER, 
      jdbc:IRIS://10.17.10.84:1972/B360",
      credentials.MyCreds, JDBC_JARFILES)