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

jaydebeapi executemany() method doesn't wok with one parameter

jaydebeapi executemany() method doesn't work using sql query containing only one parameter, but at the same time two parameters works fine. For example given query doesn't executes: cursor.executemany("DELETE FROM table1 WHERE col1 = ?",…
raykomrad0980
  • 3
  • 1
  • 3
0
votes
1 answer

Python using JAYDEBEAPI to connect to IBM DB2 error: AttributeError: '_jpype.PyJPField' object has no attribute 'getStaticAttribute'

I am using the following code (provided on the official page of IBM, [here][1]) to create a connection to IBM DB2: import jaydebeapi, sys #Enter the values for you database connection dsn_database = "testdb"# e.g. "BLUDB" Name of the…
Stoian Stefan Catalin
  • 11
  • 1
  • 1
  • 4
0
votes
0 answers

Why my query does not return any value from VARCHAR fields?

I am trying to query a table from a Oracle 9i db, using Python with jaydebeapi. It connects successfully, the cursor and fecth seems to work well, but when I display the results, only the numeric fields of the table are available. I tried some…
Ricardo Junior
  • 1
0
votes
0 answers

Error querying timestamp data using Python and Jaydebeapi

I'm receiving an error when trying to query data fields in Denodo that have a timestamp type. I'm using python 3.7.3 and the jaydebeapi. Referencing the error I receive below, '%Y-%m-%d %H:%M:%S' is indeed how the field is formatted, and…
Millie Smith
  • 1
  • 1
0
votes
1 answer

Problem Classpath for jaydebeapi from raspberry

I try to make Oracle request in python from Raspberry pi. The problem is: "Oracle does not support the ARM CPU architecture which the Raspberry Pi uses. You downloaded and unzipped the Oracle Instant Client, but it can't actually run. And without…
Jeremy.l71
  • 45
  • 7
0
votes
2 answers

Bulk inserts into Oracle database via Python's jaydebeapi

I want to bulk-copy data from SQLite3 files to an Oracle DB, and do so programmatically from within a Python script using the jaydebeapi module. (I have no control over the choice of Python + jaydebeapi to do this; it is imposed by the project I am…
kjo
  • 33,683
  • 52
  • 148
  • 265
0
votes
1 answer

unhandled win32 exception occurred in python.exe

Has anyone encountered such a problem before? Every time I run jaydebeapi.connnect(......), python stops working and I encounter this error.. unhandled win32 exception occurred in python.exe I tried jpype.startJVM('C:\\Program Files…
varuD
  • 1
  • 1
0
votes
1 answer

__init__() missing 1 required positional argument: 'gateway_parameters'

I am trying to connect to Oracle database using JDBC in python 3 (jupyter notebook) using JayDeBeApi module but I am getting this error __init__() missing 1 required positional argument: 'gateway_parameters' Really appreciate the help to figure…
Neha Verma
  • 1
0
votes
1 answer

How can I display rows pulled from Dynamics 365 Online via Python (JayDeBeApi)?

I am trying to pull data from Dynamics CRM 365 Online via Python3. During my research, I read that JayDeBeAPi was a good library to pull data from Dynamics CRM 365 Online. I successfully pip installed the library and tested the "import jaydebeapi"…
John Hill Escobar
  • 1
  • 1
0
votes
1 answer

java.lang.RuntimeExceptionPyRaisable: java.lang.RuntimeException: Class com.teradata.jdbc.TeraDriver not found

I am trying to connect with Teradata database in Mac 10.14.2 using Jaydebeapi. I am getting following error. Earlier, I was facing issue in installing Jaydebeapi. After lot of trials and errors. I downgraded Python 3.7 to Python 3.6. Following are…
Mithilesh Kumar
  • 256
  • 1
  • 3
  • 18
0
votes
0 answers

python crashes when running jaydebeapi

I try to connect to a JDBC:hive client via knox and if I run the following code: import jaydebeapi; import jpype; conn = jaydebeapi.connect("org.apache.hive.jdbc.HiveDriver","",["",…
Michi
  • 1
  • 2
0
votes
0 answers

Error in JDBC using connection to Hive in python

I'm new in python, so be kind. I'm trying to grab a data from hive with JDBC. I did all the installations required for it. But while running this simple code, an error return. I need some help here to understand what is wrong, and how shell I fix…
Gila Itzhakov Klar
  • 1
  • 1
0
votes
0 answers

How can i send multiple queries in jaydebeapi in python (Netezza JDBC)

How to send multiple queries in single execute statement for example simplified version of my query is (which i am trying to execute using jaydebeapi ) Create temp table tempTable as select * from table1 where x=y; select * from tempTable ; UPDATE :…
Prabha A
  • 33
  • 2
  • 5
0
votes
2 answers

Error swallowed

Problem I am connecting with JayDeBeApi to SQL Server 2017 and running a script like: SELECT ... INTO #a-temp-table DELETE FROM a-table INSERT INTO a-table SELECT FROM #a-temp-table DELETE #a-temp-table During step 3 i get the following…
Simon Lang
  • 533
  • 3
  • 18
0
votes
2 answers

jaydebeapi for both Netezza and MySQL

I am using jaydebeapi in python 3 to run queries. I need to connect to Netezza and MySql both. my code runs both queries separately without any problem but when I run one after another it gives an error for the second one. I close both connection…
Mostafa Ghafoori
  • 187
  • 2
  • 3
  • 13
1 2 3
…
9
10