#JDBC

Post a job Follow
6 Followers · 159 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 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 52
New
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 20
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 94