Python Connection
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
Python Connection
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
#pip3 -> python 3.9 # - Instalar com pip3 #pip3 install JayDeBeApi --user #pip3 install JPype1==0.6.3 --user import jaydebeapi #variables to connect to zimjdbc8.jar jclassname='zim.jdbc.ZJ_Driver' jdbc_driver_loc = r'C:\Users\xxx\Documents\p01\zimjdbc8.jar' jdbc_driver_name = 'zim.jdbc.ZJ_Driver' host='localhost:6002' #url and login variables url='jdbc:zim://' + host + '/zimdb01' login="ZIM" psw="" #sql to be executed at the Zim's side. sql = "SELECT codie, name from test" #connection to the JDBC driver conn = jaydebeapi.connect(jclassname=jdbc_driver_name, url=url, driver_args=[login, psw], jars=jdbc_driver_loc) #open the cursor cur = conn.cursor() #execute the SQL statement cur.execute(sql) #print the result print(cur.fetchall())...
Updated
ByCelso Bressan
Was this article helpful?
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
5