Sure Ketan I cannot get the tool to connect to my H2 database. I am
getting this error message when I try to run the tool:
ERROR [main] DbSync:103 - null
java.sql.SQLException: Cannot load JDBC driver class ''org.h2.Driver''
at
org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:54)
at
org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:472)
at
org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:538)
at
org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753)
at com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:95)
at com.thoughtworks.go.dbsync.DbSync.export(DbSync.java:77)
at com.thoughtworks.go.dbsync.cli.Main.main(Main.java:46)
Caused by: java.lang.ClassNotFoundException: 'org.h2.Driver'
at
java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown Source)
at
java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(Unknown
Source)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
at
org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:49)
... 6 common frames omitted
java.lang.RuntimeException: java.sql.SQLException: Cannot load JDBC driver
class ''org.h2.Driver''
at com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:104)
at com.thoughtworks.go.dbsync.DbSync.export(DbSync.java:77)
at com.thoughtworks.go.dbsync.cli.Main.main(Main.java:46)
Caused by: java.sql.SQLException: Cannot load JDBC driver class
''org.h2.Driver''
at
org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:54)
at
org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:472)
at
org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:538)
at
org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753)
at com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:95)
... 2 more
Caused by: java.lang.ClassNotFoundException: 'org.h2.Driver'
at
java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown Source)
at
java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(Unknown
Source)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
at
org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:49)
... 6 more
This is what I am using to run the tool from an elevated command window:
gocd-database-migrator --insert --progress
--source-db-url='jdbc:h2:/h2/cruise'
--source-db-driver-class='org.h2.Driver' --source-db-user='go'
--source-db-password='g0get!t'
--target-db-url='jdbc:postgresql://localhost:5432/cruise'
--target-db-driver-class='org.postgresql.Driver'
--target-db-user='postgres' --target-db-password='postgres'
Thanks in advance for your help!
On Sunday, September 4, 2022 at 11:30:29 PM UTC-7 [email protected]
wrote:
> Can you elaborate what issues you faced with the migrator tool?
>
> - Ketan
>
>
>
> On Sat, Sep 3, 2022 at 4:39 PM Tim Stevens <[email protected]> wrote:
>
>> Hello all, still on GoCD 20.4.0. Has anyone successfully used the
>> gocd-database-migrator.1.0.0 tool? I have tried everything that I know to
>> get it to run and I simply cannot. I would be interested to know if anyone
>> has been able to use the tool successfully?
>>
>> On Sunday, August 28, 2022 at 6:16:50 AM UTC-7 Chad Wilson wrote:
>>
>>> Tim had already asked about upgrades in
>>> https://groups.google.com/g/go-cd/c/ugTXHPOXNoQ/m/tQ8ovKq8AQAJ and
>>> https://groups.google.com/g/go-cd/c/EuIqzYsl7mU/m/kkj8b_L3AwAJ - in May
>>> they were on 20.4.0, and I had suggested the best time to do a DB switch is
>>> probably during the 20.4.0 -> 20.5.0 upgrade since the use of that migrator
>>> tool is basically mandatory during that upgrade regardless of whether the
>>> plan is to stay on H2 or not (due to breaking change in H2 database
>>> version).
>>>
>>> But not sure if they have subsequently upgraded while keeping to H2 or
>>> not. I had assumed he had, but perhaps that was a mistake, so yeah - it
>>> would be useful to know.
>>>
>>> -Chad
>>>
>>> On Sun, Aug 28, 2022 at 8:42 PM Ketan Padegaonkar <[email protected]>
>>> wrote:
>>>
>>>> What version of GoCD are you using?
>>>>
>>>> On Fri, 26 Aug, 2022, 22:55 Tim Stevens, <[email protected]> wrote:
>>>>
>>>>> Hello, I have researched this question quite a bit, but am not finding
>>>>> anything that works. I would like to take the data in our GoCD H2
>>>>> database
>>>>> and upload it/convert it to a PostgreSQL database.
>>>>>
>>>>> Any help would be appreciated!
>>>>>
>>>>> Tim
>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "go-cd" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to [email protected].
>>>>> To view this discussion on the web visit
>>>>> https://groups.google.com/d/msgid/go-cd/ee37d34c-a591-4ce4-8e26-37fb39f4182an%40googlegroups.com
>>>>>
>>>>> <https://groups.google.com/d/msgid/go-cd/ee37d34c-a591-4ce4-8e26-37fb39f4182an%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "go-cd" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>>
>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/go-cd/CAMUPJd6nZqdW_rjZ-MANh%3Dh_bRZEB7qZxxenbpfQOLDUjR%3DV1A%40mail.gmail.com
>>>>
>>>> <https://groups.google.com/d/msgid/go-cd/CAMUPJd6nZqdW_rjZ-MANh%3Dh_bRZEB7qZxxenbpfQOLDUjR%3DV1A%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "go-cd" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>>
> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/go-cd/ff1d45dc-b65d-4943-9426-18df58ad00ffn%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/go-cd/ff1d45dc-b65d-4943-9426-18df58ad00ffn%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
You received this message because you are subscribed to the Google Groups
"go-cd" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/go-cd/cb9b3591-2557-4e3d-9038-64ce67f92b77n%40googlegroups.com.
