. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3.2 Maven . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3.3 ZooKeeper . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 4 Quick Start 5 4.1 Import Maven Dependency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4.2 Develop Job . Java 8 or above required. 3.2 Maven Maven 3.5.0 or above required. 3.3 ZooKeeper ZooKeeper 3.6.0 or above required. See details 4 4 Quick Start 4.1 Import Maven Dependency org

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3.2 Maven . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3.3 ZooKeeper . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 4 快速入门 5 4.1 引入 Maven 依赖 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4.2 作业开发 . . 注册中心管理 3 3 环境要求 3.1 Java 请使用 Java 8 及其以上版本。 3.2 Maven 请使用 Maven 3.5.0 及其以上版本。 3.3 ZooKeeper 请使用 ZooKeeper 3.6.0 及其以上版本。详情参见 4 4 快速入门 4.1 引入 Maven 依赖 org.apache.shardingsphere

1.4 Procedure 1. Rules configuration. Please refer to User Manual for more details. 2. Import Maven dependency org.apache.shardingsphere shardingsphere-jdbc which can omit the complexity of pro‐ gramming and simplify user configuration. Usage Import Maven Dependency org.apache.shardingsphere shardingsphere-jdbc timeToLiveSeconds: 60 Using the persistent repository requires additional introduction of the corresponding Maven depen‐ dencies. It is recommended to use: org.apache.shardingsphere

2 Sharding-JDBC入门使用 2.1不使用Spring 引入Maven依赖 基于Java编码的规则配置 Sharding-JDBC的分库分表通过规则配置描述，以下例子是根据user_id取模分库, 且根据 order_id取模分表的两库两表的配置。 org.apache.shardingsphere preparedStatement.setInt(2, 1001); try (ResultSet rs = preparedStatement.executeQuery()) { 2.2使用Spring 引入Maven依赖 基于Spring boot的规则配置 while(rs.next()) { System.out.println(rs.getInt(1)); 1:3306/demo_ds_slave_1? serverTimezone=UTC&useSSL=false # 这里的要求合法的jdbc连接串即可,目前尚未兼容 MySQL 8.x,需要在maven编译时候,升级MySQL JDBC版本到5.1.46或者47版本(不建议升级到 JDBC的8.x系列版本,需要修改源代码,并且无法通过很多测试case) username: root #

single jar file, "Add Folder" to add folder with Java classes/resources and "Add Artifact" to add Maven artifact (see below). After you add jar files you will be able to find all JDBC driver classes which directly from Maven repository (it is a global public repository of Java libraries, usually open-source). If your database driver is published on some public repository you can use this feature. Maven artifacts driver properties later you can access them directly from connection properties dialog: Libraries Maven artifacts Saving driver, adding connection DBeaver User Guide 21.2. Page 181 of 263. JDBC drivers

single jar file, "Add Folder" to add folder with Java classes/resources and "Add Artifact" to add Maven artifact (see below). After you add jar files you will be able to find all JDBC driver classes which directly from Maven repository (it is a global public repository of Java libraries, usually open-source). If your database driver is published on some public repository you can use this feature. Maven artifacts driver properties later you can access them directly from connection properties dialog: Libraries Maven artifacts Saving driver, adding connection DBeaver User Guide 6.2. Page 181 of 263. JDBC drivers

使用限制 目前仅支持 JAVA 语言 7.1.3 前提条件 开发环境需要具备 Java JRE 8 或更高版本。 7.1.4 操作步骤 1. 规则配置。 详情请参见用户手册。 2. 引入 maven 依赖。 org.apache.shardingsphere shardingsphere-jdbc 配置文件支持配置内容超过 3MB。 YAML 配置是最常见的配置方式，可以省略编程的复杂度，简化用户配置。 52 Apache ShardingSphere document 使用步骤 引入 Maven 依赖 org.apache.shardingsphere shardingsphere-jdbc server-lists: localhost:2181 retryIntervalMilliseconds: 500 timeToLiveSeconds: 60 使用持久化仓库需要额外引入对应的 Maven 依赖，推荐使用： org.apache.shardingsphere 9.1. ShardingSphere-JDBC 55

single jar file, "Add Folder" to add folder with Java classes/resources and "Add Artifact" to add Maven artifact (see below). After you add jar files you will be able to find all JDBC driver classes which directly from Maven repository (it is a global public repository of Java libraries, usually open-source). If your database driver is published on some public repository you can use this feature. Maven artifacts driver properties later you can access them directly from connection properties dialog: Libraries Maven artifacts Saving driver, adding connection DBeaver User Guide 6.3. Page 188 of 274. JDBC drivers

single jar file, "Add Folder" to add folder with Java classes/resources and "Add Artifact" to add Maven artifact (see below). After you add jar files you will be able to find all JDBC driver classes which directly from Maven repository (it is a global public repository of Java libraries, usually open-source). If your database driver is published on some public repository you can use this feature. Maven artifacts driver properties later you can access them directly from connection properties dialog: Libraries Maven artifacts Saving driver, adding connection DBeaver User Guide 7.0. Page 188 of 277. JDBC drivers

single jar file, "Add Folder" to add folder with Java classes/resources and "Add Artifact" to add Maven artifact (see below). After you add jar files you will be able to find all JDBC driver classes which directly from Maven repository (it is a global public repository of Java libraries, usually open-source). If your database driver is published on some public repository you can use this feature. Maven artifacts driver properties later you can access them directly from connection properties dialog: Libraries Maven artifacts Saving driver, adding connection DBeaver User Guide 7.1. Page 188 of 281. JDBC drivers