Forum Stats

  • 3,734,240 Users
  • 2,246,920 Discussions
  • 7,857,197 Comments

Discussions

SQL File not found when running liquibase update from sqlcl

krow7
krow7 Member Posts: 4 Red Ribbon

Hi!

I'm facing a problem referencing my sql file in changelog when using sqlcl liquibase feature. Seems like current directory when I ran sqlcl is not added on the lookup list. You can see details on StackOverflow question: https://stackoverflow.com/questions/67690838/sql-file-not-found-when-running-liquibase-update-from-sqlcl

is it my configuration mistake or is there any bug? Any help appreciated! Feel free to ask for extra details!

Answers

  • Agustin Conejos
    Agustin Conejos Member Posts: 15 Green Ribbon

    you could paste the command your are using? the controller has to be on the same path you are calling the sqlcl or give the full path

  • krow7
    krow7 Member Posts: 4 Red Ribbon

    @User_UQ5VL,

    So here's my configuration:

    SQLCl installation:    C:\Oracle\sqlcl\
    Working dir:           C:\repos\odb\db-scripts\
    

    In the working dir I have the following files:

    • main.yaml - changelog file
    • test.sql - sql file to be called in main.yaml

    main.yaml contains:

    databaseChangeLog:
    
      - changeSet:
          id: 1
          author: some_author
          changes:
            - sqlFile:
                path: test.sql
                splitStatements: true
                endDelimiter: /
                stripComments: true
    

    test.sql contains:

    create or replace view asdas
    as
    select 1 val from dual
    /
    

    When I run liquibase update from sqlcl I get the following:

    C:\repos\odb\db-scripts>sql [email protected]
    Picked up JAVA_TOOL_OPTIONS: -Duser.language=en
    
    SQLcl: Release 20.4 Production on Tue May 25 18:03:50 2021
    
    Copyright (c) 1982, 2021, Oracle.  All rights reserved.
    
    Password? (**********?) ********
    Last Successful login time: Tue May 25 2021 18:03:55 +03:00
    
    Connected to:
    Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
    Version 19.7.0.0.0
    
    
    SQL> lb update -changelog main.yaml
    
    Processing has failed for your request.
    liquibase.exception.UnexpectedLiquibaseException: java.io.IOException: The file test.sql was not found in
        - C:\Oracle\jdbc\lib\ojdbc8.jar
        - C:\Oracle\jlib\orai18n-mapping.jar
        - C:\Oracle\jlib\orai18n-utility.jar
        - C:\Oracle\jlib\orai18n.jar
        - C:\Oracle\lib\ojdbc8.jar
        - C:\Oracle\modules\oracle.xdk\xmlparserv2.jar
        - C:\Oracle\rdbms\jlib\xdb6.jar
        - C:\Oracle\sqlcl\lib
        - C:\Oracle\sqlcl\lib\ST4.jar
        - C:\Oracle\sqlcl\lib\antlr-runtime.jar
        - C:\Oracle\sqlcl\lib\commons-codec.jar
        - C:\Oracle\sqlcl\lib\commons-logging.jar
        - C:\Oracle\sqlcl\lib\dbtools-common.jar
        - C:\Oracle\sqlcl\lib\dbtools-data.jar
        - C:\Oracle\sqlcl\lib\dbtools-http.jar
        - C:\Oracle\sqlcl\lib\dbtools-net.jar
        - C:\Oracle\sqlcl\lib\dbtools-sqlcl.jar
        - C:\Oracle\sqlcl\lib\ext
        - C:\Oracle\sqlcl\lib\ext\dbtools-liquibase.jar
        - C:\Oracle\sqlcl\lib\ext\dbtools-modeler-cli-ext.jar
        - C:\Oracle\sqlcl\lib\ext\dbtools-modeler-common.jar
        - C:\Oracle\sqlcl\lib\ext\liquibase-core.jar
        - C:\Oracle\sqlcl\lib\ext\migration-core.jar
        - C:\Oracle\sqlcl\lib\ext\migration-postgres.jar
        - C:\Oracle\sqlcl\lib\ext\snakeyaml-1.12.jar
        - C:\Oracle\sqlcl\lib\guava.jar
        - C:\Oracle\sqlcl\lib\httpclient.jar
        - C:\Oracle\sqlcl\lib\httpcore.jar
        - C:\Oracle\sqlcl\lib\httpmime.jar
        - C:\Oracle\sqlcl\lib\jackson-annotations.jar
        - C:\Oracle\sqlcl\lib\jackson-core.jar
        - C:\Oracle\sqlcl\lib\jackson-jr-objects.jar
        - C:\Oracle\sqlcl\lib\jackson-jr-stree.jar
        - C:\Oracle\sqlcl\lib\jansi.jar
        - C:\Oracle\sqlcl\lib\javax.json.jar
        - C:\Oracle\sqlcl\lib\jdbcrest.jar
        - C:\Oracle\sqlcl\lib\jline.jar
        - C:\Oracle\sqlcl\lib\ojdbc8.jar
        - C:\Oracle\sqlcl\lib\oraclepki.jar
        - C:\Oracle\sqlcl\lib\orai18n-collation.jar
        - C:\Oracle\sqlcl\lib\orai18n-mapping.jar
        - C:\Oracle\sqlcl\lib\orai18n-servlet.jar
        - C:\Oracle\sqlcl\lib\orai18n-utility.jar
        - C:\Oracle\sqlcl\lib\orai18n.jar
        - C:\Oracle\sqlcl\lib\orajsoda.jar
        - C:\Oracle\sqlcl\lib\osdt_cert.jar
        - C:\Oracle\sqlcl\lib\osdt_core.jar
        - C:\Oracle\sqlcl\lib\slf4j-api.jar
        - C:\Oracle\sqlcl\lib\slf4j-jdk14.jar
        - C:\Oracle\sqlcl\lib\sshd-common.jar
        - C:\Oracle\sqlcl\lib\sshd-contrib.jar
        - C:\Oracle\sqlcl\lib\sshd-core.jar
        - C:\Oracle\sqlcl\lib\xdb6.jar
        - C:\Oracle\sqlcl\lib\xmlparserv2-sans-jaxp-services.jar
        - C:\Oracle\sqlcl\lib\xmlparserv2.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\access-bridge-64.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\cldrdata.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\dnsns.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\jaccess.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\jfxrt.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\localedata.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\nashorn.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunec.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunjce_provider.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunmscapi.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunpkcs11.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\zipfs.jar
        - C:\jdbc\lib\ojdbc8.jar
        - C:\jlib\orai18n-mapping.jar
        - C:\jlib\orai18n-utility.jar
        - C:\jlib\orai18n.jar
        - C:\rdbms\jlib\xdb6.jar
        - C:\repos\odb\db-scripts\ST4-4.3.1.jar
        - C:\repos\odb\db-scripts\antlr-runtime-3.5.2.jar
        - C:\repos\odb\db-scripts\commons-codec-1.15.jar
        - C:\repos\odb\db-scripts\commons-logging-1.2.0.0.1.jar
        - C:\repos\odb\db-scripts\dbtools-common-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-data-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-http-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-net-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-sqlcl-20.4.1.jar
        - C:\repos\odb\db-scripts\guava-30.0-jre.jar
        - C:\repos\odb\db-scripts\httpclient-4.5.13.jar
        - C:\repos\odb\db-scripts\httpcore-4.4.13.jar
        - C:\repos\odb\db-scripts\httpmime-4.5.13.jar
        - C:\repos\odb\db-scripts\jackson-annotations-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-core-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-jr-objects-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-jr-stree-2.11.3.jar
        - C:\repos\odb\db-scripts\jansi-1.18.jar
        - C:\repos\odb\db-scripts\javax.activation-api-1.2.0.jar
        - C:\repos\odb\db-scripts\javax.json-1.1.4.jar
        - C:\repos\odb\db-scripts\jaxb-api-2.4.0-b180830.0359.jar
        - C:\repos\odb\db-scripts\jdbcrest-20.4.1.jar
        - C:\repos\odb\db-scripts\jline-2.14.6.jar
        - C:\repos\odb\db-scripts\low-level-api-13.0.0.jar
        - C:\repos\odb\db-scripts\ojdbc8-21.0.0.jar
        - C:\repos\odb\db-scripts\oraclepki-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-mapping-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-utility-21.0.0.jar
        - C:\repos\odb\db-scripts\orajsoda-1.1.3.jar
        - C:\repos\odb\db-scripts\osdt_cert-21.0.0.jar
        - C:\repos\odb\db-scripts\osdt_core-21.0.0.jar
        - C:\repos\odb\db-scripts\slf4j-api-1.7.30.jar
        - C:\repos\odb\db-scripts\slf4j-jdk14-1.7.30.jar
        - C:\repos\odb\db-scripts\sshd-common-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-contrib-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-core-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-scp-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-sftp-2.5.0.jar
        - C:\repos\odb\db-scripts\ucp-21.0.0.jar
        - C:\repos\odb\db-scripts\xdb6-21.0.0.jar
    Specifying files by absolute path was removed in Liquibase 4.0. Please use a relative path or add '/' to the classpath parameter.
    
    SQL>
    
    
    

    Even though I call sqlcl from the working dir, it cannot manage to find my test.sql file though it see main.yaml. Adding relativeToChangelogFile: true to changelog file doesn't help.

    I tried the same with just liquibase out of sqlcl and it worked.

  • krow7
    krow7 Member Posts: 4 Red Ribbon

    My guess is that sqlcl doesn't pass current working dir to liquibase so it can't find sql file

  • Agustin Conejos
    Agustin Conejos Member Posts: 15 Green Ribbon

    try to specify the full path

    - changeSet:
          id: ​1
         ​author: ​some_author
         ​changes:
           ​- sqlFile:
               ​path: C:\repos\odb\db-scripts\​test.sql
               ​splitStatements: ​true
               ​endDelimiter: ​/
               ​stripComments:
    

    For me to be honest i have only used .xml controllers no .yml

    maybe there is a parcing problem

    this article may help but i would suggest to try .xml controllers

    https://oracle-base.com/articles/misc/sqlcl-automating-your-database-deployments-using-sqlcl-and-liquibase

  • Agustin Conejos
    Agustin Conejos Member Posts: 15 Green Ribbon

    try to specify the full path

    - changeSet:
          id: ​1
         ​author: ​some_author
         ​changes:
           ​- sqlFile:
               ​path: C:\repos\odb\db-scripts\​test.sql
               ​splitStatements: ​true
               ​endDelimiter: ​/
               ​stripComments:
    

    For me to be honest i have only used .xml controllers no .yml

  • krow7
    krow7 Member Posts: 4 Red Ribbon

    @User_UQ5VL, thanks for the reply!

    I created XML controller file with lb gencontrolfile command. See controller.xml contents:

    <?xml version="1.0" encoding="UTF-8"?> 
    <databaseChangeLog
      xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                          http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.9.xsd">
        <changeSet author="tim" id="01_tab1_seq">
          <sqlFile dbms="oracle"
                   endDelimiter=";"
                   path="test.sql"
                   relativeToChangelogFile="true"
                   splitStatements="true"
                   stripComments="false"/>
        </changeSet>
    </databaseChangeLog> 
    

    Still no luck with it:

    SQL> lb update -changelog controller.xml
    
    
    Processing has failed for your request.
    liquibase.exception.UnexpectedLiquibaseException: java.io.IOException: The file test.sql was not found in
        - C:\Oracle\jdbc\lib\ojdbc8.jar
        - C:\Oracle\jlib\orai18n-mapping.jar
        - C:\Oracle\jlib\orai18n-utility.jar
        - C:\Oracle\jlib\orai18n.jar
        - C:\Oracle\lib\ojdbc8.jar
        - C:\Oracle\modules\oracle.xdk\xmlparserv2.jar
        - C:\Oracle\rdbms\jlib\xdb6.jar
        - C:\Oracle\sqlcl\lib
        - C:\Oracle\sqlcl\lib\ST4.jar
        - C:\Oracle\sqlcl\lib\antlr-runtime.jar
        - C:\Oracle\sqlcl\lib\commons-codec.jar
        - C:\Oracle\sqlcl\lib\commons-logging.jar
        - C:\Oracle\sqlcl\lib\dbtools-common.jar
        - C:\Oracle\sqlcl\lib\dbtools-data.jar
        - C:\Oracle\sqlcl\lib\dbtools-http.jar
        - C:\Oracle\sqlcl\lib\dbtools-net.jar
        - C:\Oracle\sqlcl\lib\dbtools-sqlcl.jar
        - C:\Oracle\sqlcl\lib\ext
        - C:\Oracle\sqlcl\lib\ext\dbtools-liquibase.jar
        - C:\Oracle\sqlcl\lib\ext\dbtools-modeler-cli-ext.jar
        - C:\Oracle\sqlcl\lib\ext\dbtools-modeler-common.jar
        - C:\Oracle\sqlcl\lib\ext\liquibase-core.jar
        - C:\Oracle\sqlcl\lib\ext\migration-core.jar
        - C:\Oracle\sqlcl\lib\ext\migration-postgres.jar
        - C:\Oracle\sqlcl\lib\ext\snakeyaml-1.12.jar
        - C:\Oracle\sqlcl\lib\guava.jar
        - C:\Oracle\sqlcl\lib\httpclient.jar
        - C:\Oracle\sqlcl\lib\httpcore.jar
        - C:\Oracle\sqlcl\lib\httpmime.jar
        - C:\Oracle\sqlcl\lib\jackson-annotations.jar
        - C:\Oracle\sqlcl\lib\jackson-core.jar
        - C:\Oracle\sqlcl\lib\jackson-jr-objects.jar
        - C:\Oracle\sqlcl\lib\jackson-jr-stree.jar
        - C:\Oracle\sqlcl\lib\jansi.jar
        - C:\Oracle\sqlcl\lib\javax.json.jar
        - C:\Oracle\sqlcl\lib\jdbcrest.jar
        - C:\Oracle\sqlcl\lib\jline.jar
        - C:\Oracle\sqlcl\lib\ojdbc8.jar
        - C:\Oracle\sqlcl\lib\oraclepki.jar
        - C:\Oracle\sqlcl\lib\orai18n-collation.jar
        - C:\Oracle\sqlcl\lib\orai18n-mapping.jar
        - C:\Oracle\sqlcl\lib\orai18n-servlet.jar
        - C:\Oracle\sqlcl\lib\orai18n-utility.jar
        - C:\Oracle\sqlcl\lib\orai18n.jar
        - C:\Oracle\sqlcl\lib\orajsoda.jar
        - C:\Oracle\sqlcl\lib\osdt_cert.jar
        - C:\Oracle\sqlcl\lib\osdt_core.jar
        - C:\Oracle\sqlcl\lib\slf4j-api.jar
        - C:\Oracle\sqlcl\lib\slf4j-jdk14.jar
        - C:\Oracle\sqlcl\lib\sshd-common.jar
        - C:\Oracle\sqlcl\lib\sshd-contrib.jar
        - C:\Oracle\sqlcl\lib\sshd-core.jar
        - C:\Oracle\sqlcl\lib\xdb6.jar
        - C:\Oracle\sqlcl\lib\xmlparserv2-sans-jaxp-services.jar
        - C:\Oracle\sqlcl\lib\xmlparserv2.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\access-bridge-64.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\cldrdata.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\dnsns.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\jaccess.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\jfxrt.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\localedata.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\nashorn.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunec.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunjce_provider.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunmscapi.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunpkcs11.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\zipfs.jar
        - C:\jdbc\lib\ojdbc8.jar
        - C:\jlib\orai18n-mapping.jar
        - C:\jlib\orai18n-utility.jar
        - C:\jlib\orai18n.jar
        - C:\rdbms\jlib\xdb6.jar
        - C:\repos\odb\db-scripts\ST4-4.3.1.jar
        - C:\repos\odb\db-scripts\antlr-runtime-3.5.2.jar
        - C:\repos\odb\db-scripts\commons-codec-1.15.jar
        - C:\repos\odb\db-scripts\commons-logging-1.2.0.0.1.jar
        - C:\repos\odb\db-scripts\dbtools-common-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-data-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-http-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-net-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-sqlcl-20.4.1.jar
        - C:\repos\odb\db-scripts\guava-30.0-jre.jar
        - C:\repos\odb\db-scripts\httpclient-4.5.13.jar
        - C:\repos\odb\db-scripts\httpcore-4.4.13.jar
        - C:\repos\odb\db-scripts\httpmime-4.5.13.jar
        - C:\repos\odb\db-scripts\jackson-annotations-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-core-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-jr-objects-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-jr-stree-2.11.3.jar
        - C:\repos\odb\db-scripts\jansi-1.18.jar
        - C:\repos\odb\db-scripts\javax.activation-api-1.2.0.jar
        - C:\repos\odb\db-scripts\javax.json-1.1.4.jar
        - C:\repos\odb\db-scripts\jaxb-api-2.4.0-b180830.0359.jar
        - C:\repos\odb\db-scripts\jdbcrest-20.4.1.jar
        - C:\repos\odb\db-scripts\jline-2.14.6.jar
        - C:\repos\odb\db-scripts\low-level-api-13.0.0.jar
        - C:\repos\odb\db-scripts\ojdbc8-21.0.0.jar
        - C:\repos\odb\db-scripts\oraclepki-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-mapping-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-utility-21.0.0.jar
        - C:\repos\odb\db-scripts\orajsoda-1.1.3.jar
        - C:\repos\odb\db-scripts\osdt_cert-21.0.0.jar
        - C:\repos\odb\db-scripts\osdt_core-21.0.0.jar
        - C:\repos\odb\db-scripts\slf4j-api-1.7.30.jar
        - C:\repos\odb\db-scripts\slf4j-jdk14-1.7.30.jar
        - C:\repos\odb\db-scripts\sshd-common-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-contrib-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-core-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-scp-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-sftp-2.5.0.jar
        - C:\repos\odb\db-scripts\ucp-21.0.0.jar
        - C:\repos\odb\db-scripts\xdb6-21.0.0.jar
    Specifying files by absolute path was removed in Liquibase 4.0. Please use a relative path or add '/' to the classpath parameter.
    
    
    SQL>
    
    
    

    And with absolute path (which apparently I can't use because of the message in output above):

    SQL> lb update -changelog controller.xml
    
    
    Processing has failed for your request.
    liquibase.exception.UnexpectedLiquibaseException: java.io.IOException: The file C:\repos\odb\db-scripts\test.sql was not found in
        - C:\Oracle\jdbc\lib\ojdbc8.jar
        - C:\Oracle\jlib\orai18n-mapping.jar
        - C:\Oracle\jlib\orai18n-utility.jar
        - C:\Oracle\jlib\orai18n.jar
        - C:\Oracle\lib\ojdbc8.jar
        - C:\Oracle\modules\oracle.xdk\xmlparserv2.jar
        - C:\Oracle\rdbms\jlib\xdb6.jar
        - C:\Oracle\sqlcl\lib
        - C:\Oracle\sqlcl\lib\ST4.jar
        - C:\Oracle\sqlcl\lib\antlr-runtime.jar
        - C:\Oracle\sqlcl\lib\commons-codec.jar
        - C:\Oracle\sqlcl\lib\commons-logging.jar
        - C:\Oracle\sqlcl\lib\dbtools-common.jar
        - C:\Oracle\sqlcl\lib\dbtools-data.jar
        - C:\Oracle\sqlcl\lib\dbtools-http.jar
        - C:\Oracle\sqlcl\lib\dbtools-net.jar
        - C:\Oracle\sqlcl\lib\dbtools-sqlcl.jar
        - C:\Oracle\sqlcl\lib\ext
        - C:\Oracle\sqlcl\lib\ext\dbtools-liquibase.jar
        - C:\Oracle\sqlcl\lib\ext\dbtools-modeler-cli-ext.jar
        - C:\Oracle\sqlcl\lib\ext\dbtools-modeler-common.jar
        - C:\Oracle\sqlcl\lib\ext\liquibase-core.jar
        - C:\Oracle\sqlcl\lib\ext\migration-core.jar
        - C:\Oracle\sqlcl\lib\ext\migration-postgres.jar
        - C:\Oracle\sqlcl\lib\ext\snakeyaml-1.12.jar
        - C:\Oracle\sqlcl\lib\guava.jar
        - C:\Oracle\sqlcl\lib\httpclient.jar
        - C:\Oracle\sqlcl\lib\httpcore.jar
        - C:\Oracle\sqlcl\lib\httpmime.jar
        - C:\Oracle\sqlcl\lib\jackson-annotations.jar
        - C:\Oracle\sqlcl\lib\jackson-core.jar
        - C:\Oracle\sqlcl\lib\jackson-jr-objects.jar
        - C:\Oracle\sqlcl\lib\jackson-jr-stree.jar
        - C:\Oracle\sqlcl\lib\jansi.jar
        - C:\Oracle\sqlcl\lib\javax.json.jar
        - C:\Oracle\sqlcl\lib\jdbcrest.jar
        - C:\Oracle\sqlcl\lib\jline.jar
        - C:\Oracle\sqlcl\lib\ojdbc8.jar
        - C:\Oracle\sqlcl\lib\oraclepki.jar
        - C:\Oracle\sqlcl\lib\orai18n-collation.jar
        - C:\Oracle\sqlcl\lib\orai18n-mapping.jar
        - C:\Oracle\sqlcl\lib\orai18n-servlet.jar
        - C:\Oracle\sqlcl\lib\orai18n-utility.jar
        - C:\Oracle\sqlcl\lib\orai18n.jar
        - C:\Oracle\sqlcl\lib\orajsoda.jar
        - C:\Oracle\sqlcl\lib\osdt_cert.jar
        - C:\Oracle\sqlcl\lib\osdt_core.jar
        - C:\Oracle\sqlcl\lib\slf4j-api.jar
        - C:\Oracle\sqlcl\lib\slf4j-jdk14.jar
        - C:\Oracle\sqlcl\lib\sshd-common.jar
        - C:\Oracle\sqlcl\lib\sshd-contrib.jar
        - C:\Oracle\sqlcl\lib\sshd-core.jar
        - C:\Oracle\sqlcl\lib\xdb6.jar
        - C:\Oracle\sqlcl\lib\xmlparserv2-sans-jaxp-services.jar
        - C:\Oracle\sqlcl\lib\xmlparserv2.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\access-bridge-64.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\cldrdata.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\dnsns.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\jaccess.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\jfxrt.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\localedata.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\nashorn.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunec.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunjce_provider.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunmscapi.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\sunpkcs11.jar
        - C:\Program Files\Java\jre1.8.0_271\lib\ext\zipfs.jar
        - C:\jdbc\lib\ojdbc8.jar
        - C:\jlib\orai18n-mapping.jar
        - C:\jlib\orai18n-utility.jar
        - C:\jlib\orai18n.jar
        - C:\rdbms\jlib\xdb6.jar
        - C:\repos\odb\db-scripts\ST4-4.3.1.jar
        - C:\repos\odb\db-scripts\antlr-runtime-3.5.2.jar
        - C:\repos\odb\db-scripts\commons-codec-1.15.jar
        - C:\repos\odb\db-scripts\commons-logging-1.2.0.0.1.jar
        - C:\repos\odb\db-scripts\dbtools-common-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-data-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-http-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-net-20.4.1.jar
        - C:\repos\odb\db-scripts\dbtools-sqlcl-20.4.1.jar
        - C:\repos\odb\db-scripts\guava-30.0-jre.jar
        - C:\repos\odb\db-scripts\httpclient-4.5.13.jar
        - C:\repos\odb\db-scripts\httpcore-4.4.13.jar
        - C:\repos\odb\db-scripts\httpmime-4.5.13.jar
        - C:\repos\odb\db-scripts\jackson-annotations-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-core-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-jr-objects-2.11.3.jar
        - C:\repos\odb\db-scripts\jackson-jr-stree-2.11.3.jar
        - C:\repos\odb\db-scripts\jansi-1.18.jar
        - C:\repos\odb\db-scripts\javax.activation-api-1.2.0.jar
        - C:\repos\odb\db-scripts\javax.json-1.1.4.jar
        - C:\repos\odb\db-scripts\jaxb-api-2.4.0-b180830.0359.jar
        - C:\repos\odb\db-scripts\jdbcrest-20.4.1.jar
        - C:\repos\odb\db-scripts\jline-2.14.6.jar
        - C:\repos\odb\db-scripts\low-level-api-13.0.0.jar
        - C:\repos\odb\db-scripts\ojdbc8-21.0.0.jar
        - C:\repos\odb\db-scripts\oraclepki-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-mapping-21.0.0.jar
        - C:\repos\odb\db-scripts\orai18n-utility-21.0.0.jar
        - C:\repos\odb\db-scripts\orajsoda-1.1.3.jar
        - C:\repos\odb\db-scripts\osdt_cert-21.0.0.jar
        - C:\repos\odb\db-scripts\osdt_core-21.0.0.jar
        - C:\repos\odb\db-scripts\slf4j-api-1.7.30.jar
        - C:\repos\odb\db-scripts\slf4j-jdk14-1.7.30.jar
        - C:\repos\odb\db-scripts\sshd-common-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-contrib-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-core-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-scp-2.5.0.jar
        - C:\repos\odb\db-scripts\sshd-sftp-2.5.0.jar
        - C:\repos\odb\db-scripts\ucp-21.0.0.jar
        - C:\repos\odb\db-scripts\xdb6-21.0.0.jar
    Specifying files by absolute path was removed in Liquibase 4.0. Please use a relative path or add '/' to the classpath parameter.
    
    
    SQL>
    


Sign In or Register to comment.