Thank you for the extra information. Just to clarify I placed “postgresql-42.1.1.jar” in location “C:\Program Files (x86)\Java\jre1.8.0_151\lib\ext” this solved the problem.
Many thanks
Guido
From: Zahid Iqbal [mailto:zahid.iqbal@enterprisedb.com] Sent: 13 December 2017 18:04 To: Le Lorrain, Guido (TR Technology & Ops) Cc: pgsql-jdbc@postgresql.org Subject: Re: Migrating from Sql Server to PostgreSQL - postgres drivers
You need to place the driver under JDK/JRE-HOME/ext/lib path (the MTK 51 contains classpath reference for an old version of PG JDBC driver) so that JVM picks the driver in default classpath (alternatively you can place PG JDBC driver ver 9.4-1208 under MTK lib path).
Connecting with target Postgres database server... Exception in thread "main" java.lang.NoClassDefFoundError: org/postgresql/Driver com.edb.dbhandler.postgresql.PGConnection.< init>(PGConnection.java:32
I have placed the postgresql-42.1.1.jar in C:\Program files (x86)\sdb\mtk\lib
However I still geting the same error. I have installed Java 8.151 and my edbmtk-51.config does have the correct path defined.
Can anyone help in suggesting where to correctly place the postgresql-42.1.1.jar or have a solution to the error message:
Connecting with target Postgres database server... Exception in thread "main" java.lang.NoClassDefFoundError: org/postgresql/Driver com.edb.dbhandler.postgresql.PGConnection.< init>(PGConnection.java:32
Am I missing some other configuration or binaries?
Kind regards
Guido Le Lorrain
This e-mail is for the sole use of the intended recipient and contains information that may be privileged and/or confidential. If you are not an intended recipient, please notify the sender by return e-mail and delete this e-mail and any attachments. Certain required legal entity disclosures can be accessed on our website.