Stack Overflow
Stack Overflow

Questions tagged [jaydebeapi]

A bridge from JDBC database drivers to Python DB-API.

The JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.

It works on ordinary Python (cPython) using the JPype Java integration or on Jython to make use of the Java JDBC driver.

In contrast to zxJDBC from the Jython project, JayDeBeApi let's you access a database with Jython AND Python with only minor code modifications. JayDeBeApi's future goal is to provide a unique and fast interface to different types of JDBC-Drivers through a flexible plug-in mechanism.

For more information, visit the JayDeBeApi homepage

146 questions
2
votes
2 answers

Can't properly read SQL table in python: varchar columns imported as comma-separated characters / tuples

I'm connecting to a Oracle database using the following code: jar = ojdbc8.jar path jvm_path = jvm.dll path args = '-Djava.class.path=%s' % jar jpype.startJVM(jvm_path, args) con = jaydebeapi.connect("oracle.jdbc.driver.OracleDriver", url,[user,…
Lucas Lunelli
  • 23
  • 4
2
votes
1 answer

Pandas Dataframe displays results inside brackets with commas

I am reading data into dataframe using pd.read_sql(). The database is Oracle and the Oracle connectivity module is JayDeBeApi. Issue: The connection is successful and I am able to retrieve data as well. But when I print the dataframe, it looks…
prashant mahamuni
  • 61
  • 2
  • 5
2
votes
2 answers

Python: JDBC Connection Error using JayDeBeApi

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…
user5828964
  • 302
  • 2
  • 10
2
votes
1 answer

cannot find jpype even after successful installation

I tried to install jpype by pip as follows sudo pip3 install JPype1-py3 but, I received a bunch of errors; the screenshot is attached. Click hereThen I installed manually that package, and when I run, it says: (the screenshot is also attached…
umka
  • 21
  • 2
2
votes
0 answers

Python - How to loop a ResultSet

I'm working with Python and JayDeBeApi to connect to a Oracle-type database. In the SELECT's statements I need to get about 10+ thousand of records. In the first time I done by using the "fetchAll()" method, but this loads my memory and I wouldn't…
WitnessTruth
  • 539
  • 2
  • 9
  • 27
2
votes
0 answers

Writing Pandas DataFrame into Teradata database table using Jaydebeapi giving error

I am trying to write pandas dataframe into Teradata database using Jaydebeapi. I am able to read data from database easily, but facing problem while writing. Code: import jaydebeapi import pandas as pd case_detail_server ='server_url' server_name=…
Mithilesh Kumar
  • 17
  • 3
2
votes
1 answer

How to make to_sql method from Pandas DataFrame work with Jaydebeapi?

I tried to write a pandas dataframe into a HIVE table on a remote server using to_sql method. Currently I have the Jaydebeapi connection object created and I'm able to use read_sql method from pandas plus this connection object to query data from…
Enos
  • 21
  • 3
2
votes
2 answers

Impala driver class not being found through Jaydebeapi Connection

I recently switched over from using a PC to a Mac and now for whatever reason one of my Impala drivers that worked fine is no longer found when run in Python. I keep receiving this error every time I run the script : "java.lang.RuntimeException:…
papacoolaid666
  • 85
  • 9
2
votes
1 answer

Adding jar file to jpype makes java crash

I'm using flask-appbuilder to build an application. To submit a form to execute ddl, I add a jar file to jpype when startJVM(), but java always crashes. Below is my code: import jaydebeapi from flask import flash def execute_ddl(dic): def…
dlwlrma
  • 808
  • 2
  • 10
  • 21
2
votes
0 answers

python apache phoenix jdbc connection

I'm attempting to connect to Phoenix-Hbase via JDBC. Actually I already have a Phoenix connection through DBeaver and I'm trying to replicate it in python. I tried: import jaydebeapi conn = jaydebeapi.connect("org.apache.phoenix.jdbc.PhoenixDriver",…
Ignus
  • 139
  • 1
  • 8
2
votes
2 answers

Python 3 - jaydebeapi - Connect to an Oracle Database

I recently downloaded the jaydebeapi library and I am struggling to connect to a remote Oracle database. I am doing the following: import jaydebeapi as j j.connect('oracle.jdbc.driver.OracleDriver', ['jdbc:oracle:thin:@myhost:port:instance_name',…
AntoG
  • 833
  • 1
  • 10
  • 16
2
votes
1 answer

UcanAccess retrieve stored query sql

I'm trying to retrieve the SQL that makes up a stored query inside an Access database. I'm using a combination of UcanAccess 4.0.2, and jaydebeapi and the ucanaccess console. The ultimate goal is to be able to do the following from a python script…
Mashume
  • 33
  • 7
2
votes
0 answers

jaydebeapi: A fatal error has been detected by the Java Runtime Environment

Running into below error when trying to run the following: In [1]: import jaydebeapi In [2]: conn = jaydebeapi.connect("org.netezza.Driver", ...: "jdbc:netezza://{Server}:{Port}/{DB}", ...: …
horatio1701d
  • 8,809
  • 14
  • 48
  • 77
2
votes
1 answer

Using jaydebeapi3 to connect to Apache Phoenix

I have a program, in which I have been using the phoenixdb package developed by Lukas Lalinsky but during the past few days it seems to have become very unstable. I think this is due to the size of the database (as it is constantly growing). By…
Zeliax
  • 4,987
  • 10
  • 51
  • 79
2
votes
1 answer

jaydebeapi latest update to 1.0.0 causing connection error

Recently, jaydebeapi updated and i now cannot connect with my old code. https://github.com/baztian/jaydebeapi This is the docs from the jaydebeapi source on connection: >>> import jaydebeapi >>> conn = jaydebeapi.connect('org.hsqldb.jdbcDriver', ...…
jxn
  • 7,685
  • 28
  • 90
  • 172
1
2
3
…
9 10