Hello, I tried setting up classpath as suggested by Julian *java -verbose -cp "oak-upgrade-1.34.0.jar:**postgresql-42.2.17.jar" -jar oak-upgrade-1.34.0.jar upgrade --src-user=acdc_cms --src-password='***' --user=mayur --password=*** 'jdbc:postgresql://SRC*
*_HOST:5432/acdc_cms_dev'* *'mongodb://TARGET_HOST:27017/**migration-test'* Still I am facing the issue for *[Loaded java.sql.SQLWarning from /Library/Java/JavaVirtualMachines/jdk1.8.0_261.jdk/Contents/Home/jre/lib/rt.jar]16.10.2020 16:08:30.873 [main] *INFO* org.apache.jackrabbit.oak.plugins.document.rdb.RDBDataSourceFactory - trying to obtain driver for jdbc:postgresql://op-ampp-dev-pgsql-01.springernature.com:5432/acdc_cms_dev <http://op-ampp-dev-pgsql-01.springernature.com:5432/acdc_cms_dev>java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:315) at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDataSourceFactory.forJdbcUrl(RDBDataSourceFactory.java:71) at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDataSourceFactory.forJdbcUrl(RDBDataSourceFactory.java:102) at org.apac* Kindly let us know the right way to sidegrade from Postgres to Mongo. Thanks, Mayur On Thu, Oct 15, 2020 at 3:19 PM Mayur Barge <mayurbarge...@gmail.com> wrote: > Hello, > I am trying to migrate my datasource from Postgres to Mongo. I have added > the driver file in CLASSPATH > > *CLASSPATH=/Users/mbn2671/Downloads/jar_files/oak-upgrade-1.8.7.jar:/Users/mbn2671/Downloads/jar_files/postgresql-42.2.17.jar:.* > > This is a Mac machine I am using. Now what I want to achieve is migrate > datastores from > Postgres => MongoDB > The below command i am trying to use > > *java -verbose -jar oak-upgrade-1.8.7.jar --src-password='***' > --src-user=ABC --user=XYZ --password=*** > 'jdbc:postgresql://POSTGRESHOST:5432/DB' > 'mongodb://MONGOHOST:27017/migration-test'* > > It says, > > > *15.10.2020 15:17:44.041 [main] *INFO* > org.apache.jackrabbit.oak.plugins.document.rdb.RDBDataSourceFactory - > trying to obtain driver for > jdbc:postgresql://op-ampp-dev-pgsql-01.springernature.com:5432/acdc_cms_dev > <http://op-ampp-dev-pgsql-01.springernature.com:5432/acdc_cms_dev>java.sql.SQLException: > No suitable driver at > java.sql.DriverManager.getDriver(DriverManager.java:315) ~[na:1.8.0_261]* > > > Kindly let me know what could be the issue >
