Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

SQLCL 25.3 - migrating to GraalVM with JS plugin

For years I've been using sqlcl with OpenJDK11 and Java-Script scripts. While this still works on linux, it is no longer supported with SQLCL 25.3 according to the release notes and I'm unable to start sqlcl with my previuos JDK11.

So I tried to migrate to GraalVM 17 with the JS plugin. But even the most simple sample fails:

C:\Entwicklung\Projekte\ebs>gu list
ComponentId Version Component name Stability Origin
---------------------------------------------------------------------------------------------------------------------------------
graalvm 23.0.10 GraalVM Core Supported
icu4j 23.0.10 ICU4J Supported gds.oracle.com
js 23.0.10 Graal.js Supported gds.oracle.com
native-image 23.0.10 Native Image Early adopter
regex 23.0.10 TRegex Supported gds.oracle.com
C:\Entwicklung\Projekte\ebs>java -version
java version "17.0.17" 2025-10-21 LTS
Java(TM) SE Runtime Environment Oracle GraalVM 17.0.17+8.1 (build 17.0.17+8-LTS-jvmci-23.0-b76)
Java HotSpot(TM) 64-Bit Server VM Oracle GraalVM 17.0.17+8.1 (build 17.0.17+8-LTS-jvmci-23.0-b76, mixed mode, sharing)

C:\Entwicklung\Projekte\ebs>sqlcl\bin\sql /nolog

SQLcl: Release 25.3 Production auf Di. Nov. 11 11:41:34 2025

Copyright (c) 1982, 2025, Oracle. All rights reserved. Alle Rechte vorbehalten.

SQL> !type test.js
ctx.write('Start extraction ...\n');

SQL> script test.js
TypeError: invokeMember (write) on oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext failed due to: Unknown identifier: write at line number 1 at column number 1
SQL>

Any ideas? Is there kind of a migration guide for GraalVM and the js plugin? Or do I have to enable anything in addition?

Comments
Post Details
Added 6 days ago
8 comments
105 views