Categorie archieven: Geen categorie

Your library is your paradise

EvROCS Geplaatst op door

Update 14-07-2021 I just tried SQLcl latest version 21.2. First results: The registering of my custom commands with below library doesn’t work anymore. Could be my bad, in which I’ll try to fix it, could be something in SQLcl. I don’t know yet, have to investigate as soon as I have the time. For now: Either don’t use this library, or stick to 21.1.1 until the root cause is fixed. Update 08-10-2021The above mentioned problem was not due to my code, so the library can be safely used. It’s caused by new stuff inside SQLcl.So, if you run javascript code and only receive one of these messages:“!ScriptCommand.1!”“JS Language engine not found”The quickest way to solve it is to install JDK. (Or better yet: GraalVM. See next update.) Update 14-04-2022On 07-04-2022 version 22.1 of SQLcl was released which ends support for Java 8.So, as of that version Java 11 is the … Lees verder →

Hit the road Jack, and don’t you come back no more….

EvROCS Geplaatst op door

In my blogpost “Being in command“, about custom commands I said that I couldn’t find a way to unregister  a registered custom command, other than restarting SQLcl.That is still true. I couldn’t.But Philipp Salvisberg could. He was able to find a way to do just that. That means that with his hard work as input, we are now able to Unregister a previously registered custom command.That makes it possible to register the command in an edited new version without the need to restart SQLcl. So, like Jack in the famous song, let’s try to kick a registered custom command out of our SQLcl house. Go straight to Introduction First of all: this post will deal with the code needed to unregister a custom command.In my humble opinion just, like registering a command, it takes too much code and effort to be considered user friendly.In my next blog post I will … Lees verder →