I'm trying to read an Access DB following these instructions: https://www.knime.com/forum/knime-general/how-to-connect-to-ms-access-database. The Database Connector Node works pretty well for all my databases but one.
I always get a "timed out" error when I try to connect to a certain database with a size of 29MB. It consists of many tables and different kinds of queries. I can connect to it by deleting only a few queries though.
Increasing the timeout (Preferences > KNIME > Databases) doesn't help at all. Even if I set it to 300 seconds for example I will get a timeout error after a few seconds only.
Is there any way to work around this? Or is the size of the DB simply too much for KNIME to handle? I would rather not delete some tables/queries to get a connection.
2018-01-18 14:31:04,845 : ERROR : KNIME-Worker-5 : Database Connector : Database Connector : 0:2 : Execute failed: Could not create connection to database: Connection to database 'jdbc:ucanaccess://***.accdb;showschema=true' timed out
2018-01-18 14:31:04,845 : DEBUG : KNIME-Worker-5 : Database Connector : Database Connector : 0:2 : Execute failed: Could not create connection to database: Connection to database 'jdbc:ucanaccess://***.accdb;showschema=true' timed out
java.sql.SQLException: Could not create connection to database: Connection to database 'jdbc:ucanaccess://***.accdb;showschema=true' timed out
at org.knime.base.node.io.database.connection.JDBCConnectorNodeModel.execute(JDBCConnectorNodeModel.java:126)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:567)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1128)
at org.knime.core.node.Node.execute(Node.java:915)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:561)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:95)
at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:179)
at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:110)
at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:328)
at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:204)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
Caused by: java.io.IOException: Connection to database 'jdbc:ucanaccess://***.accdb;showschema=true' timed out
at org.knime.core.node.port.database.connection.CachedConnectionFactory.getConnection(CachedConnectionFactory.java:245)
at org.knime.core.node.port.database.DatabaseConnectionSettings.createConnection(DatabaseConnectionSettings.java:439)
at org.knime.base.node.io.database.connection.JDBCConnectorNodeModel.execute(JDBCConnectorNodeModel.java:117)