Hi Team,
I am getting following error while executing example workflow from example server for Python Script (DB) node. Please help.
ERROR Python Script (DB) 2:8 Execute failed: Software caused connection abort: socket write error
ERROR PythonKernel D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\PythonKernel.py:40: FutureWarning: The pandas.tslib module is deprecated and will be removed in a future version.
from pandas.tslib import Timestamp
Traceback (most recent call last):
File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\PythonKernel.py", line 1047, in <module>
run()
File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\PythonKernel.py", line 214, in run
put_sql(command)
File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\PythonKernel.py", line 318, in put_sql
db_util = DBUtil(sql)
File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\DBUtil.py", line 39, in __init__
sql.jars)
File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\jaydebeapi.py", line 324, in connect
jconn = _jdbc_connect(jclassname, jars, libs, *driver_args)
File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\jaydebeapi.py", line 132, in _jdbc_connect_jpype
jvm_path = jpype.getDefaultJVMPath()
File "D:\Program Files\Anaconda2\lib\site-packages\jpype\_core.py", line 114, in get_default_jvm_path
return finder.get_jvm_path()
File "D:\Program Files\Anaconda2\lib\site-packages\jpype\_jvmfinder.py", line 137, in get_jvm_path
.format(self._libfile))
jpype._jvmfinder.JVMNotFoundException: No JVM shared library file (jvm.dll) found. Try setting up the JAVA_HOME environment variable properly.
I tried to set JAVA_HOME variable in KNIME preferences classpath variables with value --> C:/Program Files/Java/jdk1.8.0_71/jre/bin/server but it didnot work out. I also tried to setup the same in My Computer--> Advance Properties --> Environment Variables--. System variables. But that did not work either. Please advise.