*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 >> >