Wiki¶
Functions¶
The JDBC Metadata plugin is a wrapper for the Metadata functions available in the JDBC driver(s).
If you want the plugin to support more of these functions please create a feature request.
Just be aware that it's up to the JDBC driver to provide the correct information. Even though JDBC is an official and standardized specification some drivers might have their own 'interpretation' on what to return (see screenshot with Oracle driver info).
Right now it has the following functions:
Function | Description |
getVersion() | Returns the version of this plugin |
getDatabaseProductName(serverName) | Returns the product name of the database server |
getDatabaseProductVersion(serverName) | Returns the product version of the database server |
getDatabaseProductMajorVersion(serverName) | Returns the major version of the database server |
getDatabaseProductMinorVersion(serverName) | Returns the minor version of the database server |
getDefaultTransactionIsolation(serverName) | Return the default Isolation Level of the database |
getDriverName(serverName) | Returns the JDBC driver name |
getDriverVersion(serverName) | Returns the JDBC driver version |
getDriverMajorVersion(serverName) | Returns the JDBC driver major version |
getDriverMinorVersion(serverName) | Returns the JDBC driver minor version |
getJDBCMajorVersion(serverName) | Returns the JDBC major version of the driver |
getJDBCMinorVersion(serverName) | Returns the JDBC minor version of the driver |
Screenshots¶
MySQL
PostgreSQL
MS SQL Server
Oracle