Skip to main content

Driver Adapters

JDBC driver adapters are a set of JDBC drivers implemented on the dbvisitor-driver framework. They integrate non-relational databases via standard JDBC interfaces.

Each adapter is an independent JDBC driver. It can be used directly through JDBC or integrated with Spring JDBC, MyBatis and dbVisitor. Adapters support data-source-specific commands and a subset of JDBC; before integrating another framework, check that its SQL, metadata and transaction requirements are within the supported scope.

They address the following core problems:

  • Simplified driver implementation: By abstracting the complexity of JDBC interfaces, developers can more easily implement JDBC-compatible layers for various data sources.
  • Non-relational database integration: Allows non-relational databases (NoSQL) to be accessed through standardized JDBC interfaces.
  • Unified access: Reuses JDBC connections, parameter binding and result reading to reduce interface differences between data sources.

Usage Guide​

  • Available Adapters
    • jdbc-redis is a JDBC driver adapter for Redis, allowing developers to operate the database using standard JDBC interfaces and Redis commands.
    • jdbc-mongo is a JDBC driver adapter for MongoDB, allowing developers to operate the database using standard JDBC interfaces and MongoDB commands.
    • jdbc-elastic is a JDBC driver adapter for Elasticsearch, allowing developers to operate data using standard JDBC interfaces and Elasticsearch native QueryDSL commands.
    • jdbc-milvus is a JDBC driver adapter for Milvus vector database, allowing developers to operate Milvus using standard JDBC interfaces and SQL-style commands.
  • Developing New Adapters
    • Custom Adapter Learn how to develop a custom JDBC driver adapter to implement a JDBC-compatible layer for your own database.
    • SQL Client Support Learn about keep-alive commands, property discovery, URL templates and query compatibility for DataGrip and DBeaver.