SDF Reader


I am intending to use the “SDF Reader” node to extract the Mol block and additional data fields from an SDF file and insert it into an Oracle table (Oracle / OracleDriver ojdbc8.jar) using the “DB Insert” node. While this works fine for the data fields, I cannot insert the Mol block into a CLOB or VARCHAR2 column. I am running into the following error:

ERROR DB Insert            0:8        Execute failed: Output type mapping is missing for column:
MOL (Molfile)

I mapped the Molfile column to CLOB, which did not solve the issue.

Any ideas, what I might be doing wrong?

Thank you for your help.

Hi @jrm1974

Welcome to the forum!
Unfortunately chemistry data types are not supported in the type mapping. However we have a ticket open for this, so it will be possible at some point in the future. Your request is added.
For now, the solution would be to convert the column to string before writing it to the database.

Hope that helps, sorry I don’t have a better answer.

1 Like

Hi Alice,

thank you very much for your reply. I tried coverting the MOL block to string before, but unfortunately that did not work either.

I used the node “Column Rename” and removed the type mapping from the node “DB Insert”

Doing so, I received a different error:

ERROR DB Insert 0:8 Execute failed: Output type mapping is missing for column:
MOL (Non-Native [interface, interface org.knime.chem.types.MolValue, interface, interface org.knime.chem.types.SdfValue, interface, interface])

The insert did not work for both CLOB and VARCHAR2 colums in Oracle

Do have any ideas, what I could have done wrong?

Thanks and best regards,


Hello @jrm1974,

try to avoid using Column Rename for converting column types. As you can see you got this Non-Native type… For conversion options take a look this topic:



Hello Ivan,

using the Java snippet as suggested in the linked topic, I have now been able to insert the MOL blocks into Oracle.

Thank you for your help!

Best regards,


1 Like

Hello Jurgen!

Glad to hear that :+1:


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.