5. Dev Manual - 5.4. DataSource - 《Apache ShardingSphere v5.3.2 Documentation》

DatabaseType
DialectSchemaMetaDataLoader
DataSourcePoolMetaData
DataSourcePoolActiveDetector
ShardingSphereDriverURLProvider

DatabaseType

Fully-qualified class name

org.apache.shardingsphere.infra.database.type.DatabaseType

Definition

Supported database types definition

Implementation classes

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

DialectSchemaMetaDataLoader

Fully-qualified class name

org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.DialectSchemaMetaDataLoader

Definition

Use SQL dialect to load meta data rapidly

Implementation classes

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

DataSourcePoolMetaData

Fully-qualified class name

org.apache.shardingsphere.infra.datasource.pool.metadata.DataSourcePoolMetaData

Definition

Data source connection pool metadata

Implementation classes

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

DataSourcePoolActiveDetector

Fully-qualified class name

org.apache.shardingsphere.infra.datasource.pool.destroyer.detector.DataSourcePoolActiveDetector

Definition

Data source connection pool active detector

Implementation classes

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

ShardingSphereDriverURLProvider

Fully-qualified class name

org.apache.shardingsphere.driver.jdbc.core.driver.ShardingSphereDriverURLProvider

Definition

ShardingSphere driver URL provider

Implementation classes

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

Notice

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>