jpype | cross language bridge to allow Python programs full access | Wrapper library

I am trying to call Java code from Python using Jpype and trying to implement Interface using JProxy for callbacks. It is giving me error that "TypeError: Cannot create Java interface instances" If i try to cast it e.g.

I am using jpype, jaydebeapi to connect to an Oracle database which works fine but the sql returns tuples instead of strings with brackets and a comma after each character.

e.g. instead of dog it returns (d,o,g,)

Running the same sql in DBeaver or Toad returns the string without alteration as you would expect.

Any idea on how to return the string without brackets and comma please? (I can still use the data but it looks weird in a chart and makes the chart and other outputs harder to read).

I have already searched Google and stackoverflow for similar issues (link1,link2,link3) but non of these solutions have worked for me. I need to find a way to loop through all columns to find those with dtype string and then join all tuples in those.

Here is a screenshot of how the data is being returned: df_screenshot

Here is a screenshot of a pivot (showing the data can be used without using brackets and commas): pivot_screenshot

Here is a screenshot of a chart (again showing string with brackets and commas): chart_screenshot

The code I'm using for the connection is as follows (no issues with this as far as I can see?):

I am trying to connect to Apache Drill from python using jaydebeapi library.

I have turned on drill in embedded mode via drill-embedded, and the web ui runs correctly in port 8047. Then, I am trying to connect via JDBC through a python script:

I have a connection to some Oracle data base and trying to export the data to a csv file. Below is my Python code -

I have received the task, at work, to find a way to use some methods from an existent jar file in a Python project. I have very limited experience in Python, but I have worked with that specific jar file before (it is part of a project we are working on). I am not allowed to modify much of both projects, and they are required to be as independent as possible.

I have researched multiple ways to include the jar methods in Python. So far, I have tried Jython (which I cannot use because the Python project uses PyQt among other libraries, which force the use of CPython, if my understanding is correct), Pyjnius and JPype. JPype seems the most promising, but I cannot get it working either. I have pasted the my code below, slightly censored because I don't know how much I am allowed to share.

I'm trying to dockerizing some flask app that I create.

I need to access a java file using startJVM() in the Python script I created. The code below works fine on my local terminal and it can detect the path of the file with the ".jar" extension.

ZEMBEREK_PATH = os.path.abspath("zemberek-full.jar")

startJVM(getDefaultJVMPath(), '-ea', f'-Djava.class.path={ZEMBEREK_PATH}', convertStrings=False)

But when I run this in docker image, I guess the path variable cannot find the file with the extension ".jar", so the program gives an error.

I'm facing an error while running following code. Please help me solving this issue or suggest an alternative way to connect Vertica server via JDBC.

I have also tried connecting using pyspark. But with pyspark we are not able to execute sql query in vertica server.

System Configuration:

Linux with python 3.7.0

jaydebeapi version - 1.1.1

jpype version - 0.7.2

I did insert data into SQL Server using cursor.execute().

Here is my code snippet:

I am trying to connect to my Hive server using JDBC connection.

I've the following JAR file in my JAVA_HOME:

• HIVEJDBC41.jar
• hadoop-common.jar

But when I run my code jaydebeapi.connect('org.apache.hive.jdbc.HiveDriver', url)

It gives me the following error: