JDBC | InterSystems Developer Community

Question

Renato Araujo · Mar 8, 2022

Is it possible to receive Oracle Object Type as an output from stored procedure? (java.sql.Types STRUCT)

Hello everyone!

I am writing a SQL CALL (using JDBC) to a stored procedure that outputs a structured object (Oracle Object).

However, the adapter method is not accepting the corresponding JDBC Data Type STRUCT for the output parameter, returning the following error:

#Interoperability #JDBC #SQL #InterSystems IRIS

0 0

0 492

Question

Scott Roth · Mar 28, 2023

Using JDBC Gateway to call External SQL Calls - Best Practices???

I am trying to pinpoint and troubleshoot an issue we have been seeing lately. We have several SQL Outbound Adapter Operations that are seeing issues trying to connect to our MS SQL Servers using the JDBC Gateway for calling insert, select, update, and stored procedure calls.

#JDBC #SQL #System Administration #Caché #Ensemble

0 0

0 312

Question

Kalle Päplow · Mar 29, 2023

Using the Intersystems Iris JDBC Driver for Caché Database to Set Connection Timeout

Hello,

I have a question regarding the Intersystems Caché Database and its jdbc driver. I need to set the connection timeout for the database, but I couldn't find any documentation stating that the jdbc driver for Caché supports setting the connection timeout. However, I noticed that the jdbc driver for the Intersystems Iris Database appears to support this feature.

My question is, can I use the Iris jdbc driver to set the connection timeout for the Caché Database?

The jdbc driver I use: cache-jdbc-2.0.0.jar

#JDBC #Caché

0 0

0 263

Question

Marcel den Ouden · Mar 30, 2023

OLEDB - ODBC bridge experiences

Hi,

Does anyone have experience with connecting to IRIS with OLEDB through an OLEDB-ODBC bridge? In this case the client can only speak OLEDB at this moment.

Regards,

Marcel

#JDBC #ODBC #Other

0 0

0 260

Question

Tani Frankel · Feb 1, 2024

OAuth Authentication for ODBC/JDBC?

Is it possible to authenticate an xDBC (ODBC/JDBC) connection to InterSystems IRIS via (a 3rd party) OAuth server?

For REST APIs this is possible, but could this be achieved with OAuth?

Out-of-the-box the ODBC/JDBC Drivers don't seem to have this option, but maybe some custom code could enable this? perhaps via Delegated Authentication and some OAuth classes customization, or some other way?

Has anyone done this already and can share how it was implemented, or someone with some guideline suggestions?

#Authentication #JDBC #OAuth2 #ODBC #Security #SQL #InterSystems IRIS

1 0

0 167