SQL Query API for Java Knime Extension

Hi

I would like to either write a KNIME Java extension that in the execution of the node it will perform a SQL query. The input to the node would be the DB Connection port . I would like to setup the SQL Executor to be based on the input DB Connection port and then execute a SQL query in the extensions execute method.

Is the any examples of how to get access to the SQL Executor function?

Thanks
PJ

(Disclaimer: I am not a node developer! :slight_smile: )

This seems similar to what the DB SQL Executor node does. Maybe you could use that as a starting point?

2 Likes

@photon maybe you also take a look at the https://hub.knime.com/knime/extensions/org.knime.features.database/latest/org.knime.database.node.utility.injector.DBQueryInjectorNodeFactory/