{"id":774,"date":"2024-11-06T12:18:24","date_gmt":"2024-11-06T11:18:24","guid":{"rendered":"https:\/\/ilmarkerm.eu\/blog\/?p=774"},"modified":"2024-11-06T12:18:24","modified_gmt":"2024-11-06T11:18:24","slug":"ordsgraphql-with-graalvm-21-for-dbas","status":"publish","type":"post","link":"https:\/\/ilmarkerm.eu\/blog\/2024\/11\/ordsgraphql-with-graalvm-21-for-dbas\/","title":{"rendered":"ORDS+GraphQL with GraalVM 21, for DBAs"},"content":{"rendered":"\n

I’m forced to write my first JavaScript related post \ud83d\ude41 Oh, well.<\/p>\n\n\n\n

ORDS version at the time of writing is 24.3.<\/p>\n\n\n\n

Oracle Rest Data Services (ORDS) does support (currently read-only) GraphQL protocol for serving data from Oracle rest enabled tables. You can read more about it here: https:\/\/oracle-base.com\/articles\/misc\/oracle-rest-data-services-ords-graphql<\/a><\/p>\n\n\n\n

To get GraphQL support working, ORDS need to be running using GraalVM JDK – but it’s not as simple as switching the JDK – GraalVM also needs to support JavaScript polyglot engine. When I started looking into this world I was properly confused, starting with naming – ORDS 24.3 installation checklist still requires GraalVM Enterprise Edition<\/a> and when going to search for it find man-bear-pigs like GraalVM-EE-23-for-JDK-17. Properly confusing for a non-developer like me.<\/p>\n\n\n\n

Luckily naming has been significantly simplified recently and GraalVM EE is dead<\/a><\/p>\n\n\n\n

Naming starting from GraalVM for JDK21 is simplified, but what has gone much more complicated is installing JavaScript polyglot libraries for GraalVM. With GraalVM for JDK 17 there was a command “gu install” for it, but it has been removed starting from GraalVM for JDK 21<\/a>.<\/p>\n\n\n\n

ORDS installation checklist 24.3 acknowledges it<\/a>, but then gives some strange XML code on how to install them<\/a>. Not helpful for non-developers, like me. This XML is intended to describe dependencies for Java project (using Maven), so during build the dependencies would be fetched automatically. But I have nothing to build – GraphQL support is already in ORDS, I just need the dependencies downloaded.<\/p>\n\n\n\n

I think, if the extra libraries are needed for ORDS built in functionality to work, ORDS should include them by default.<\/p>\n\n\n\n

Installation steps<\/h2>\n\n\n\n

I know pretty much all software can be downloaded using Oracle provided yum repositories, but here I’m doing everything manually, to be able to control the versions precisely. And not to mess with RPM-s, unzipping this is so much easier and predictable and more usable across all possible Linux distributions.<\/p>\n\n\n\n

All software is placed under \/home\/ords<\/strong> in my example.<\/p>\n\n\n\n

First lets download GraalVM for JDK 21 itself. Oracle has started to offer non-website-clicking “script friendly” URLs that always point to the latest version, you can get them here<\/a>. I’m not going to use ANY latest URL Oracle offers on purpose, since I’m an automation guy I need to be able to download predictable and internally tested versions of the software and be able to validate the downloaded software against known checksum value.<\/strong><\/p>\n\n\n\n

Download the software, all versions are current at the time of writing, but of course are very soon out of date<\/p>\n\n\n\n

# GraalVM for JDK21\nhttps://download.oracle.com\/graalvm\/21\/archive\/graalvm-jdk-21.0.5_linux-x64_bin.tar.gz\n\n# Maven\nhttps:\/\/dlcdn.apache.org\/maven\/maven-3\/3.9.9\/binaries\/apache-maven-3.9.9-bin.tar.gz\n\n# ORDS\nhttps:\/\/download.oracle.com\/otn_software\/java\/ords\/ords-24.3.0.262.0924.zip<\/code><\/pre>\n\n\n\n
In Ansible something like this, also unzipping them. Take it as an example, and not copy it blindly<\/p>\n\n\n\n
# Facts\ngraalvm_download_url: \"https:\/\/download.oracle.com\/graalvm\/21\/archive\/graalvm-jdk-21.0.5_linux-x64_bin.tar.gz<\/a>\"\ngraalvm_download_checksum: \"sha256:c1960d4f9d278458bde1cd15115ac2f0b3240cb427d51cfeceb79dab91a7f5c9\"\ngraalvm_install_dir: \"{{ ords_install_base }}\/graalvm\"\n\nmaven_download_url: \"https:\/\/dlcdn.apache.org\/maven\/maven-3\/3.9.9\/binaries\/apache-maven-3.9.9-bin.tar.gz\"\nmaven_download_checksum: \"sha512:a555254d6b53d267965a3404ecb14e53c3827c09c3b94b5678835887ab404556bfaf78dcfe03ba76fa2508649dca8531c74bca4d5846513522404d48e8c4ac8b\"\nmaven_install_dir: \"{{ ords_install_base }}\/maven\"\n\nords_download_url: \"https:\/\/download.oracle.com\/otn_software\/java\/ords\/ords-24.3.0.262.0924.zip<\/a>\"\nords_installer_checksum: \"sha1:6e8d9b15faa232911fcff367c99ba696389ceddc\"\nords_install_dir: \"{{ ords_install_base }}\/ords\"\nords_install_base: \"\/home\/ords\"\n\n# Tasks\n- name: Download GraalVM\n  ansible.builtin.get_url:\n      url: \"{{ graalvm_download_url }}\"\n      dest: \"{{ ords_install_base }}\/graalvm.tar.gz\"\n      checksum: \"{{ graalvm_download_checksum }}\"\n      use_proxy: \"{{ 'yes' if http_proxy is defined and http_proxy else 'no' }}\"\n  environment:\n      https_proxy: \"{{ http_proxy }}\"\n  register: graalvm_downloaded\n- name: Unzip GraalVM\n  ansible.builtin.unarchive:\n      remote_src: yes\n      src: \"{{ ords_install_base }}\/graalvm.tar.gz\"\n      dest: \"{{ graalvm_install_dir }}\"\n      extra_opts:\n          - \"--strip-components=1\"\n  when: graalvm_downloaded is changed\n# Download maven\n- name: Download Maven\n  ansible.builtin.get_url:\n      url: \"{{ maven_download_url }}\"\n      dest: \"{{ ords_install_base }}\/maven.tar.gz\"\n      checksum: \"{{ maven_download_checksum }}\"\n      use_proxy: \"{{ 'yes' if http_proxy is defined and http_proxy else 'no' }}\"\n  environment:\n      https_proxy: \"{{ http_proxy }}\"\n  register: maven_downloaded\n- name: Unzip maven\n  ansible.builtin.unarchive:\n      remote_src: yes\n      src: \"{{ ords_install_base }}\/maven.tar.gz\"\n      dest: \"{{ maven_install_dir }}\"\n      extra_opts:\n          - \"--strip-components=1\"\n  when: maven_downloaded is changed\n# Download ORDS\n- name: Download ORDS\n  ansible.builtin.get_url:\n      url: \"{{ ords_download_url }}\"\n      dest: \"{{ ords_install_base }}\/ords-latest.zip\"\n      checksum: \"{{ ords_installer_checksum }}\"\n      use_proxy: \"{{ 'yes' if http_proxy is defined and http_proxy else 'no' }}\"\n  environment:\n      https_proxy: \"{{ http_proxy }}\"\n  register: ords_downloaded\n- name: Unzip ORDS installer\n  ansible.builtin.unarchive:\n      remote_src: yes\n      src: \"{{ ords_install_base }}\/ords-latest.zip\"\n      dest: \"{{ ords_install_dir }}\"\n  when: ords_downloaded is changed<\/code><\/pre>\n\n\n\n
Now the complicated part, adding GraalVM JavaScript polyglot libraries<\/h2>\n\n\n\n
Create pom.xml file in some directory with contents. 24.1.1 is the current JavaScript engine version, you can see the available versions in https:\/\/mvnrepository.com\/artifact\/org.graalvm.polyglot\/polyglot<\/a><\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n  <modelVersion>4.0.0<\/modelVersion>\n  <groupId>eu.ilmarkerm.ords<\/groupId>\n  <artifactId>ords-graaljs-download<\/artifactId>\n  <version>1.1.1<\/version>\n  <url>https:\/\/ilmarkerm.eu<\/url>\n  <name>POM to download GraalVM JavaScript engine<\/name>\n  <dependencies>\n    <dependency>\n        <groupId>org.graalvm.polyglot<\/groupId>\n        <artifactId>polyglot<\/artifactId>\n        <version>24.1.1<\/version>\n    <\/dependency>\n    <dependency>\n        <groupId>org.graalvm.polyglot<\/groupId>\n        <!-- Language: js -->\n        <artifactId>js<\/artifactId>\n        <version>24.1.1<\/version>\n        <type>pom<\/type>\n    <\/dependency>\n  <\/dependencies>\n<\/project><\/code><\/pre>\n\n\n\n
Execute maven to download the required libraries and place them under ORDS libraries<\/p>\n\n\n\n
\/home\/ords\/maven\/bin\/mvn dependency:copy-dependencies -DoutputDirectory=\/home\/ords\/ords\/lib\/ext -DuseBaseVersion=true<\/code><\/pre>\n\n\n\n
It will download files like these (polyglot 24.1.1):<\/p>\n\n\n\n
collections-24.1.1.jar\nicu4j-24.1.1.jar\njniutils-24.1.1.jar\njs-language-24.1.1.jar\nnativebridge-24.1.1.jar\nnativeimage-24.1.1.jar\npolyglot-24.1.1.jar\nregex-24.1.1.jar\ntruffle-api-24.1.1.jar\ntruffle-compiler-24.1.1.jar\ntruffle-enterprise-24.1.1.jar\ntruffle-runtime-24.1.1.jar\nword-24.1.1.jar<\/code><\/pre>\n\n\n\n
Start ORDS (using GraalVM JDK) and then ORDS support for GraphQL is ready to be used.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
I’m not a java developer, so things might be wrong here \ud83d\ude42<\/p>\n\n\n\n
But I do hope the situation improves over the next couple of ORDS versions.<\/p>\n","protected":false},"excerpt":{"rendered":"
I’m forced to write my first JavaScript related post \ud83d\ude41 Oh, well. ORDS version at the time of writing is 24.3. Oracle Rest Data Services (ORDS) does support (currently read-only) GraphQL protocol for serving data from Oracle rest enabled tables. You can read more about it here: https:\/\/oracle-base.com\/articles\/misc\/oracle-rest-data-services-ords-graphql To get GraphQL support working, ORDS need […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[16,4,66],"class_list":["post-774","post","type-post","status-publish","format-standard","hentry","category-blog-entry","tag-java","tag-oracle","tag-ords"],"_links":{"self":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/comments?post=774"}],"version-history":[{"count":5,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/774\/revisions"}],"predecessor-version":[{"id":779,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/774\/revisions\/779"}],"wp:attachment":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/media?parent=774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/categories?post=774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/tags?post=774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}