jaydebeapi icon indicating copy to clipboard operation
jaydebeapi copied to clipboard

Problem in connecting teradata to azure databricks

Open Beetleferret opened this issue 3 years ago • 3 comments

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 avatar Nov 10 '21 04:11 Beetleferret

Hi Beetleferret,

Looking to your jar paths, it could be that you are on a Mac. It's an old solution, but you could try to start the JVM explicitly using the entries that are stated in this solution: https://downloads.teradata.com/forum/connectivity/problem-connecting-to-teradata-using-python-jaydebeapi-module

jpsteege avatar Nov 14 '21 16:11 jpsteege

Hi jpsteege,

I am able to connect through jupyter but in databricks still its not resolving.

Beetleferret avatar Nov 18 '21 07:11 Beetleferret

Sorry, missed that context. Hopefully you will find a solution/fix soon!

jpsteege avatar Nov 18 '21 12:11 jpsteege