-
yangm 数据达人Lv4
发表于2020-4-15 18:21
数据库 | 版本 | Driver | URL | 说明 |
ADS | | com.mysql.jdbc.Driver |
| 参考 mysql |
ArteryBase | | com.thunisoft.ArteryBase.Driver |
| 可参考postgresql |
DB2 | | com.ibm.db2.jcc.DB2Driver |
| |
DM 达梦 | | dm.jdbc.driver.DmDriver |
| |
Druid | | org.apache.calcite.avatica.remote.Driver |
| |
EsgynDB 易鲸捷 | | org.trafodion.jdbc.t4.T4Driver |
| |
Essbase | | essbase.olap2j.driver.EssbaseDriver |
| |
GBase 南大通用 | 8a | com.gbase.jdbc.Driver |
| |
| 8T | com.informix.jdbc.IfxDriver |
| 可参考Informix,注意驱动版本有差别 |
| 8s | com.gbasedbt.jdbc.IfxDriver |
| |
Greenplum | | com.pivotal.jdbc.GreenplumDriver |
| |
h2 | | org.h2.Driver |
| |
Hana | | com.sap.db.jdbc.Driver |
| |
HBase | | org.apache.phoenix.jdbc.PhoenixDriver |
| |
Hive | | org.apache.hive.jdbc.HiveDriver |
| |
HuaweiELK | org.postgresql.Driver |
| 参考 postgresql,驱动文件不同(是否等同 gauss200?) | |
HuaweiGauss 高斯 | Gauss100 | com.huawei.gauss.jdbc.ZenithDriver |
| |
| Gauss200 | com.huawei.gauss200.jdbc.Driver |
| 参考 postgresql |
HuaweiSparkSQL | | org.apache.hive.jdbc.HiveDriver |
| |
Impala | | org.apache.hive.jdbc.HiveDriver |
| Impala 专用的驱动目前不支持 |
Informix | | com.informix.jdbc.IfxDriver |
| 特别注意编码配置 |
KDB 浪潮 | | com.inspur.jdbc.KdDriver |
| |
Kingbase 人大金仓 | 7 | com.kingbase.Driver |
| |
| 8 | com.kingbase8.Driver |
| |
| KADB | com.kingbase.kingbaseanalyticsdb.Driver |
| |
Kylin | | org.apache.kylin.jdbc.Driver |
| |
MaxComputer(ODPS) | | [size=13.3333px]org.postgresql.Driver |
| 驱动与postgresql有区别,换用 MaxComputerJDBC.jar |
| | com.aliyun.odps.jdbc.OdpsDriver |
| 驱动为 odps-jdbc |
MongoDB | | mongodb.jdbc.MongoDriver |
| |
MSSQL(SQLServer) | | com.microsoft.sqlserver.jdbc.SQLServerDriver |
| |
MySQL | 5.x | com.mysql.jdbc.Driver |
| |
| 8 | com.mysql.cj.jdbc.Driver |
| 注意 databaseTerm 必须加,否则会出现 ABI-10532 的问题 |
Netezza | | org.netezza.Driver |
| |
Oracle | 10g,11g.... | oracle.jdbc.driver.OracleDriver |
| 注意servicename和sid的区别,url中符号不同 |
| 12c,18c,... | oracle.jdbc.driver.OracleDriver |
| |
Oscar 神舟通用 | | com.oscar.Driver |
| |
| | com.oscar.cluster.Driver |
| |
PetaBase | 2.1, | com.esen.jdbc.PetaBaseDriver |
| |
| Petabase-G | com.esen.jdbc.PetaBase3Driver |
| |
PostgreSQL | | org.postgresql.Driver |
| |
SparkSQL | | org.apache.hive.jdbc.HiveDriver |
| |
Sybase | | com.sybase.jdbc3.jdbc.SybDriver |
| |
Teradata | | com.teradata.jdbc.TeraDriver |
| |
Timesten | | com.timesten.jdbc.TimesTenDriver |
| |
TiDB | | com.mysql.jdbc.Driver |
| 参考MySQL |
TiSpark | | org.apache.hive.jdbc.HiveDriver |
| |
Transwarp 星环 | Inceptor | org.apache.hive.jdbc.HiveDriver |
| |
Vertica | | com.vertica.jdbc.Driver |
| |
XCloud | | com.bonc.xcloud.jdbc.XcloudDriver |
| |
6个回答
-
huangguan1985 数据小白Lv1
com.bonc.xcloud.jdbc.XcloudDriver 对应的XCloudJDBC.jar有下载吗
huangguan1985 发表于 2021-1-11 17:23
com.bonc.xcloud.jdbc.XcloudDriver 对应的XCloudJDBC.jar有下载吗
见附件
QueryObj ERROR:/abi/edatasource/jdbc.do?name=LOG56_ODS_dev&desc=&jdbcUrl=jdbcdps:http://service.cn-shanghai.maxco ... river&extprops={"catalog":"","maxActive":"20","maxWait":"10000","logLevel":"ERROR"}&action=testjdbc
java.lang.RuntimeException: 测试失败,找不到驱动类库(com.aliyun.odps.jdbc.OdpsDriver).
at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1522)
at com.esen.edatasource.api.util.JdbcUtils$1.call(JdbcUtils.java:182)
at com.esen.edatasource.api.util.JdbcUtils$1.call(JdbcUtils.java:178)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: com.aliyun.odps.jdbc.OdpsDriver
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1519)
... 7 more
JavaScript StackTrace:
Error: 测试失败,找不到驱动类库(com.aliyun.odps.jdbc.OdpsDriver).
--detailmessage--
QueryObj ERROR:/abi/edatasource/jdbc.do?name=LOG56_ODS_dev&desc=&jdbcUrl=jdbc%3Aodps%3Ahttp%3A%2F%2Fservice.cn-shanghai.maxcompute.aliyun.com%2Fapi%3Fproject%3DLOG56_ODS_dev&username=LTAI5tMWZNkboxP6TmfqkpbF&password=zSMMml5COYJWqaOCDqYOFw4kfwU0Mm&driverClassName=com.aliyun.odps.jdbc.OdpsDriver&extprops=%7B%22catalog%22%3A%22%22%2C%22maxActive%22%3A%2220%22%2C%22maxWait%22%3A%2210000%22%2C%22logLevel%22%3A%22ERROR%22%7D&action=testjdbc
java.lang.RuntimeException: 测试失败,找不到驱动类库(com.aliyun.odps.jdbc.OdpsDriver).
at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1522)
at com.esen.edatasource.api.util.JdbcUtils$1.call(JdbcUtils.java:182)
at com.esen.edatasource.api.util.JdbcUtils$1.call(JdbcUtils.java:178)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: com.aliyun.odps.jdbc.OdpsDriver
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1519)
... 7 more
--messageInfo--
rootExceptionClass=java.lang.ClassNotFoundException
at Object.throwError (https://abi.esensoft.com/abi/eui/eui.js:2628:19)
at QueryObj.checkResult (https://abi.esensoft.com/abi/eui/eui.js:3982:9)
at QueryObj._onreadystatechange (https://abi.esensoft.com/abi/eui/eui.js:3636:11)
at XMLHttpRequest.hp.onreadystatechange (https://abi.esensoft.com/abi/eui/eui.js:3708:10)