Postgres Pro
Downloads
Home   >   mailing lists

Thread: regarding table migration from sql to postgres with runmtk.sh

regarding table migration from sql to postgres with runmtk.sh

From
Durgamahesh Manne
Date:
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...
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)



regards
mahesh

Re: regarding table migration from sql to postgres with runmtk.sh

From
Andrew Sullivan
Date:
On Wed, Mar 09, 2016 at 06:56:38PM +0530, Durgamahesh Manne wrote:
> 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

Looks like you're using postgresplus, which is EnterpriseDB's fork.  But …

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

… since it can't find the driver, I'd bet that your classpath doesn't
contain /opt/postgresplus/edbmtk/lib.

Best regards,

A

--
Andrew Sullivan
ajs@crankycanuck.ca

Re: regarding table migration from sql to postgres with runmtk.sh

From
Raghavendra
Date:
On Wed, Mar 9, 2016 at 7:26 AM, Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:
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...
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)

 
​Looks like the driver issue.
./runMTK.sh​ is EnterpriseDB Migration Studio tool. Can you please reach out to EnterpriseDB support or Forum. 

---
Regards,
Raghavendra
EnterpriseDB Corporation