Wrote an article how to have aliases in docker dev environment as well.

You are welcome, @Sylvain Guilbaud ! Sometimes "Less is more" indeed :)

Could you please check if you are using the latest IRIS JDBC driver?  In my case it was outdated so I updated it manually:

Hi @Sylvain Guilbaud! Had a similar issue (with the same "Socket is closed" message at least).

In my case the issue was in SSLConfig.properties file. It MUST be in the expected folder. On MacOS it is:

$ ls

SSLConfig.properties

dbeaver

$ pwd

/Applications/DBeaver.app/Contents/MacOS

That solved it! Thank you, @Robert Cemper !

I replaced $$$Lower() but still getting <SYNTAX>

Here is the alias in the file:

:alias enablebi do EnableDeepSee^%SYS.cspServer("/csp/"_$zcvt($namespace,"L"))

And here is SYNTAX i'm getting:

IRISAPP>:enablebi 
do EnableDeepSee^%SYS.cspServer("/csp/"_$zcvt($namespace,"L")

DO EnableDeepSee^%SYS.cspServer("/csp/"_$ZCVT($NAMESPACE,"L")
^
<SYNTAX>

Here is what I have in the alias:

IRISAPP>:enablebi
do EnableDeepSee^%SYS.cspServer("/csp/"_$zcvt($namespace,"L")

DO EnableDeepSee^%SYS.cspServer("/csp/"_$ZCVT($NAMESPACE,"L")
^
<SYNTAX>
IRISAPP>:alias
  enablebi              do EnableDeepSee^%SYS.cspServer("/csp/"_$zcvt($namespace,"L")

IRISAPP>

Interesting, if I set the alias in terminal as @Robert Cemper did it works.

Perhaps the issue is in line endings? Any ideas? 

@Robert Cemper, @Brett Saviano, thank you! Indeed, this is the thing! 

But even without macro it is a very powerful feature!
 

In fact I'm having a weird issue in docker: it looks like terminal doesn't read the last symbol from alias string. e.g. if I have the following alias (one liner to turn on IRISBI in a current namespace):

:alias enablebi do EnableDeepSee^%SYS.cspServer("/csp/"_$$$LOWER($namespace))

It results with following:

IRISAPP>:enablebi
do EnableDeepSee^%SYS.cspServer("/csp/"_$$$LOWER($namespace)

DO EnableDeepSee^%SYS.cspServer("/csp/"_$$$LOWER($namespace)
^
<SYNTAX>
IRISAPP>

Any thoughts @Robert Cemper @Dan Pasco ?

I confirm It works for docker as well! Exciting!

Thank you! Will give it a try!

Thanks a lot, @Chris Stewart !

Turned out I created SSLConfig.properties file in wrong place. I put it in a proper place (as adviced in the article) and all started working.

BTW,  in the latest DBeaver version 23.3.2, the issue with cumbersome Database/Schema is not an issue anymore - Database/Schema can be just USER.

Amazing, @Chris Stewart ! Thanks a lot!

And for Open Exchange too, please!

Patient viewer if possible.

Oh, that'd be amazing!
 

Just've tried it - doesn't work for me:

Hi @Momeena Ali !

Yes, you can, for sure! Don't forget to publish your application on Open Exchange in a form of GitHub or Gitlab repository as an open source.

If I'm not mistaken, iFind is a part of 'Basic' text search which and according to documentation it is not deprecated