Обсуждение: Migrating from Sql Server to PostgreSQL - postgres drivers

---

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.

On 2017-12-13 19:03, Zahid Iqbal wrote:
> 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).

JDBC drivers don't belong in lib/ext, and the lib/ext extension 
mechanism has been deprecated in Java 8 and removed in Java 9.

Mark

On 2017-12-13 17:54, guido.lelorrain@thomsonreuters.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 [1]
> 
> 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?

Please post the full exception stacktrace. Given the error is 
NoClassDefFoundError, and not ClassNotFoundException, the driver is 
probably present, but could not be loaded. This could happen if you are 
using a driver for the wrong Java version, eg using the Java 8 version 
of the driver, while the application is running under Java 7 (although 
that would mean you have missed or ignored a 
UnsupportedClassVersionError).

Mark

On 12/13/2017 11:23 AM, Mark Rotteveel wrote:

On 2017-12-13 19:03, Zahid Iqbal wrote:

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).

JDBC drivers don't belong in lib/ext, and the lib/ext extension mechanism has been deprecated in Java 8 and removed in Java 9.

You can put the JAR file of the driver anywhere on the classpath.  I'm not familiar with the MTK, but if MTK has a lib directory then that sounds like the right place to go.

Also, you can probably use a newer driver from https://jdbc.postgresql.org/download.html -- there have been quite a few changes since the aforementioned version.