Node Integration to DB Connector

[Keurkyyy]

Hi,

I developed a Node that runs a sql statement on a database after establishing a connection to it.

The next step would be to exclude the database connection from this node to be able to connect to any database via the according database connector node.

Is there any possibility to get the source code of the Node DB Query Reader or DB Table Selector?

It would help me a lot understanding how I need to develop my node.

Thank you!

[gab1one]

Hi @Keurkyyy
The sources for the DB nodes are not public on github /bitbucket,
but you can access them as described here:

Source code for Call Workflow nodes

Hi @jcmozzic, The source code has been released with the 4.1 release, the repository is not public yet, but you can access the code via the target platform. To do this you need to follow these steps: Switch to the 2019-12 branch in the knime-sdk-setup repository Chose the KNIME-AP-complete.target target platform definition file and set it as your target platform Open the Plug-ins view in your eclipse and click on Add All Plug-ins to Java Workspace Scope: [Screenshot%20from%202019-12-20%201…

best,
Gabriel

[Keurkyyy]

Hi Gabriel,

thank you, I could find and open the classes mentioned in your instruction.
Unfortunately, I receive the following error when I try to open the classes of the DB Query Reader node:

Do you have an idea what might be the problem here?

[gab1one]

Hey @Keurkyyy

Do you have install sources checked in the target platform configuration?

best,
Gabriel

[Keurkyyy]

I had to switch to the nightly build, then it worked fine.
Thank you!