Knime database connection error

KNIME Analytics Platform
1

Hi all,

I am trying to run the attached workflow "as is" but when I open it I got the following errors:

WARN  Database Reader      0:1        Could not determine table spec from database query: merlot.ebi.ac.uk

WARN  Database Reader      0:108      Could not determine table spec from database query: mysql-chembl-pubmed

How can I fix this error?

Thanks for your help

Renato

 

 

2

Hi all,

for some reason the workflow wasn't attached in the previous post, so I am posting again my problem.

 

I am trying to run the attached workflow "as is" but when I open it I got the following errors:

WARN  Database Reader      0:1        Could not determine table spec from database query: merlot.ebi.ac.uk

WARN  Database Reader      0:108      Could not determine table spec from database query: mysql-chembl-pubmed

How can I fix this error?

Thanks for your help

Renato

3

Hi Renato,

I guess KNIME can not connect to the defined DB. Do you have access to the Oracle database from the network you are connected to with the PC you are running KNIME on? To test it you can try to ping the database server. The database is also an Oracle db so you will need to register the apropriate JDBC driver once in your KNIME installation to connect to an Oracle db. For details about this have a look at the database documentation.

Bye,

Tobias