python使用jardebeiapi连接多种数据库

最新推荐文章于 2024-09-01 09:25:23 发布

码农的快乐

最新推荐文章于 2024-09-01 09:25:23 发布

阅读量828

点赞数

分类专栏：小工具方法文章标签： python

本文链接：https://blog.csdn.net/weixin_43455405/article/details/108004052

版权

总结jaydebeapi连接不同数据库

- Mysql
- Hive
- Phoenix
- sybase
- clickhouse

Mysql

	conn = jaydebeapi.connect('com.mysql.jdbc.Driver',self.MySqlUrl+'?useSSL=false', [self.MySqlUser, self.MySqlPwd], './mysql-connector-java-5.1.46.jar')
        curs = conn.cursor()

Hive

jarFiles =['./commons-httpclient-3.0.1-sources.jar'
                  ,'./commons-logging-1.3.jar'
                  ,'./curator-client-2.2.0-incubating.jar'
                  ,'./curator-framework-2.6.0.jar'
                  ,'./hadoop-auth-2.7.3.jar'
                  ,'./hadoop-common-2.7.3.jar'
                  ,'./hive-exec-1.2.2.jar'
                  ,'./hive-jdbc-1.2.2.jar'
                  ,'./hive-metastore-1.2.2.jar'
                  ,'./hive-service-1.2.2.jar'
                  ,'./httpclient-4.4.jar'
                  ,'./httpcore-4.