org.apache.shardingsphere.infra.database.type.DatabaseType
Supported database types definition
| Configuration Type | Description | Fully-qualified class name |
|---|---|---|
| SQL92 | SQL92 database type | org.apache.shardingsphere.infra.database.type.dialect.SQL92DatabaseType |
| MySQL | MySQL database | org.apache.shardingsphere.infra.database.type.dialect.MySQLDatabaseType |
| MariaDB | MariaDB database | org.apache.shardingsphere.infra.database.type.dialect.MariaDBDatabaseType |
| PostgreSQL | PostgreSQL database | org.apache.shardingsphere.infra.database.type.dialect.PostgreSQLDatabaseType |
| Oracle | Oracle database | org.apache.shardingsphere.infra.database.type.dialect.OracleDatabaseType |
| SQLServer | SQLServer database | org.apache.shardingsphere.infra.database.type.dialect.SQLServerDatabaseType |
| H2 | H2 database | org.apache.shardingsphere.infra.database.type.dialect.H2DatabaseType |
| openGauss | OpenGauss database | org.apache.shardingsphere.infra.database.type.dialect.OpenGaussDatabaseType |
org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.DialectSchemaMetaDataLoader
Use SQL dialect to load meta data rapidly
| Configuration Type | Description | Fully-qualified class name |
|---|---|---|
| MySQL | Use MySQL dialect to load meta data | org.apache.shardingsphere.infra.metadata.database.schema.loader.dialect.MySQLSchemaMetaDataLoader |
| Oracle | Use Oracle dialect to load meta data | org.apache.shardingsphere.infra.metadata.database.schema.loader.dialect.OracleSchemaMetaDataLoader |
| PostgreSQL | Use PostgreSQL dialect to load meta data | org.apache.shardingsphere.infra.metadata.database.schema.loader.dialect.PostgreSQLSchemaMetaDataLoader |
| SQLServer | Use SQLServer dialect to load meta data | org.apache.shardingsphere.infra.metadata.database.schema.loader.dialect.SQLServerSchemaMetaDataLoader |
| H2 | Use H2 dialect to load meta data | org.apache.shardingsphere.infra.metadata.database.schema.loader.dialect.H2SchemaMetaDataLoader |
| openGauss | Use OpenGauss dialect to load meta data | org.apache.shardingsphere.infra.metadata.database.schema.loader.dialect.OpenGaussSchemaMetaDataLoader |
org.apache.shardingsphere.infra.datasource.pool.metadata.DataSourcePoolMetaData
Data source connection pool metadata
| Configuration Type | Description | Fully-qualified class name |
|---|---|---|
| org.apache.commons.dbcp.BasicDataSource, org.apache.tomcat.dbcp.dbcp2.BasicDataSource | DBCP data source pool meta data | org.apache.shardingsphere.infra.datasource.pool.metadata.type.dbcp.DBCPDataSourcePoolMetaData |
| com.zaxxer.hikari.HikariDataSource | Hikari data source pool meta data | org.apache.shardingsphere.infra.datasource.pool.metadata.type.hikari.HikariDataSourcePoolMetaData |
| com.mchange.v2.c3p0.ComboPooledDataSource | C3P0 data source pool meta data | org.apache.shardingsphere.infra.datasource.pool.metadata.type.c3p0.C3P0DataSourcePoolMetaData |
org.apache.shardingsphere.infra.datasource.pool.destroyer.detector.DataSourcePoolActiveDetector
Data source connection pool active detector
| Configuration Type | Description | Fully-qualified class name |
|---|---|---|
| Default | Default data source pool active detector | org.apache.shardingsphere.infra.datasource.pool.destroyer.detector.type.DefaultDataSourcePoolActiveDetector |
| com.zaxxer.hikari.HikariDataSource | Hikari data source pool active detector | org.apache.shardingsphere.infra.datasource.pool.destroyer.detector.type.HikariDataSourcePoolActiveDetector |
org.apache.shardingsphere.driver.jdbc.core.driver.ShardingSphereDriverURLProvider
ShardingSphere driver URL provider
| Configuration Type | Description | Fully-qualified class name |
|---|---|---|
| jdbc:shardingsphere:classpath: |
The classpath driver URL provider | org.apache.shardingsphere.driver.jdbc.core.driver.spi.ClasspathDriverURLProvider |
| jdbc:shardingsphere:absolutepath: |
The absolute path driver URL provider | org.apache.shardingsphere.driver.jdbc.core.driver.spi.AbsolutePathDriverURLProvider |
| jdbc:shardingsphere:apollo: |
The apollo driver URL provider | org.apache.shardingsphere.driver.jdbc.core.driver.spi.ApolloDriverURLProvider |
When you use the Apollo driver url provider, you need to add the corresponding apollo pom dependency, currently available at version 1.9.0, as follows:
<dependency>
<groupId>com.ctrip.framework.apollo</groupId>
<artifactId>apollo-client</artifactId>
<version>${apollo.version}</version>
</dependency>