Re: regarding table migration from sql to postgres with runmtk.sh - Mailing list pgsql-general

Hi sir

i got following erro when i ran runmtk.sh  

initially i placed the jtds driver related to sql in /opt/postgresplus/edbmtk/lib

./runMTK.sh  -sourcedbtype sqlserver -targetdbtype postgresql feeds_morningstar_bond_sector

Running EnterpriseDB Migration Toolkit (Build 48.0.2) ...

Source database connectivity info...

conn =jdbc:jtds:sqlserver://fxserver.trustfort.com:49888/DataFeedHandler

user =trustfort

password=******

Target database connectivity info...

conn =jdbc:postgresql://192.168.24.128:5432/dbo_sql

user =postgres

password=******

Connecting with source SQL Server database server...

Connected to Microsoft SQL Server, version '10.50.1600'

Connecting with target Postgres database server...

Exception in thread "main" java.lang.NoClassDefFoundError: org/postgresql/Driver

        at com.edb.dbhandler.postgresql.PGConnection.<init>(PGConnection.java:32)

        at com.edb.common.MTKFactory.createMTKConnection(MTKFactory.java:228)

        at com.edb.MigrationToolkit.createNewTargetConnection(MigrationToolkit.java:5610)

        at com.edb.MigrationToolkit.initToolkit(MigrationToolkit.java:3122)

        at com.edb.MigrationToolkit.main(MigrationToolkit.java:1521)

Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver

        at java.net.URLClassLoader$1.run(URLClassLoader.java:366)

        at java.net.URLClassLoader$1.run(URLClassLoader.java:355)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.net.URLClassLoader.findClass(URLClassLoader.java:354)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:425)

        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)