Connecting to Access DB

KNIME Analytics Platform
1

Hello,

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. 

 

Help is much appreciated!

Michael

2

Hi Michael,

Can you please post the error message from your knime.log? 29 MB should not be too big...

Cheers,

Roland

3

Hi Roland,

here's a little excerpt from the log:

 

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)

 

Cheers,

Michael