jaydebeapi icon indicating copy to clipboard operation
jaydebeapi copied to clipboard

Connection issue

Open leedsrising opened this issue 6 years ago • 3 comments

conn = jaydebeapi.connect(jclassname="com.teradata.presto.jdbc42.Driver", url="verified driver url",driver_args=[username, password], jars="/path/to/presto-jdbc42-1.0.14.1022.jar", libs=[]).

A colleague of mine has the same document formatting, same anaconda, python, and java versions as myself, but the above connection works for him (with the only change being the user directory correctly changed, everything else is mirrored) but I receive the error

jpype._jexception.RuntimeExceptionPyRaisable: java.lang.RuntimeException: Class com.teradata.presto.jdbc42.Driver not found

leedsrising avatar Mar 15 '18 18:03 leedsrising

Only solution I have found is completely uninstalling Python, Pip, and Anaconda, and then reinstalling just Anaconda. Working theory is that as a result of using python and pip independent installers in addition to the anaconda installer before, I created some problem with my environment variables that prevented the jar file from being found.

leedsrising avatar Mar 19 '18 15:03 leedsrising

Have you solve the problem? Can you list your solution procedures?

weihanhua avatar Aug 27 '19 00:08 weihanhua

This is old, but hopefully this helps someone else. It's possible that you should be passing your jdbc jar path to the libs arg, not the jars. This solved my filepath issues.

joerobmunoz avatar Jun 02 '20 21:06 joerobmunoz