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

Connecting to a JDBC database in Python vs. MATLAB

I am trying to connect to a SQL database in Python, but I am have difficult finding documentation/examples of connecting to a JDBC. I can do this in MATLAB using the following code: `Name = 'ServerName'; Username = ''; Password = ''; Server =…
Hobbes
  • 199
  • 1
  • 6
2
votes
2 answers

Robotframework + JayDeBeApi + SQLServer gives SQLServerException: Cannot invoke a rollback operation when the AutoCommit mode is set to "true"

I setup robotframework test by using robotframework DatabaseLibrary, JayDeBeApi, MS SQL Server JDBC driver and have successful connection. However I'm getting SQLServerException: Cannot invoke a rollback operation when the AutoCommit mode is set to…
Steve Park
  • 1,979
  • 27
  • 33
2
votes
1 answer

Read Clob from JayBeDeAPI Query

I'm using python's jaybedeapi to connect to an Oracle database. Everything seems to be working fine, except when I encounter fields with oracle.sql.clob data: Connection & query: conn =…
datasci
  • 1,019
  • 2
  • 12
  • 29
2
votes
1 answer

Removing u' from result of cursor.fetchall()

I'm using python 2.7 with jaydebeapi and informix jdbc driver (ifxjdbc.jar) to execute a select on a table and all the fields have u'some_text' Here's my code curs = conn.cursor() curs.execute("SELECT * FROM table1") res = curs.fetchall() print…
albgz
  • 23
  • 1
  • 3
1
vote
0 answers

Jaydebeapi.connect() from Databricks

I am able to read and write the data from databricks to Teradata but not able to run jaydebeapi.connect() funtion. import jaydebeapi jdbc_driver_loc…
Shobhit Jain
  • 21
  • 1
1
vote
1 answer

Access IBM DVM(Data Virtualization Manager) from linux Unbuntu vm using Python

I am trying to access IBM DVM(Data Virtualization Manager) from linux Unbuntu vm using Python. I have installed JAVA on the unbuntu machine: java -version openjdk version "1.8.0_362" OpenJDK Runtime Environment (build 1.8.0_362-b08) OpenJDK 64-Bit…
sanika sawant
  • 11
  • 3
1
vote
0 answers

Connect to DB2 via JayDeBeApi JDBC in Python M1 Mac

I am trying to connect to DB2 from Python on my Mac M1. Unfortunately, I have no control over the python version (Python 3.10.6) installed on the Mac. I tried to follow the instructions on Connect to DB2 via JayDeBeApi JDBC in Python to set up JDBC…
john_sab1
  • 13
  • 3
1
vote
2 answers

How to solve OSError: [WinError 126] JVM DLL not found when trying to use jaydebeapi in python 3.11 to make a database connection

I am trying to make a database connection using the Jaydebeapi package in Python3. My setup is running on a windows 2016 server. I have Java 8 and JDK installed. When I execute my script it returns the below error: OSError: [WinError 126] JVM DLL…
Waldo Gerber
  • 11
  • 3
1
vote
1 answer

Create MS Access database from a Python app

I'm working with Python and interacting with a MS Access database via the JayDeBeApi library. Everything works well, I can create tables and all but the file *.accdb need to be created previously in the MS Access software Is there a way to…
Geneviève Le Houx
  • 152
  • 1
  • 9
1
vote
2 answers

jaydebeapi.connect always returning: "TypeError: Class sajdbc4.jar is not found"

I am trying to use the jaydebeapi python package to create a jdbc database connection, but no matter what argument I put in the connect method I get the same error: "TypeError: Class [first_argurment_str] is not found" import jaydebeapi conn =…
Stykes
  • 306
  • 6
  • 15
1
vote
1 answer

How to pass params in jaydebeapi .execute?

I want to select data from oracle DB using python and jaydebeapi. I'm trying to get data using next script: bank_accounts = """ SELECT ACCOUNT_NUM, VALID_TO, CLIENT, CREATE_DT, UPDATE_DT FROM ACCOUNTS where client = ?""" clients =…
FeoJun
  • 103
  • 1
  • 14
1
vote
0 answers

How do I use JayDeBeApi to read a Access DB file on Databricks?

Currently trying to use the JayDeBeApi pkg with Ucanaccess drivers to read an .accdb file on Databricks. I am placing the .accdb file in the DBFS and trying to read from there. I am currently using Databricks Community Edition to build a proof of…
Leland Adams
  • 11
  • 2
1
vote
1 answer

TypeError: Class com.microsoft.sqlserver.jdbc.SQLServerDriver is not found [MacOs, python, jaydebeapi]

I'm trying to connect to my database via jaydebeapi and jdbc driver. Here is my python code: import jaydebeapi import jpype class MyClass: # jdbc_driver_path = os.path.join('Library', 'Java', 'Extensions', 'sqlserverjdbc.jar') …
sgalich
  • 178
  • 3
  • 12
1
vote
1 answer

Python: HSQL DB remains open after closing? (jaydebeapi)

Task I am writing a Python script that makes some changes in a HSQL-DB and then rexecutes a java-programm via the command line, which works with the data in the DB. I am using jaydebeapi for altering the data in Python. Problem The java program…
MarkFloatingInSpace
  • 77
  • 4
1
vote
1 answer

Pandas read_sql very slow reading from Jaydebeapi Netezza

I'm using Pandas read sql to read netezza table through jdbc/jaydebeapi. start_time = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S.%f')[:-3] print(" DB Start Date Time is " + str(start_time)) int_df = pd.read_sql(query,conn) end_time =…
matterwaves
  • 11
  • 3
1 2
3
…
9 10