Use Limits

The list of unsupported items in JDBC

Sharding-JDBC currently supports common JDBC methods.

The DataSource interface

  • Do not support methods related to timeout.

The Connection interface

  • Does not support stored procedures, functions, cursor operation
  • Does not Native SQL
  • Does not support savepoint related operations
  • Does not support Schema / Catalog operation
  • Does not support Custom type mapping

The interface of Statement and PreparedStatement

  • Does not support statements that return multiple result sets (That is, stored procedures)
  • Does not support using international characters

The ResultSet interface

  • Does not support getting result set pointer position
  • Does not support changing the position of the result pointer by none-next methods
  • Does not support modifying the content of result set
  • Does not support using international characters
  • Does not support getting Array

The interface of JDBC 4.1

  • Does not support new interface features in JDBC 4.1.

Learn more about the unsupported items, please refer to io.shardingjdbc.core.jdbc.unsupported.

The limits of SQL statement

Support some kinds of subqueries

Does not support HAVING

Does not support OR,UNION 和 UNION ALL

Does not support special INSERT

Each INSERT statement can only contain one row of data. And does not support the statement that multiple rows of data are contained in INSERT…VALUES.

Does not support DISTINCT Aggregation

Does not support dual virtual table

Does not support SELECT LAST_INSERT_ID()

Does not support CASE WHEN