jaydebeapi

jaydebeapi copied to clipboard

use jaydebeapi to execute and fetchall cost a lot of time

2

use python cx_Oracle to execute and fetchall cost : 4.3s use jaydebeapi execute and fetchall cost: 658s I noticed in the source code of jaydebeapi that fetchall and fetchmany is...

xu136090331

Updated code from #116 to get it merged.

4

Really need ability to pass java_opts. I saw #116 and decided to make the corrections.

cocampbe

Is there any way to copy entire database from one sql server to snowflake with the help of python ? Please help !!!!! PLEASE PLEASE

Beetleferret

Update for JPype deprecation and raw prepend for regex string

2

## Overview These are two small deprecation warning fixes I implemented in a local version that I wanted to share back to you all. ## Before ## After No deprecation...

rbeauchemin

Problem in connecting teradata to azure databricks

3

import jaydebeapi server=server database= db user=user password=pswd jclassname="com.teradata.jdbc.TeraDriver" url='jdbc:teradata://server/' driver_args=[url,user,password] jars=['/Users/user/drivers/tdgssconfig.jar','/Users/user/drivers/terajdbc4.jar'] jaydebeapi.connect(jclassname,driver_args,jars) I am getting error of TypeError: Class com.teradata.jdbc.TeraDriver is not found Please HELP PLEASE

Beetleferret

incorrect display of Timestamp where sub second portion has leading zeros

1

When querying HBASE using jaydebeapi from python 3.6 I'm pulling DBAPITypeObject('TIMESTAMP') objects and finding that when the sub second portion of the time has leading zeros they get concatenated, e.g.,...

rbinnun

Explicitly specifying a jdbc driver using the jars parameter is not working in a Jupyter notebook context

21

(originally I asked this in issue #22, but then realized it was closed, so I am opening a new issue) @baztian , I am also seeing a failure running inside...

chris-ratcliffe

When I run some tests associated with my script I see the following error: ```venv\lib\site-packages\jaydebeapi\__init__.py:200 D:\code\sugo\pyroyalties\venv\lib\site-packages\jaydebeapi\__init__.py:200: DeprecationWarning: jpype._core.isThreadAttachedToJVM is deprecated, use java.lang.Thread.isAttached instead if not jpype.isThreadAttachedToJVM():```

marcusbevans

Error when firebird sql JDBC driver is called

1

Given `org.firebirdsql.jdbc.FBDriver` driver, firebird version: `org.firebirdsql.jdbc_jaybird-4.0.4.java11.jar` java version: `openjdk 11.0.12 2021-07-20 LTS` java runtime: `OpenJDK Runtime Environment 18.9 (build 11.0.12+7-LTS)` context: we try to excecute the following function: ``` def...

ElCuboNegro

Class com.sybase.jdbc4.jdbc.SybDriver is not found

3

Hi, I´ve been trying to connect to sybase database with a jar called jconn4 and this program import jaydebeapi cnxn = jaydebeapi.connect("com.sybase.jdbc4.jdbc.SybDriver", "jdbc:sybase:Tds:ip:5000/database" ,["user" "pass"],'local_path/jconn4.jar') cursor = cnxn.cursor() cursor.execute(select *...

Magnezone7