JDBC Implementation Notes

This section focuses on some important aspects to consider when using the ActiveSpaces JDBC driver.

  • JDBC Data Types
    ActiveSpaces uses a small set of data types for storing data in a data grid. When using the ActiveSpaces JDBC driver, it is important to know how the JDBC data types map to the ActiveSpaces data types.
  • DatabaseMetaData Pattern Parameters
    Methods of the DatabaseMetaData interface that take arguments that are string patterns, it must be noted that the pattern "%" are matched only when used by itself.
  • ResultSetMetaData and Function Return Values
    ActiveSpaces determines the data types of the return values of functions used in queries at runtime. When the ResultSet for a query contains the return value of a function, VARCHAR is always reported as the data type for the value in the ResultSetMetaData.
Related concepts
Related tasks