工具
以下工具现在均可在官网下载最新版本:
- GBase DataStudio
- GBase MigrationToolkit
https://www.gbase.cn/download/gbase-8s-1?category=TOOLKIT
JDBC包驱动
- CLASS:
com.gbasedbt.jdbc.Driver
- URL:
jdbc:gbasedbt-sqli://IPADDR:PORT/DBNAME:GBASEDBTSERVER=<GBASEDBTSERVER>;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8;IFX_LOCK_MODE_WAIT=30;
# 集群连接
jdbc:gbasedbt-sqli:/DBNAME:GBASEDBTSERVER=<GROUPNAME>;SQLH_TYPE=FILE;SQLH_FILE=/opt/gbase/etc/sqlhosts;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8;IFX_LOCK_MODE_WAIT=30;
- JDBC jar包:
当前支持mvn仓库
<!-- https://mvnrepository.com/artifact/com.gbasedbt/jdbc -->
<dependency>
<groupId>com.gbasedbt</groupId>
<artifactId>jdbc</artifactId>
<version>3.5.1.32</version>
</dependency>
Hibernate方言包
- Hibernate方言包集
- Hibernate-GBase8s Sample
Mybatis支持
mybatis不支持lvarchar字段类型,可以mybatis-config.xml中增加typeHandlers配置以支持。
<typeHandlers> <typeHandler handler="org.apache.ibatis.type.StringTypeHandler" jdbcType="LONGVARCHAR" javaType="String" /> </typeHandlers>
注:<typeHandlers>的位置,需要在<environments> 之前
- Mybatis3-GBase8s Sample
PDO_GBASEDBT
- PHP: 基于PDO_INFORMIX-1.3.6, https://pecl.php.net/package/PDO_INFORMIX
DBD::GBasedbt
- Perl: 基于DBD::Informix 2018-1031,https://metacpan.org/release/DBD-Informix
注:版本等待更新
django-gbasedbtdb
- Python, Django: 基于django-informixdb, https://pypi.org/project/django-informixdb/
DbtPy
- Python, DbtPy: 基于IfxPy, https://pypi.org/project/IfxPy/
sqlalchemy-gbasedbt
- Python, sqlalchemy: 基于sqlalchemy-informix, https://gitlab.com/apollo13/sqlalchemy-informix/
BenchMarkSQL
- 根据BenchMarkSQL修改,增加GBase 8s的支持,https://sourceforge.net/projects/benchmarksql/
已有 2 条评论