RE: Migrating from Sql Server to PostgreSQL - postgres drivers

Hi Zahid,

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(dot)iqbal(at)enterprisedb(dot)com]
Sent: 13 December 2017 18:04
To: Le Lorrain, Guido (TR Technology & Ops)
Cc: pgsql-jdbc(at)postgresql(dot)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).

Thanks

On Wed, 13 Dec 2017 at 10:38 PM, <guido(dot)lelorrain(at)thomsonreuters(dot)com<mailto:guido(dot)lelorrain(at)thomsonreuters(dot)com>> wrote:
Hi,

Apologies if this question has been answered but I have yet to find a solution from searches online.

I have installed the latest PostgreSQL 10.1 and using the EDB Migration Toolkit (trying)

I am experiencing the same issues as per link: http://helgasoft.com/tools/migration.html<https://urldefense.proofpoint.com/v2/url?u=http-3A__helgasoft.com_tools_migration.html&d=DwMFaQ&c=4ZIZThykDLcoWk-GVjSLmy8-1Cr1I4FWIvbLFebwKgY&r=gNl3jwRxpbYwQ6b7mOcYYVjjF7phfDNdVh2nwVdtDmAzi1p3Wj0d33xTNUGGM-Lw&m=Apj780J_QxCwoPTm13eluhf07GfXUIA95moG9OMx4AI&s=J6pgMezsVUphcWhURblWmxo-nFKskSc8dwNml85dgng&e=>

However for some reason I can’t get passed the

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.<http://site.thomsonreuters.com/site/disclosures/>
--
Sent from Gmail Mobile