Is there any nzjdbc.jar which is compatible with Mac

Question

I am trying to connect to Netteza Database through Dbeaver. I have the .jar file, but when i try to connect I get the following error.

No suitable driver found for jdbc:netezza://...*:5480/DM_BEM

I am using MacBook pro. Kindly help where can I find correct jdbc driver or any other way to connect.

Possible duplicate of https://stackoverflow.com/questions/5556664/how-to-fix-no-suitable-driver-found-for-jdbcmysql-localhost-dbname-error-w Refer 2nd/3rd answer — user14338238, Sep 25 '20 at 05:53

score 0 · Answer 1 · answered Sep 26 '20 at 19:09

0

The Netezza jdbc driver can be used on Mac. One way to test out to make sure that you are able to connect is to use the test functionality in the jdbc driver itself.

CLASSPATH=/path/to/driver  # $CLASSPATH/nzjdbc3.jar should exist
java -jar $CLASSPATH/nzjdbc3.jar  -t --host <host> -u <user> -db system

This will test out that the connection is working and there are no other environmental issues. At that point, check to make DBbeaver has found the jdbc jar file

Click "Add File" and then "Find Class"

Click on Add File and then Find class to make sure Netezza jdbc driver and class is found correctly.

answered Sep 26 '20 at 19:09

Aniket Kulkarni

471
2
2

I have done Add File and Find Class..... yet I couldn't get connected. – Tulip Sep 27 '20 at 09:20
@Tulip could you elaborate on what error you see? Did the "Add File" and "Find Class" succeed. – Aniket Kulkarni Sep 28 '20 at 01:26

Is there any nzjdbc.jar which is compatible with Mac

1 Answers1