Python -使用JayDeBeApi连接到配置单元时出错

Question

我正尝试在Python脚本中使用JayDeBeApi连接Hortonworks中的配置单元。我已经安装了Python64位，并安装了PyCharm集成开发环境。我也安装了JayDeBeApi。我得到了以下错误，并且不确定我遗漏了什么。

    C:\Python27\python.exe C:/Projects_Work/primex/tableau/TDEConnect.py
    Opening connection.....
    Traceback (most recent call last):
    File "C:/Projects_Work/primex/tableau/TDEConnect.py", line 47, in <module>
main()
    File "C:/Projects_Work/primex/tableau/TDEConnect.py", line 19, in main
with connect() as conn:
    File "C:/Projects_Work/primex/tableau/TDEConnect.py", line 30, in __enter__
{'user': sslUser, 'password': sslPassword}, driverPath, )
    File "C:\Python27\lib\site-packages\jaydebeapi\__init__.py", line 381, in connect
    jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)
    File "C:\Python27\lib\site-packages\jaydebeapi\__init__.py", line 159, in _jdbc_connect_jpype
    import jpype
    File "C:\Python27\lib\site-packages\jpype\__init__.py", line 17, in <module>
from ._jpackage import *
    File "C:\Python27\lib\site-packages\jpype\_jpackage.py", line 18, in <module>
    import _jpype

    ImportError: DLL load failed: %1 is not a valid Win32 application.

    Process finished with exit code 1

任何输入都是很棒的。谢谢。

Answer 1

JayDebeApi包含用于从Python中运行Java类JPype。在安装JayDebeApi之前，有必要安装C++编译器

视窗

用于Python2.7的

• Visual Studio2008。请参阅:Python3.4中的https://docs.python.org/2.7/using/windows.html#compiling-python-on-windows
• Visual Studio2010。请参阅：https://docs.python.org/3.4/using/windows.html#compiling-python-on-windows

Answer 2

或者，你可以直接获得Jpype工具(如果由于认证的原因，你不能安装C++开发套件)

jpype wheel files