Database looping node with Integer values

KNIME Analytics Platform
1

Hi,

 

I'm trying to use the database looping node. Database is hsqldb and driver is installed. The issue is the placeholder:

WHERE molid IN ('#PLACE_HOLDER_DO_NOT_EDIT#')

which leads to an exception:

java.sql.SQLSyntaxErrorException: incompatible data types in combination

Makes sense because the column molid is an integer an not a string.

I then tried removign the single quotes:

WHERE molid IN (#PLACE_HOLDER_DO_NOT_EDIT#)

this causes this error:

java.sql.SQLSyntaxErrorException: unexpected token: )

 

It works fine when the filter column is a string type:

WHERE smiles IN ('#PLACE_HOLDER_DO_NOT_EDIT#')

Can these be fixed so that also numeric filter columns are supported?

 

 

 

2

Unfortunately, the Database Looping node is limited to String as filter criteria. A work around is to use the Database Connector together with a Database Query node and Database Connection Reader and embed them into a loop using the TableRow to Variable Loop Start node. The query node can be configured in a way to use variables and therefore also to parameterize the WHERE-clause. Hope it helps.