0

I have this small script which tryes to connect to a server running a oracle database (11g). 

import os
import sys
import jpype
import jaydebeapi

if("JAVA_HOME" not in os.environ):
    os.environ["JAVA_HOME"] = "c:\Program Files\Java\jdk1.8.0_45"

ODBC_DRIVER = os.path.join(os.path.dirname(os.path.abspath(__file__)), "ojdbc6.jar")

print("\tPYTHON VERSION", sys.version)
print("\tJAVA_HOME", os.environ["JAVA_HOME"])
print("\tDEFAULT JVM PATH", jpype.getDefaultJVMPath())
print("\tODBC_DRIVER", ODBC_DRIVER)

try:
    jpype.startJVM(jpype.getDefaultJVMPath(), "-Djava.class.path={}".format(ODBC_DRIVER))
    conn = jaydebeapi.connect("oracle.jdbc.driver.OracleDriver",
                             ["jdbc:oracle:thin//192.168.10.33:1521", "<user>", "<passw>"],
                              ODBC_DRIVER)
except Exception as e:
    print(e)
    sys.exit(-1)

sys.exit(0)

The output with the thrown exception:

    PYTHON VERSION 3.4.3 (v3.4.3:9b73f1c3e601, Feb 24 2015, 22:44:40) [MSC v.1600 64 bit (AMD64)]
    JAVA_HOME c:\Program Files\Java\jdk1.8.0_45
    DEFAULT JVM PATH c:\Program Files\Java\jdk1.8.0_45\jre\bin\server\jvm.dll
    ODBC_DRIVER d:\path\to\ojdbc6.jar

close_fds is not supported on Windows platforms if you redirect stdin/stdout/stderr

As a reference I mostly used small tutorials which connect to a oracle database. Their code lookst essentially the same.

By looking for a solution I have found that python should support close_fds from version 2.6.x

I'm not sure where to start looking.

More information on jpype and jaydebaapi:

JayDeBeApi3 (1.3)
JPype1-py3 (0.5.5.2)

Both were installed through pip.

ap0
  • 1,083
  • 1
  • 12
  • 37
  • Why don't you use more recent versions of [JPype1](https://pypi.python.org/pypi/JPype1/) and [JayDeBeApi](https://pypi.python.org/pypi/JayDeBeApi/)? – bastian Oct 16 '15 at 11:31

1 Answers1

1

I would recommend using python >=2.7.x (which is fine in your case because you are using a higher version). Use JPype1 0.5.7 as recommended by JayDeBeApi 0.2.0, which is the latest version. Also, since you are starting the JVM yourself, you don't need to specify the 3rd argument (driver) in the connect statement. Or you can comment out the startjvm and keep connect statement as it is. Jpype does the same (i.e, startjvm if you specify the driver jar as 3rd argument in connect statement).

phoenix
  • 3,069
  • 3
  • 22
  • 29
  • Thanks for the answer. In the meantime I switched from Windows to Linux to solve this issue. Main issue was, that I was not able to build the latest version of JPype and Jaydebeapi thus using slightly older ones. On Linux with latest packages, this problem does not accure anymore. – ap0 Oct 21 '15 at 06:21