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

Connecting MYSQL DB using jaydebeapi using Python

I'm trying to connect to a MySQL DB from Python prompt and using JayDeBeApi. Below is the piece of code I'm using: "**Python 2.7.16 (default, Oct 10 2019, 22:02:15) [GCC 8.3.0] on linux2 Type "help", "copyright", "credits" or "license" for more…
Arpan Roy
  • 33
  • 2
  • 7
0
votes
0 answers

how to deploy flask app with jaydebeapi on pivotal cloud foundry

So i tried to push flask app that manipulate db using jaydebeapi on pcf, but it cannot find the jvm,and i tried this one Add Java/JRE/JVM in Python Flask Cloud Foundry/IBM Cloud application using multipacks return "No container can run this…
Beavis Luckyano
  • 33
  • 4
0
votes
2 answers

How to Suppress Logs from jaydebeapi Jars

import os import pandas as pd from jaydebeapi import connect def sql_query(query: str) -> pd.DataFrame: jclassname = "classname" url = "urlToCluster" driver_args = {"keys":"values"} path = "pathToJars" jars =…
kcrich
  • 1
0
votes
2 answers

java.lang.RuntimeException: Class com.mysql.cj.jdbc.Driver not found

I have this conection to MySql in python with JayDeBeApi, using JDBC: def data_JDBC(db_name, table, db, user, pwd): db = db.lower() db_name = db_name.lower() print(db) if db == 'postgresql': sql_str = f"select * from…
Lucas David
  • 21
  • 4
0
votes
1 answer

How to read data blob from Apache Derby DB with python jaydebeapi?

I am trying to import data from a a local derby database into python using the jaydebeapi. I am running python 3.6 from PyCharmCE: import jaydebeapi as jdbc conn = jdbc.connect("org.apache.derby.jdbc.ClientDriver",…
gemixl
  • 3
  • 4
0
votes
0 answers

Why is ProxySchemeUnknown error throwing while installing JayDeBeApi using pip?

Pip install is throwing error while installing package JayDeBeApi. I tried to edit Conf file. Tried uninstall and reinstall Python, it is throwing the same error over and over again. Can someone please help? $ pip3 install…
ang_coder
  • 133
  • 2
  • 11
0
votes
1 answer

Python - Jaydebeapi/jpype - Connect to to as400/db2 with ssl encryption

im struggling (since a few days) to connect to our db2 database on an as400 over ssl. For the database connection im using jaydebeapi and to access the database with a secure connection i need to append the trustStore location and trustStore…
TKraski
  • 11
  • 4
0
votes
1 answer

Error connecting to Hive using JayDeBeApi - Class not found

I am trying to connect to my Hive server using JDBC connection. I've the following JAR file in my JAVA_HOME: HIVEJDBC41.jar hadoop-common.jar But when I run my code jaydebeapi.connect('org.apache.hive.jdbc.HiveDriver', url) It gives me the…
Pedro Alves
  • 1,004
  • 1
  • 21
  • 47
0
votes
0 answers

Connect hive from flask app using jdbc ERROR

I'm trying to connect hive database from my flask application but a got this error : java.sql.SQLException: No suitable driver found for jdbc:hive2://myserverspark:10000/default; this is my code : app =…
zekri sidi mohamed hicham
  • 57
  • 1
  • 10
0
votes
1 answer

jaydebeapi connection terminates without any exception or error | unable to investigate further

I followed the usage steps as per the example, after the second step of defining "conn" the script terminates and comes back to the command line without raising any errors o warnings or exception. I am not able to identify what went wrong, has…
PraveenS
  • 115
  • 13
0
votes
2 answers

Downgrade jpype to 0.6.3

I am currently trying to establish a jdbc connection. I am using: jaydebeapi version - 1.1.1 Because of some incompatibility issues, I'm trying to downgrade from jpype version - 0.7.2 to version 0.6.3 with this command : pip install JPype1==0.6.3…
www
  • 31
  • 2
0
votes
1 answer

How do I attach new JVMs to spawned Python Processes?

I'm working with a Python daemon running on Python 3.7 on a Linux RedHat VM. The guts of the program are very CPU heavy so I've implemented Multiprocessing, threading was too slow. I'm required to make the program a daemon. To overview, the daemon…
Joshua Hedges
  • 307
  • 4
  • 16
0
votes
1 answer

How use jaydebeapi call store procedure oracledb and pass 4 argument in and out

this problem i don't know step for pass out argument to store procedure def get_store_procedure(due_id,due_date): print("connect to oracle server") try: conn = jaydebeapi.connect('oracle.jdbc.driver.OracleDriver' …
aumnuay supmaneetana
  • 1
  • 1
0
votes
0 answers

working on SAS without SASpy and with jaydebeapi

Well i cant use SASpy since its corporate. so i am trying python with jaydebeapi code is simple import jaydebeapi conn=jaydebeapi.connect('''com.sas.rio.MVADriver ''' , 'jdbc:jkfbsdkfk//fdsf',jars='sas jars') getting following error…
rohit arora
  • 55
  • 7
0
votes
2 answers

Using JayDeBe and Amazon Redshift, is there a way to automatically pull the associated column names from within the query?

JayDeBe is all set up and querying Redshift is working correctly, but I need to find a way to return the column names which will be helpful when converting the list into a Pandas dataframe This is the code I'm using to execute the query: curs =…
Simon Green
  • 11
  • 3
1 2 3
…
9 10