Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can't export data with liquibase

cc13comOct 2 2024

Hi,

I try to follow the post from Jeff and run in an issue with the Step 2a running this command with my “DEBUG” table:

lb data -ouf debug-data.xml -include-objects DEBUG

After starting the command I see that there is an issue (a lot of scrolling text) but the SQLcl connection is closed very fast and then the following text will popup in VSC.

The terminal process "C:\Users\username\Downloads\VSCode-win32-x64-1.53.1\data\extensions\oracle.sql-developer-24.2.1-win32-x64\dbtools\jdk\bin\java.exe '--add-modules', 'jakarta.ws.rs,jakarta.annotation,jakarta.inject,jakarta.xml.bind', '-Djava.awt.headless=true', '-classpath', 'C:\Users\username\Downloads\VSCode-win32-x64-1.53.1\data\extensions\oracle.sql-developer-24.2.1-win32-x64\dbtools\lib\classpath\osdt_cert-21.12.0.0.230906.jar;C:\Users\username\Downloads\VSCode-win32-x64-1.53.1\data\extensions\oracle.sql-developer-24.2.1-win32-x64\dbtools\lib\classpath\osdt_core-21.12.0.0.230906.jar', '-p', 'C:\Users\username\Downloads\VSCode-win32-x64-1.53.1\data\extensions\oracle.sql-developer-24.2.1-win32-x64\dbtools\lib\modules;C:\Users\username\Downloads\VSCode-win32-x64-1.53.1\data\extensions\oracle.sql-developer-24.2.1-win32-x64\dbtools\sqlcl\lib\modules', '--add-opens', 'java.prefs/java.util.prefs=oracle.dbtools.common.all', '--add-opens', 'org.eclipse.parsson/org.eclipse.parsson=orajsoda', '-m', 'com.oracle.dbtools.app/com.oracle.dbtools.app.DatabaseToolsApplication', 'sql', '-name', 'DB23ai'" terminated with exit code: 70.

Here are some more connections details:

SQLcl: Release 24.2 Production on Wed Oct 02 11:56:27 2024

Copyright (c) 1982, 2024, Oracle. All rights reserved.

Last Successful login time: Mi Okt 02 2024 11:56:34 +02:00

Verbunden mit:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - Production
Version 23.6.0.24.07

Any idea how to solve?

Comments

where did you get a 23.6 database?

Also are you using the Execute via SQLcl button?

cc13com Oct 7 2024

Hi @thatjeffsmith-oracle ,

“where did you get a 23.6 database?!” I'm using the always free cloud instance in Frankfurt/Germany.

To run my command I used 2 ways with the same negative result. First is a right click on the connection and select “Open SQLcl” to have it in a terminal. But also with your way “Execute via SQLcl button” I run in the issue.

I was fast enough to copy the error message before the window is closed. It could be that I did not capture all the text.



SQLcl: Release 24.2 Production on Mon Oct 07 07:29:01 2024

Copyright (c) 1982, 2024, Oracle.  All rights reserved.

Last Successful login time: Mo Okt 07 2024 07:29:06 +02:00

Verbunden mit:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - Production
Version 23.6.0.24.07

2024-10-07T05:29:08.387Z ERROR   DBTU-01004: An unexpected error occurred

DBTU-01004: An unexpected error occurred. An unexpected exception, of type: java.lang.NoClassDefFoundError occurred. Please report this issue to product support 
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.cli.CommandLineException.of(CommandLineException.java:42)
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.cli.ErrorHandler.handleError(ErrorHandler.java:19)
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:100)
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.cli.CommandLineInterface.dispatch(CommandLineInterface.java:251)
        at com.oracle.dbtools.app@24.2.1/com.oracle.dbtools.app.DatabaseToolsApplication.main(DatabaseToolsApplication.java:43)
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.cli.Shell.execute(Shell.java:150)
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.cli.Shell.executeAndExit(Shell.java:180)
        at com.oracle.dbtools.app@24.2.1/com.oracle.dbtools.app.DatabaseToolsApplication.main(DatabaseToolsApplication.java:35)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/lang3/StringUtils
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.liquibase.core.ActiveCommand.loadSearchPath(ActiveCommand.java:307)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.liquibase.core.ActiveCommand.<init>(ActiveCommand.java:147)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.liquibase.core.ActiveCommand.createActiveCommand(ActiveCommand.java:425)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.scriptrunner.commands.liquibase.LbCommand.handleEvent(LbCommand.java:117)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:447)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:239)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:833)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:122)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
        at oracle.dbtools.common.all@24.2.1/oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
        at oracle.dbtools.sqlcl@24.2.1/oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.handleScriptOption(SqlCli.java:654)
        at oracle.dbtools.sqlcl@24.2.1/oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.initSqlcl(SqlCli.java:1161)
        at oracle.dbtools.sqlcl@24.2.1/oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1317)
        at oracle.dbtools.sqlcl@24.2.1/oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:372)
        at com.oracle.dbtools.sqlcl.app@24.2.1/com.oracle.dbtools.sqlcl.app.DatabaseToolsSqlCommandLineApp.run(DatabaseToolsSqlCommandLineApp.java:28)
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.cli.CommandLineInterface$Definition.lambda$invoker$0(CommandLineInterface.java:776)
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions$ImmutableRegistration.callIfMatches(Actions.java:325)
        at com.oracle.dbtools.utils.core@24.2.1/com.oracle.dbtools.utils.core.actions.Actions.dispatch(Actions.java:93)
        ... 5 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.lang3.StringUtils
        at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
        at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
        at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526)
        ... 23 more
DBTU-01004: An unexpected error occurred. An unexpected exception, of type: java.lang.NoClassDefFoundError occurred. Please report this issue to product support

Usage: dbtools [-dhV] <command>

Arguments:
1 - 3

Post Details

Added on Oct 2 2024
3 comments
131 views