mirror of
https://gitee.com/pnoker/iot-dc3.git
synced 2026-10-31 10:11:49 +08:00
pnoker
9aa5a6bdb9
The shared JDBC driver base interpolated the point value into the write SQL via
writeQuery.replace("${value}", ...), allowing a crafted write command value to
alter the statement. Bind the value with PreparedStatement#setString against a
single ? placeholder instead. Update the mysql/oracle/postgresql/sqlserver
writeQuery attribute docs to the ? convention and add the module's first test.
DC3 Common SQL
Overview
dc3-common-sql is the shared base for the database (JDBC) drivers of the IoT DC3 platform. It provides
AbstractJdbcDriverCustomService, a common driver-service base that handles JDBC connection management (via HikariCP)
and query execution, so each database driver only supplies its dialect/connection specifics.
Module Information
- Group ID: io.github.pnoker
- Artifact ID: dc3-common-sql
- Version: 2026.5.22
Key Components
| Component | Purpose |
|---|---|
AbstractJdbcDriverCustomService |
Base driver service for JDBC sources — pooled connections + queries |
Dependencies
dc3-common-driver— Driver SDK that the base service plugs intoHikariCP— JDBC connection pool
Build Instructions
mvn -s ../../.mvn/settings.xml clean package
Related Modules
dc3-driver-mysql,dc3-driver-oracle,dc3-driver-postgresql,dc3-driver-sqlserver— JDBC drivers that extendAbstractJdbcDriverCustomService
License
Copyright 2016-present the IoT DC3 original author or authors.
Licensed under the GNU Affero General Public License v3.0 (AGPL 3.0)