I opened KNIME debug mode.
The knime.log massage is here:
Blockquote
2019-04-16 00:58:44,785 : DEBUG : main : Node : Database Connector : 0:2 : reset
2019-04-16 00:58:44,785 : DEBUG : main : Node : Database Connector : 0:2 : clean output ports.
2019-04-16 00:58:44,796 : DEBUG : main : NodeContainer : Database Connector : 0:2 : Database Connector 0:2 has new state: IDLE
2019-04-16 00:58:44,817 : DEBUG : main : Node : Database Connector : 0:2 : Configure succeeded. (Database Connector)
2019-04-16 00:58:44,817 : DEBUG : main : NodeContainer : Database Connector : 0:2 : Database Connector 0:2 has new state: CONFIGURED
2019-04-16 00:58:47,535 : DEBUG : main : ExecuteAction : : : Creating execution job for 1 node(s)…
2019-04-16 00:58:47,535 : DEBUG : main : NodeContainer : : : Database Connector 0:2 has new state: CONFIGURED_MARKEDFOREXEC
2019-04-16 00:58:47,536 : DEBUG : main : NodeContainer : : : Database Connector 0:2 has new state: CONFIGURED_QUEUED
2019-04-16 00:58:47,536 : DEBUG : main : NodeContainer : : : KNIME_project 0 has new state: EXECUTING
2019-04-16 00:58:47,536 : DEBUG : KNIME-Worker-5 : WorkflowManager : Database Connector : 0:2 : Database Connector 0:2 doBeforePreExecution
2019-04-16 00:58:47,537 : DEBUG : KNIME-Worker-5 : NodeContainer : Database Connector : 0:2 : Database Connector 0:2 has new state: PREEXECUTE
2019-04-16 00:58:47,537 : DEBUG : KNIME-Worker-5 : WorkflowManager : Database Connector : 0:2 : Database Connector 0:2 doBeforeExecution
2019-04-16 00:58:47,537 : DEBUG : KNIME-Worker-5 : NodeContainer : Database Connector : 0:2 : Database Connector 0:2 has new state: EXECUTING
2019-04-16 00:58:47,541 : DEBUG : KNIME-Worker-5 : WorkflowDataRepository : Database Connector : 0:2 : Adding handler 53664258-5221-4a36-8832-db2f355aefaa (Database Connector 0:2: ) - 1 in total
2019-04-16 00:58:47,541 : DEBUG : KNIME-WFM-Parent-Notifier : NodeContainer : : : ROOT has new state: EXECUTING
2019-04-16 00:58:47,542 : DEBUG : KNIME-Worker-5 : LocalNodeExecutionJob : Database Connector : 0:2 : Database Connector 0:2 Start execute
2019-04-16 00:58:47,567 : DEBUG : KNIME-Worker-5 : NodeContext : Database Connector : 0:2 : Workflow user found: Administrator
2019-04-16 00:58:47,567 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Try to lock key to obtain connection: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,567 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Create new connection for key: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,567 : DEBUG : KNIME-Worker-5 : DatabaseDriverLoader : Database Connector : 0:2 : Database driver retrieved from user defined drivers: oracle.jdbc.driver.OracleDriverDriver info: Driver class name: oracle.jdbc.driver.OracleDriver major version: 1 minor version: 0 jdbc compliant: true
2019-04-16 00:58:47,567 : DEBUG : pool-5-thread-2 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Opening database connection to “jdbc:oracle:thin:@10.60.20.101:1521:orcl”…
2019-04-16 00:58:47,711 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Add connection to map for key: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,711 : DEBUG : KNIME-Worker-5 : NodeContext : Database Connector : 0:2 : Workflow user found: Administrator
2019-04-16 00:58:47,711 : DEBUG : KNIME-Worker-5 : DatabaseConnectionSettings : Database Connector : 0:2 : Try to lock key for stmt execution: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,712 : DEBUG : KNIME-Worker-5 : DatabaseConnectionSettings : Database Connector : 0:2 : Check connection for key: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,712 : DEBUG : KNIME-Worker-5 : OracleUtility : Database Connector : 0:2 : java.sql.Connection#isValid throws error: oracle.jdbc.driver.OracleConnection.isValid(I)Z. Executing simple “SELECT 1” statement to check validity from now on.
java.lang.AbstractMethodError: oracle.jdbc.driver.OracleConnection.isValid(I)Z
at org.knime.core.node.port.database.DatabaseUtility.isValid(DatabaseUtility.java:360)
at org.knime.core.node.port.database.DatabaseConnectionSettings.execute(DatabaseConnectionSettings.java:673)
at org.knime.base.node.io.database.connection.JDBCConnectorNodeModel.execute(JDBCConnectorNodeModel.java:113)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:567)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1186)
at org.knime.core.node.Node.execute(Node.java:973)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:559)
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)
2019-04-16 00:58:47,716 : DEBUG : KNIME-Worker-5 : DatabaseConnectionSettings : Database Connector : 0:2 : Invalid or closed connection found. Retry counter: 1. Retry to get valid connection for key: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,716 : DEBUG : KNIME-Worker-5 : NodeContext : Database Connector : 0:2 : Workflow user found: Administrator
2019-04-16 00:58:47,716 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Try to lock key to obtain connection: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,716 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Connection found for key: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,719 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Invalid connection found in cache with key: ConnectionKey [db-user=mj01, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,719 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Closing connection with key: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,721 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Removing closed connection from cache with key: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,721 : DEBUG : KNIME-Worker-5 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Create new connection for key: ConnectionKey [db-user=test, db-name=jdbc:oracle:thin:@10.60.20.101:1521:orcl, wf-user=Administrator]
2019-04-16 00:58:47,721 : DEBUG : KNIME-Worker-5 : DatabaseDriverLoader : Database Connector : 0:2 : Database driver retrieved from user defined drivers: oracle.jdbc.driver.OracleDriverDriver info: Driver class name: oracle.jdbc.driver.OracleDriver major version: 1 minor version: 0 jdbc compliant: true
2019-04-16 00:58:47,721 : DEBUG : pool-5-thread-2 : RegisteredDriversConnectionFactory : Database Connector : 0:2 : Opening database connection to “jdbc:oracle:thin:@10.60.20.101:1521:orcl”…
…
Blockquote
but ,I don’t known what’s the meaning of the DEBUG message.
Could you find the reason of the oracle connection error?
Thanks a lot.