SQL Query API for Java Knime Extension

[photon]

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

[ScottF]

(Disclaimer: I am not a node developer! )

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

[mlauber71]

@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/

Database Operations – rs1