driver database error when running from file bat

[monica_bove]

I’m having trouble running simple knime workflows from bat files. the error message that is returned to me is in the attached file.
The same workflow if performed manually works without problems.
Do you have any idea how to solve the problem?
The knime version installed is 4.6.4

log_file.log (225.6 KB)

[ScottF]

Hi @monica_bove and welcome to the forum.

Can you check this topic, which seems similar to yours?

DB connector cannot run in batch mode

I want to schedule my workflow through batch mode and windows task scheduler. But when I run the workflow in batch mode, it show errors. The error message shows that the driver of DB connector cannot be found. I try to assign specific preference file, but it didn’t work either. I find that there is no driver information in my export preference file like “/instance/org.knime.database/drivers/” So how can I solve this problem? Bat file: Blockquote “C:\Users\cui.z.1\KNIME\knime.exe”^ -con…

[monica_bove]

I compared the preferences and they are identical. The error I get on the drivers is not on the single connection I use in the workflow but on all those present in knime.

[ScottF]

Can you check your knime.ini file? It’s possible that there are some missing lines that are needed. In particular, if these lines don’t exist, can you add them and try again?

--add-opens=java.base/sun.security.ssl=ALL-UNNAMED
--add-opens=java.base/sun.security.util=ALL-UNNAMED
--add-opens=java.xml/com.sun.org.apache.xerces.internal.parsers=ALL-UNNAMED
--add-opens=java.xml/com.sun.org.apache.xerces.internal.util=ALL-UNNAMED
--add-opens=java.security.jgss/sun.security.jgss.krb5=ALL-UNNAMED
--add-exports=java.security.jgss/sun.security.jgss=ALL-UNNAMED
--add-exports=java.security.jgss/sun.security.jgss.spi=ALL-UNNAMED
--add-exports=java.security.jgss/sun.security.krb5.internal=ALL-UNNAMED
--add-exports=java.security.jgss/sun.security.krb5=ALL-UNNAMED
--add-opens=java.base/sun.util.calendar=ALL-UNNAMED
--add-opens=java.base/java.lang=ALL-UNNAMED
--add-opens=java.base/java.lang.invoke=ALL-UNNAMED
--add-opens=java.base/java.net=ALL-UNNAMED
--add-opens=java.base/java.nio=ALL-UNNAMED
--add-opens=java.base/java.nio.channels=ALL-UNNAMED
--add-opens=java.base/java.util=ALL-UNNAMED
--add-opens=java.base/sun.nio.ch=ALL-UNNAMED
--add-opens=java.base/sun.nio=ALL-UNNAMED
--add-opens=java.desktop/javax.swing.plaf.basic=ALL-UNNAMED
--add-opens=java.base/sun.net.www.protocol.http=ALL-UNNAMED