#JDBC

Post a job Follow
6 Followers 路 161 Posts

Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database.

Currently could be downloaded from here.

Post a job Follow
New
Question Mauricio Sthandier 路 Apr 12

CREATE TABLE from another server query

hi 馃槉,

i'm able to LOAD DATA in IRIS from a rather complex, say Oracle's, query. It works pretty well but requires a target table created aforehand:

LOAD DATA FROM JDBC CONNECTION SOME_OTHER_SERVER QUERY 'complex query here' INTO TargetTable

is there a way to base such target table on the same query ? 
CREATE FOREIGN TABLE seems to require a column definition which I would prefer to be taken from the query
CREATE TABLE AS SELECT seems to be for local queries and other methods, like Linked Table Wizard or %SYSTEM.SQL.Schema.

#Documentation #Other #Data Import and Export #JDBC #Java #Mapping #SQL
1
0 34
New
Question Scott Roth 路 Apr 7

Difference between Extending EnsLib.SQL.Snapshot vs creating a Property for EnsLib.SQL.Snapshot

We are working on Disk Consolidation and looking at Class/Globals that are rather large and not being cleaned up by the nightly Purge process. We have implemented DeleteHelper - A Class to Help with Deleting Referenced Persistent Classes | IDC on any Custom Data Classes, and Business Processes (BPL).

We have a bunch of Data Classes, BPL's, and Operations that connect to external MS SQL Server using JDBC to query or write data to using Stored Procedures and Queries. All that Query external tables are using EnsLib.SQL.Snapshot, and this is being written to ^Ens.AppData which is not cleaned up.

#InterSystems IRIS for Health #Health Connect #InterSystems IRIS #Business Operation #Business Process (BPL) #JDBC
1
0 26
Question Scott Roth 路 Mar 12

Cleaning up EnsLib.SQL.Snapshot in BPL's

We are trying to track down significant growth within our Namespaces, one big culprit is Ens.AppData (EnsLib.SQL.Snapshot). 

Within many of our BPL's we use EnsLib.SQL.Snapshot to return Results from External SQL Stored Procedures or Query's. The same EnsLib.SQL.Snapshot context variable is used for many of these calls within a BPL. 

Is there something we should be doing at the end of the BPL to ensure that EnsLib.SQL.Snapshot gets cleaned up and purged from Ens.AppData?

#HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS #Business Process (BPL) #JDBC #ObjectScript #SQL #System Administration
1
0 38
Question Scott Roth 路 Mar 10

%SYS.Task.Definition to kick off Ens.BusinessService using EnsLib.SQL.InboundAdapter

How can I create a Task that tells a Ens.BusinessService to execute its SQL query using the EnsLib.SQL.InboundAdapter?

So far I have come up with

Class OSU.Workday.TerminationsTask Extends %SYS.Task.Definition
{

Parameter TaskName As STRING = "OSU - Workday Termination Update";

Method OnTask() As %Status
{
    try{
        // Call BusinessService
        set tSC = ##class(Ens.Director).CreateBusinessService("OSU.DataSource.Workday.TermService",.tService)

        if $IsObject(tService){
            set inputMessage = ##class(Ens.StringContainer).
#HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS #Business Service #JDBC #ObjectScript #SQL #System Administration
6
0 80
Question Luis Dell谩n 路 Mar 10

驴How to execute a stored procedure in a remote DB2 database?

How to execute a stored procedure in a remote DB2 database?

Hi Everyone,

I want to access a stored procedure in a remote DB2 database. The stored procedure in question is linked and receives a numeric value, returning a cursor with N number of rows. Sometimes the number of rows reaches hundreds of thousands, so I need to apply pagination.

I've been reading about the %ScrollableResultSet library, but it doesn't allow me to call a stored procedure.

Here's part of the code:
Set pValor=12345678
Set callSql="CALL Paquete.ClaseSpRemoto(?)"
Set rs=##class(%ScrollableResultSet).

#InterSystems IRIS #Databases #Interoperability #JDBC #Object Data Model #ObjectScript #SQL
0
0 43
Question Enrico Parisi 路 Feb 19

Expose %Stream property in JDBC as CLOB

I need to reproduce a table (in fact a view, but let's start with a simple table 馃槉) in IRIS as the currently used in Oracle.

I need to expose/project one column to JDBC as CLOB, in my class I have the corresponding property defined as:

Property GlobStream As %Stream.GlobalCharacter;

In JDBC this column is projected as LONGVARCHAR, this is compliant with the documentation but I need to project it as CLOB.

In addition, I'm no expert in JDBC but wit seems that LONGVARCHAR has a Maximum Length 32,700 characters in JDBC, not quite enough for an arbitrary stream.

#InterSystems IRIS #InterSystems IRIS for Health #JDBC #SQL
8
0 102
Question Hour Abdellatif 路 Jan 27

JDBC Connection Issue: Cache 2018.1 Access Denied

Hello Community,

I am facing a JDBC connection issue after migrating from Cach茅 2016 to Cach茅 2018.1. When I attempt to connect using the following connection settings:

CACHE_DATASOURCE_URL=jdbc:Cache://localhost:1972/TEST

CACHE_DB_USERNAME=test

CACHE_DB_PASSWORD=test
 

I consistently receive the following error:

[Cache JDBC] Communication link failure: Access Denied

This configuration worked perfectly with Cach茅 2016. I have verified the following:

  1. The namespace (TEST) exists and is correctly specified in the connection URL.

  2. The credentials (username: test, password: test) are correct.
#Cach茅 #Java #JDBC
7
1 119
Question Dmitrii Baranov 路 Dec 21, 2025

XDBC memory leaks

I have a business service that actively reads data from a remote Postgres database. OnProcessInput opens a XDBC (actually JDBC) connection, executes an SQL query, fetches several thousand rows, iterates the resultset, and closes the connection. On each iteration I also need to update each source row in the remote database using PreparedStatement.

In other words, in every OnProcessInput call I have a long running SELECT statement and several thousands small UPDATE statements.

#HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS #JDBC #Key Question #ODBC
11
0 153
Question Attila Toth 路 Nov 10, 2025

Foreign Table datatypes

Hello!

I'm trying to create some foreign tables to a PostgreSQL database. In some cases, columns with certain datatypes cannot be consumed by IRIS and the following error is thrown:

 [SQLCODE: <-237>:<Schema import for foreign table did not return column metadata>]

  [%msg: <Unkown data type returned by external database>]

For example: serial4 typed ID columns are typical examples. Is it possible, what's the best way of resolving these datatypes, which- seemingly- don't have proper JDBC metadata mappings?

#InterSystems IRIS #JDBC #SQL
0
0 75
Question Eugene.Forde 路 Aug 31, 2025

How can I integrate Google Cloud Pub/Sub with InterSystems IRIS (HealthShare)?

I鈥檝e been exploring options for connecting Google Cloud Pub/Sub with InterSystems IRIS/HealthShare, but I noticed that IRIS doesn鈥檛 seem to ship with any native inbound/outbound adapters for Pub/Sub. Out of the box, IRIS offers adapters for technologies like Kafka, HTTP, FTP, and JDBC, which are great for many use cases, but Pub/Sub appears to be missing from the list.

Has anyone here implemented such an integration successfully?

For example:

  • Would it make sense to leverage IRIS鈥檚 Business Service + REST API adapter to connect to Google鈥檚 Pub/Sub REST endpoints?
#HealthShare #InterSystems IRIS #API #Cloud #FTP #Google Cloud Platform (GCP) #JDBC #ObjectScript #Python #REST API
2
1 130
Question Kim Jiyong 路 May 15, 2025

How to set encoding configuration when using JDBC

Hello. Currently, we are developing using Cache 2018 version.
Our team is working on improving an existing legacy program so that it can also be used on the web.

Before asking my question, here is the development environment.

  • IDE: IntelliJ

  • Framework: Spring Boot, MyBatis

  • DB Connection: JDBC (using the library provided by InterSystems)

Currently, we are successfully mapping global data through the %PERSISTENT class and able to query it with SQL. However, the problem is that the retrieved "Korean" data is all broken.

#Cach茅 #Java #JDBC #Localization #SQL
8
0 314