SQL - Query- failing

I have managed to make a successful connection to an SQL database ... but everytime I try to query it it fails.  (I have succeeded in getting RapdMiner and Alteryx to succeed).

I am connecting via Microsoft ODBC connection.

The SQL query is;

SELECT CustomerName FROM 
HistoricFutureFYPrimaryData
 
(I have tried SELECT *, but same problem)

 

 

The debug information is as follows;

DEBUG Database Reader clean output ports.

ERROR Database Reader Execute failed: Operation not yet supported
DEBUG Database Reader Execute failed: Operation not yet supported
java.lang.UnsupportedOperationException: Operation not yet supported
at sun.jdbc.odbc.JdbcOdbcResultSet.getNString(JdbcOdbcResultSet.java:6959)
at org.knime.core.node.port.database.DatabaseReaderConnection$DBRowIterator.readNString(DatabaseReaderConnection.java:830)
at org.knime.core.node.port.database.DatabaseReaderConnection$DBRowIterator.next(DatabaseReaderConnection.java:603)
at org.knime.core.node.ExecutionContext.createBufferedDataTable(ExecutionContext.java:248)
at org.knime.core.node.port.database.DatabaseReaderConnection.createTable(DatabaseReaderConnection.java:292)
at org.knime.base.node.io.database.DBReaderNodeModel.execute(DBReaderNodeModel.java:110)
at org.knime.core.node.NodeModel.execute(NodeModel.java:680)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:536)
at org.knime.core.node.Node.invokeNodeModelExecute(Node.java:1000)
at org.knime.core.node.Node.execute(Node.java:894)
at org.knime.core.node.workflow.SingleNodeContainer.performExecuteNode(SingleNodeContainer.java:895)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:100)
at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:124)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:239)
DEBUG WorkflowManager Database Reader 0:4 doBeforePostExecution
DEBUG NodeContainer Database Reader 0:4 has new state: POSTEXECUTE
DEBUG NodeContainer KNIME_project 0 has new state: EXECUTING
DEBUG WorkflowManager Database Reader 0:4 doAfterExecute - failure
DEBUG Database Reader reset

 

 

Can anyone spot the problem?

Thanks

Andrew

It looks like the JDBC driver you are using is not compatible with the database you are accessing. The database contains a column of type NCHAR, NVARCHAR, or LONGNVARCHAR but the driver has not implemented the method to access its content. You could try to use a newer driver or a driver specific to your database and not the generic ODBC driver.