検索

文章
· 12 hr 前 阅读大约需 2 分钟

Cloud Services JDBC SQL Shell with sqlline

 

InterSystems Cloud JDBC SQL Shell

A simple way to connect, explore, and debug InterSytems Cloud Services over JDBC with sqlline.

 


This post backs the open exhange submission that offers slightly more detailed on how to get parked on an InterSystems Cloud sql prompt quickly.  Here will will connect to a single cloud sql over jdbc and perform some operations, and secondly connect to multiple and federate the sql to multiple deployments at once.

Quick Start

Going to keep this brief and hope it remains simple .

Get the app

https://github.com/sween/isc-cloud-jdbc-sql-shell

Download

  • Driver ☕
  • Certificate(s) for Deployments 📃

Build

cd isc-cloud-jdbc-sql-shell
docker build -t isc-cloud-jdbc-sql-shell .

Run

Fill out run.sh like its a form, includes credentials and jdbc url information

bash run.sh

sqlline

No sense in rehashing the extensive manual for sqlline once you are connected, but here is some example usage across a couple of InterSystems Cloud offers in the form of an article.

This is just an implementation of the great sqlline, with straightforward tls connectivity for simplicity and easy use.

Usage Examples

Session Logging

Here we will setup logging the shell to the output folder, and start interrogating the database.  This will end up on your local system when you are done with the session.

!set script /output/debug_omop_jdbc.log


Worth showing this as if you havent already picked up on it, there is a `!command` interface to sqlline you can find with !help.

Create Schema and Copy Table

Not earth shattering, but, you can see the result in the Portal... here we create a schema and copy a table from one schema to the newly created schema.

sween@pop-os:~/Desktop/OMOP/isc-cloud-sql-shell$ bash run.sh
Starting sqlline and connecting to:
  URL    : jdbc:IRIS://k8s-0a6bc2ca-a8e3f174-84fc3b8135-aa1cd181c9825c06.elb.us-east-1.amazonaws.com:443/USER/:::true
  Driver : com.intersystems.jdbc.IRISDriver
  User   : SQLAdmin

Transaction isolation level TRANSACTION_REPEATABLE_READ is not supported. Default (TRANSACTION_READ_UNCOMMITTED) will be used instead.
sqlline version 1.12.0
ISC > CREATE SCHEMA OMOPCDM54BAK;
No rows affected (0.091 seconds)
ISC > CREATE TABLE OMOPCDM54BAK.person AS SELECT * FROM OMOPCDM54.person;
1,101,000 rows affected (5.84 seconds)
ISC >

Federated SQL Across Deployments

Sorta earth shattering... while connected to the deployment in context when you launched it, also connect to another database, of a different type of offer and do federated sql against them !all.  There is a "certs" folder you can just go ahead and dump all of the certificates in there for the deployments at hand and rebuild the container at will.

sqlline supports `!connect` to add connections to your list so you can either select them, or do things against `!all`

🎉

讨论 (0)1
登录或注册以继续
摘要
· 13 hr 前

Publicações Desenvolvedores InterSystems, Novembro 17 - 23, 2025, Resumo

问题
· 14 hr 前

Routing Rule still shows connection from old rule when using Save As

I copied a Business Process router and did a Save As on its routing rule. I added the new routing rule to my new Business Process router.  However, when I click the green circle next to my new Business Process router it shows the old Business Process router connection.  Anyone know the cause and fix for this?  I found a old post that said to add a Route Alias. But that did not work. 

1 条新评论
讨论 (1)2
登录或注册以继续
摘要
· 16 hr 前

Final Call for Your Ideas! Last Chance to Join the Sweepstakes

Dear Developer Community Member,

This is a final call to share your ideas on improving the Initial Developer Experience in the InterSystems Ideas Portal!

If you haven’t submitted your suggestion yet, now’s the time. Whether it’s about onboarding, setup, documentation, or tutorials, your input can help shape a smoother and more inspiring start for new developers.

We’ll be selecting a random winner at the end of November, so don’t miss out on your chance to contribute and win a special prize!

Check out the details here.

We can’t wait to see your ideas!

文章
· 16 hr 前 阅读大约需 17 分钟

ObjectScriptで列挙体Likeなデータ型クラスを作ろう

最初のご挨拶

コミュニティの皆さま、初投稿になりますが、何か少しでも興味深い知見を共有できると幸いです。

今回の内容は、筆者が%Persistentを中心に据えたデータ構造管理の検討の過程で必要性を感じ行った、「列挙体」Likeな「データ型クラス」(%DataTypeのサブクラス)構築に関するレポートです。

内容面では、筆者が「データ型クラス」の特性に不勉強だったことに由来しての躓きに関するものも多くなりますが、ご容赦願います。
また、内容の中には、筆者が思い当たらなかった手段の活用により、よりシンプルに回避できた部分もある可能性が大いにございます。
そういった内容にお気づきの場合、ご指摘いただけますと大変ありがたく存じます。

讨论 (0)1
登录或注册以继续