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
1
vote
0 answers

install JayDeBeApi on WIndows 7

I'm using python version 3.6.I'm trying to install JayDeBeApi on my windows 7.I used following command from my command prompt running in administrator mode pip install JayDeBeApi But I'm getting following error Cache entry deserialization failed,…
Python Learner
  • 437
  • 2
  • 11
  • 28
1
vote
0 answers

Class not found jaydebeapi Apache Phoenix

I'm trying to use jaydebeapi library to connect to apache phoenix 4.4 via JDBC, I'm using this script python : import jaydebeapi as jdbc jar ='/usr/hdp/current/phoenix-client/phoenix-4.4.0.2.4.3.0-227-client.jar' drivername =…
azelix
  • 1,257
  • 4
  • 26
  • 50
1
vote
3 answers

How can I increase the maximum query time?

I ran a query which will eventually return roughly 17M rows in chunks of 500,000. Everything seemed to be going just fine, but I ran into the following error: Traceback (most recent call last): File "sql_csv.py", line 22, in for chunk…
MichaelChirico
  • 33,841
  • 14
  • 113
  • 198
1
vote
1 answer

Class com.teradata.jdbc.TeraDriver not found (Python, jaydebeapi module)

I am trying to connect to teradata using jaydebeapi. import jaydebeapi conn = jaydebeapi.connect('com.teradata.jdbc.TeraDriver', 'jdbc:teradata://serverIP/charset=UTF8,DBS_PORT=1025', {'user':…
Ivan
  • 111
  • 1
  • 4
1
vote
1 answer

When to use pyodbc and when to use jaydebeapi in Python 2/3?

As the title says, simple question... When to use pyodbc and when to use jaydebeapi in Python 2/3? Let me elaborate with a couple of example scenarios... If I were a solution architect and am looking at a Pyramid Web Server looking to access…
DanglingPointer
  • 891
  • 1
  • 5
  • 12
1
vote
1 answer

Connect to Filemaker Database using JDBC, Python, and JayDeBeApi

I'm trying to write an AWS Lambda Python Package that will connect to a FileMaker database over JDBC. To test, I've launched an EC2 instance with the Lambda Linux AMI, and created a virtualenv (/venv) that I'm testing in. I've uploaded the…
user2752159
  • 1,182
  • 3
  • 13
  • 29
1
vote
0 answers

Jaydebeapi and sslTrustStoreLocation

I connect to my db2 database with following URL: jdbc:db2://myhost:9999/mydb:sslConnection=true;sslTrustStoreLocation=/home/my name/somekey.jks using squirrel. Now I'm trying to connect from python using jaydebeapi using the same URL string but it…
hadron
  • 457
  • 4
  • 19
1
vote
0 answers

JDBC login with Jpype

While the below snippet works import jaydebeapi conn = jaydebeapi.connect('com.teradata.jdbc.TeraDriver',['jdbc:teradata://hostname/TMODE=TERA,CHARSET=utf8', 'username',…
rogue-one
  • 11,259
  • 7
  • 53
  • 75
1
vote
1 answer

JPype and JayDeBeAPI: AttributeError: 'property' object has no attribute 'isBeanAccessor'

I have built JPype (JPype1-0.5.5.4) along with JayDeBeAPI 0.1.4 in my attempt to connect to a database via JDBC. This is on RHEL. I can successfully connect using the driver, TrgtCnn = jaydebeapi.connect('com.ibm.as400.access.AS400JDBCDriver', …
Andrew Dennison
  • 23
  • 1
  • 3
0
votes
0 answers

Python thread was stop after jaydebeapi.connect

I'm using Python on Raspberry Pi. And I'm using JDBC to connect to the Oracle database. The problem is that sometimes the thread shuts down while I'm connecting to JDBC. conn = jaydebeapi.connect("oracle.jdbc.driver.OracleDriver", dsn, [user,…
BiBi
  • 1
  • 2
0
votes
1 answer

Connection to DB2 using jaydebeapi not working

I need to create a connection to a DB2 database in an IBM i system, using Python library jaydebeapi, with the following instruction: import sys import jaydebeapi import os try: conn = jaydebeapi.connect("com.ibm.as400.access.AS400JDBCDriver", …
agreppi
  • 1
  • 1
0
votes
0 answers

Oracle NetSuit ERP Connect Using Python

I am trying to connect with Oracle ERP Netsuit using a JDBC driver in python code but it is giving me an error below, also I am not sure about connection string if its the correct way of setting up. Error: Connection error:…
DKM
  • 1,761
  • 2
  • 19
  • 34
0
votes
0 answers

Why isn't JayDeBeApi returning data?

I am trying to test JayDeBeApi by accessing a local HSQL database on my computer. I have set up the database and I know there is data in it, but I am getting nothing when I run my code. My table is called PA0101.ALERT_PRIORITY. It has the…
Eric
  • 1
  • 1
0
votes
0 answers

jaydebeapi error: java.lang.ClassNotFoundException: com.amazonaws.auth.AWSCredentials

I'm trying to connect to AWS Athena using jaydebeapi but I'm receiving this error from java: Traceback (most recent call last): File "C:\Users\username\notebooks\athena.py", line 86, in conn = jaydebeapi.connect( File…
Ronaldo Valente
  • 1
0
votes
1 answer

Provide certificates to Python jaydebeapi lib for jdbc MYSQL connection adapter

There's a JDBC server that I need to connect through python to. Using jaydebeapi lib, I'm able to spin up a connection non-ssl but when connecting to a staging database which enforces certs, I don't understand how to provide the jks file it needs…
crowgers
  • 232
  • 3
  • 19
1 2 3
…
9 10