All
Accepted answers
Muhammad Waseem · May 1, 2025 go to post

code below might help:

import iris

# sql statement
sql = "SELECT ID, Name, Age FROM Sample.Person WHERE Age = ?"
result = iris.sql.exec(sql, Myage)

for row in result:
    ## Unpack tuple directly
    id, name, age = row  
    #Access by index (0-based in this case)
    name = row[1]  # Name is 2nd column (index 1)
    
    # Print values
    print(f"ID: {id}, Name: {name}, Age: {age}")
Muhammad Waseem · Apr 5, 2025 go to post

Thanks @Evgeny Shvarov for sharing the Technological Bonuses Results.
Note that the iris-AgenticAI application now supports Vector Search, and the second article is also published.
 

Muhammad Waseem · Mar 10, 2025 go to post

Congratulations to all the winners and participants. Your articles were truly inspiring and showcased exceptional creativity and insight.

Muhammad Waseem · Mar 6, 2025 go to post

I found that the issue was actually related to the Python installation itself. After resolving the installation problem, the application is now working fine.

Thank you all for your help and support

Muhammad Waseem · Mar 2, 2025 go to post

IRIS for Windows (x86-64) 2024.2 (Build 247U) Tue Jul 16 2024 09:57:03 EDT [Health:7.2.0-3.m2024.1.2]

Muhammad Waseem · Mar 2, 2025 go to post

Hi @Guillaume Rongier 
I am getting the following error while calling iop on Windows
D:\temp\iop>iop -start
WARNING:root:Error importing pythonint312: irisinit failed
WARNING:root:Embedded Python not available
Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "D:\temp\iop\.venv\Scripts\iop.exe\__main__.py", line 4, in <module>
  File "d:\temp\iop\.venv\Lib\site-packages\iop\__init__.py", line 1, in <module>
    from iop._business_operation import _BusinessOperation
  File "d:\temp\iop\.venv\Lib\site-packages\iop\_business_operation.py", line 3, in <module>
    from iop._business_host import _BusinessHost
  File "d:\temp\iop\.venv\Lib\site-packages\iop\_business_host.py", line 8, in <module>
    from iop._decorators import input_serializer_param, output_deserializer
  File "d:\temp\iop\.venv\Lib\site-packages\iop\_decorators.py", line 3, in <module>
    from iop._dispatch import dispatch_deserializer, dispatch_serializer
  File "d:\temp\iop\.venv\Lib\site-packages\iop\_dispatch.py", line 15, in <module>
    def serialize_pickle_message(message: Any) -> iris.cls:
                                                  ^^^^^^^^
AttributeError: module 'iris' has no attribute 'cls'

Muhammad Waseem · Feb 28, 2025 go to post

Hi @Enrico Parisi, 
Thank you for your valuable feedback! I appreciate you pointing that out. I have reviewed the relevant documentation and have updated the article.

Muhammad Waseem · Jan 28, 2025 go to post

Congratulations to all, and thanks to the community for this recognition and all the support. 
 

Muhammad Waseem · Jan 22, 2025 go to post

Thank you to the community for this recognition. It is an honor to be acknowledged, and I extend my congratulations to all the winners.

Muhammad Waseem · Dec 27, 2024 go to post

Thank you, @Evgeny Shvarov for the insights!

I've been using Docker and IPM in my projects, and they’ve been incredibly convenient. Docker simplifies the development environment setup and makes collaboration much easier, while IPM streamlines the installation process with minimal steps. Both have significantly improved my workflow.

Muhammad Waseem · Dec 15, 2024 go to post

I also submitted my app for approval on OEx, but it's been several hours with no response.

Muhammad Waseem · Nov 23, 2024 go to post

Hi @Oliver Wilms, 
Iris-fhir-Client does not currently support the Epic FHIR sandbox server. It is designed to work with open FHIR servers. Epic FHIR sandbox servers require specific configurations/authentication methods that are outside the scope of what Iris-FHIR-Client supports at this time.

Muhammad Waseem · Nov 18, 2024 go to post

The $JAVA_HOME environment variable is set, even I have added the driver path to the classpath. In the terminal, I am able to run the following code successfully:"

import java.sql.DriverManager;

public class OracleJDBCTest {
    public static void main(String[] args) {
        try {
            // Load the Oracle JDBC driver
            Class.forName("oracle.jdbc.OracleDriver");
            System.out.println("Oracle JDBC Driver is installed and loaded successfully!
        } catch (ClassNotFoundException e) {
            System.out.println("Oracle JDBC Driver is NOT installed!");
            e.printStackTrace();
        }
    }
}


However, I’m still unable to connect from the IRIS SQL Gateway Connection.
I’m getting the following error for the first time after restarting the IRIS instance:

and after that I am getting the below error :

Thanks
 

Muhammad Waseem · Nov 18, 2024 go to post

Thank you for your suggestion! I have already checked the path and folder permissions, and everything seems to be in order.