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

python script error in docker detached mode, but executes correctly in docker attached mode

I am using JayDeBeAPI and UCanAccess to extract data from MS Access .mdb files (as per this advice). My python script runs in docker debian container (FROM python:3.9-slim) and everything is OK if it runs in the "attached mode", but if I run the…
average.everyman
  • 123
  • 1
  • 12
0
votes
1 answer

Retrieve list of tables from Microsoft Access database (mdb) using JaDeBeAPI and UCanAccess from python

I'm trying to retrieve a list of tables from an MS Access mdb database file from Python using JayDeBeApi combined with UCanAccess. Querying the database works fine, though I cannot find out how top list all tables. I've been googling and trying for…
Max Wiertz
  • 1
  • 1
0
votes
1 answer

jaydebeapi cannot find jar on AWS Glue

I'm trying to connect to an Oracle database via jaydebeapi in Python on AWS Glue. I'm getting the error that says: TypeError: Class oracle.jdbc.driver.OracleDriver is not found I believe the error is resulted from jaydebeapi not able to find the…
xiexieni9527
  • 111
  • 7
0
votes
1 answer

java.sql.sqlexception method not supported executemany()

jaydebeapi executemany() method is not working for big csv file writing to hadoop table. Can someone please give example to writing csv data to Hive table?
OneManFunction
  • 31
  • 2
  • 5
0
votes
0 answers

JDBC Python connection to Azure SQL Database

I'm trying to connect to Azure SQL Database using the JDBC driver because ODBC is very slow. I need to use ActiveDirectoryIntegrated authentication. Python code for connection below: server =…
Alexey Belkov
  • 1
  • 2
0
votes
1 answer

changing timeout jaydebeapi with Denodo driver

I am connecting to a database using a quite standard syntax. How to change the default timeout value here? Does it need to be set at the driver or at the jdbc level? jaydebeapi documentation does not mention that. Source for…
00__00__00
  • 4,834
  • 9
  • 41
  • 89
0
votes
1 answer

Query returns Error despite being executed succesfully (Robot Framework / JayDeBeApi)

Using the Keyword Query from the Robot Framework DatabaseLibrary JayDeBeApi in conjunction with DB2 like this: ${results}= Query CREATE TABLE SCHEMANAME.TEST_TEMP (id BIGINT, name VARCHAR(25)) is being executed (table exists afterwards). But…
Rainer
  • 1,067
  • 2
  • 14
  • 29
0
votes
0 answers

Can we perform jdbc based AAD authentication to SQL Server in python

I use jaydebeapi to perform SQL Server connection and couldn't figure out how to connect for AAD based authentication. import jaydebeapi driver_class_name = 'com.microsoft.sqlserver.jdbc.SQLServerDriver' connection_details =…
abhilash Dasari
  • 5
  • 3
0
votes
0 answers

Problem with Dataflow runner and jaydebeapi (one-time problem)

Info on our data flow pipeline we're referring to in this incident: pipeline is responsible for moving data from Oracle source to BigQuery; pipeline is written in Python3.6; it uses ojdbc, jdk and jaydebeapi; it is ensured in our code that all…
Łukasz Trzcianowski
  • 1
0
votes
1 answer

How to fix Class Not Found Error when making subsequent connections to AS400 DB2 and zOS DB2 databases?

I am a tester. As part of my tests, I have to extract data from two DB2 databases. One resides on z/OS, and the other resides on AS400 When I call the functions sequentially, the second one fails with TypeError: "Class com.ibm.db2.jcc.DB2Driver" or …
Keshav Prabhu
  • 83
  • 1
  • 11
0
votes
0 answers

Connecting to MS SQL Database using windows Authentication using JAYDEBEAPI python script

I am trying to connect to SQL Server using jaydebeapi in python but every time I am getting same error: java.sql.SQLException: java.sql.SQLException: I/O Error: DB server closed connection. I know this is an old question but with the same code I…
Sachin Parashar
  • 63
  • 5
0
votes
1 answer

Can't pickle in python

I'm fetching data from a db with the use of jaydebeapi pkg. I want to serialize the data (it's in list of tuples format) using pickle. The data may contain different java class types. For a certain data type () I get…
eagerstudent
  • 237
  • 1
  • 5
  • 14
0
votes
1 answer

Connection Issue While reading Hive table In HDInsight using Python

All. I wanted to connect to Hive Database in HDInsight using Python I followed multiple blog and few Stackoverflow blogs also .but No luck . Below are my tries using pyhive and JayDeBeApi library . Using JayDeBeApi I have added hive-jdbc-1.2.1,…
HimanshuSPaul
  • 278
  • 1
  • 4
  • 19
0
votes
1 answer

Python: JDBC Connection Error to Apache Drill Error with JayDeBeApi

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…
Galuoises
  • 2,630
  • 24
  • 30
0
votes
1 answer

Jaydebeapi giving error in python for CharConversionException

Getting CharConversionException in python Jaydebeapi when trying to pull data ? Not sure where how to set db2.jcc.charsetDecoderEncoder property in python to resolve this. Exact error - com.ibm.db2.jcc.am.SqlException:…
Shashank Srivastava
  • 63
  • 3
1 2 3
…
9 10