Re: Error while migrating the Datastores from PostgreSQL to MongoDB

2020-10-15 Thread Julian Reschke 

Am 15.10.2020 um 11:49 schrieb Mayur Barge:

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


"java -jar" ignores the CLASSPATH. You need to use "-cp" and specify the
entry point. See
.

Best regards, Julian

Re: Error while migrating the Datastores from PostgreSQL to MongoDB

2020-10-16 Thread Mayur Barge 
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
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  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
> 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
>

Re: Error while migrating the Datastores from PostgreSQL to MongoDB

2020-10-16 Thread Mayur Barge 
*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  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
> 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 
> 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
>> 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
>>
>

Re: Error while migrating the Datastores from PostgreSQL to MongoDB

2020-10-16 Thread Julian Reschke 

Am 16.10.2020 um 12:39 schrieb Mayur Barge:

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


That's not what I suggested. You can't use "-cp" and "-jar" at the same
time. If the JAR file is not complete, you have to specify "-cp" *and*
specify the Main class.

Best regards, Julian

Re: Error while migrating the Datastores from PostgreSQL to MongoDB

2020-10-19 Thread Mayur Barge 
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  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 
> 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
>> 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 
>> 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
>>> 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
>>>
>>