Thanks Julian, Finally I could resolve it with your help. Below command worked for me. java -verbose -cp "oak-upgrade-1.34.0.jar:postgresql-42.2.17.jar" org.apache.jackrabbit.oak.upgrade.cli.OakUpgrade --src-user=*** --src-password='***' 'jdbc:postgresql://SRC-DB:5432/acdc_cms_dev' mongodb://USER:PASS@HOST:27017/migration-poc&authSource=admin
Thanks & Regards, Mayur On Fri, Oct 16, 2020 at 4:10 PM Mayur Barge <mayurbarge...@gmail.com> wrote: > *Tried with both options "upgrade" and without "upgrade" option* > *java -verbose -cp "oak-upgrade-1.34.0.jar:**postgresql-42.2.17.jar" -jar > oak-upgrade-1.34.0.jar --src-user=acdc_cms --src-password='***' > --user=mayur --password=*** 'jdbc:postgresql://SRC* > > *_HOST:5432/acdc_cms_dev'* > *'mongodb://TARGET_HOST:27017/**migration-test'* > > On Fri, Oct 16, 2020 at 4:09 PM Mayur Barge <mayurbarge...@gmail.com> > wrote: > >> 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 >>> >>
