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
0
votes
1 answer

Is it possible to write to Database via jaydebeapi package (python)?

With the jaydebeapi package in python it is possible to read from Teradata tables (or probably from every other DB). However i did not find any documentation about writing to the database via jdbc? (The best documentation I found was this -->…
Mimi Müller
  • 416
  • 8
  • 25
0
votes
2 answers

Python - Error connecting to Hive using JayDeBeApi

I am trying to connect Hive in Hortonworks using JayDeBeApi inside the Python script. I've installed Python 64 bit and setup with PyCharm IDE. I've installed JayDeBeApi as well. I am getting the following error and not sure what I am missing. …
Suri
  • 229
  • 2
  • 15
0
votes
2 answers

Python JDBC Connection throwing JVM Issue

I am trying to connect to Impala database using Python jaydebeapi. I am facing the JVM issue when I am calling the connection class two times. Please find below my connection class and Sql_Query Class. Connection_Class: import jaydebeapi import…
YRK
  • 153
  • 1
  • 1
  • 22
0
votes
2 answers

Adding JDBC jar driver to classpath for AWS Elastic Beanstalk job

I have an Elastic Beanstalk application that I'm trying to configure to connect to a FileMaker Pro database, over JDBC. The code I'm using is: import jaydebeapi as jdp jdbc_driver_location = '/tmp/fmjdbc.jar' conn = jdb.connect(jdbc_driver_class, …
user2752159
  • 1,182
  • 3
  • 13
  • 29
0
votes
1 answer

python jdbc connection RuntimeError: Unable to load DLL

I am trying to use jaydebeapi to connect to Teradata DB but when i run my code, it gives me this error: RuntimeError: Unable to load DLL [/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Libraries/libjvm.dylib], error =…
jxn
  • 7,685
  • 28
  • 90
  • 172
0
votes
1 answer

Python add JPype to Jaydebeapi connection if 2 driver files?

Below is my code to connect to Teradata through a JDBC connection using Jaydebeapi. When i run the query using the razorsql GUI, it takes only 15 seconds. When i run it through the code below, it took over 20 minutes just to run query1. Is there…
jxn
  • 7,685
  • 28
  • 90
  • 172
0
votes
1 answer

Call procedure on Oracle 11.2.0 via JayDeBeApi in Python

I am trying to call dbms_random.seed(42) on my DB, see ref. I need to use python and the JayDeBeApi connector. So far I've only been able to execute select statement without issue. I fail to understand what I am doing wrong. It seems that JayDeBeApi…
malat
  • 12,152
  • 13
  • 89
  • 158
0
votes
1 answer

Python can't connect to Oracle Database, close_fds is not supported

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…
ap0
  • 1,083
  • 1
  • 12
  • 37
-1
votes
1 answer

Connect to JDBC python

I am trying to connect to my GaussDB or even PostgreSQL using in python JayDeBeApi from linux, but I keep getting this error: Error Class com.gauss.driver not found I copy my jar file to /usr/lib/jvm/java-11-openjdk-amd46/lib/com.driver.jar is…
Niklas
  • 1
  • 2
-1
votes
1 answer

Access on prem DB2 from DSX

I am trying to access on prem DB2 data from DSX using a Python notebook in Jupyter. I have uploaded db2jcc.jar & license jar files to my home directory but how do I add the directory to the classpath ? Is there another to
Manasd
  • 1
1 2 3
…
9
10