Documentation Home
Connectors and APIs Manual
Download this Manual

3.5.3.9 Metadata

  • getProceduresReturnsFunctions

    Pre-JDBC4 DatabaseMetaData API has only the getProcedures() and getProcedureColumns() methods, so they return metadata info for both stored procedures and functions. JDBC4 was extended with the getFunctions() and getFunctionColumns() methods and the expected behaviours of previous methods are not well defined. For JDBC4 and higher, default 'true' value of the option means that calls of DatabaseMetaData.getProcedures() and DatabaseMetaData.getProcedureColumns() return metadata for both procedures and functions as before, keeping backward compatibility. Setting this property to 'false' decouples Connector/J from its pre-JDBC4 behaviours for DatabaseMetaData.getProcedures() and DatabaseMetaData.getProcedureColumns(), forcing them to return metadata for procedures only.

    Default Value true
    Since Version 5.1.26
  • noAccessToProcedureBodies

    When determining procedure parameter types for CallableStatements, and the connected user can't access procedure bodies through "SHOW CREATE PROCEDURE" or select on mysql.proc should the driver instead create basic metadata (all parameters reported as INOUT VARCHARs) instead of throwing an exception?

    Default Value false
    Since Version 5.0.3
  • nullDatabaseMeansCurrent

    When DatabaseMetadata methods ask for a 'catalog' or 'schema' parameter, does the value null mean use the current database? See also property 'databaseTerm'.

    Default Value false
    Since Version 3.1.8
  • useHostsInPrivileges

    Add '@hostname' to users in DatabaseMetaData.getColumn/TablePrivileges() (true/false), defaults to 'true'.

    Default Value true
    Since Version 3.0.2
  • useInformationSchema

    Should the driver use the INFORMATION_SCHEMA to derive information used by DatabaseMetaData? Default is 'true' when connecting to MySQL 8.0.3+, otherwise default is 'false'.

    Default Value false
    Since Version 5.0.0