What is metadata with examples dataedo data terminology. This interface is implemented by driver vendors to let users know the capabilities of a. Metadata is data that describes data, but it isnt the data itself. Java connection getmetadata method with example tutorialspoint. From a programmers point of view, database metadata refers to data about database data or, more elaborately, the information about tables, views, column types, column names, result sets, stored procedures, and databases. All the fields you see by each file in file explorer is actually metadata. A metadata function is both scalar and nondeterministic. Typically the databasemetadata helps while creating the database tools. Databasemetadata interface provides methods to get meta data of a database such as database product name, database product version, driver name, name of total number of tables, name of. Databasemetadata interface provides methods to get meta data of a database such as database product name, database product version, driver name, name of total number of tables, name of total number of views etc.
Retrieves the version number of this jdbc driver as a string. The databases metadata is information about the data, what. String getdriverversion this method returns the version of jdbc driver used to. Paper document files have often administrative metadata that help manage documents.
Connecting to sql server 2000 from windows unix using jdbc. Databasemetadata class to obtain information about the. Discovering database metadata with the jdbc metadata api. Databasemetadata is used to know which type of driver we are using and whether is it compatable or jdbc. The examples are extracted from open source java projects. The databasemetadata interface provides methods to get information. This getdriverversion method is specified by the getdriverversion method in the java. Java databasemetadata example with examples on driver, drivermanager.
The databasemetadata interface provides methods to get information about the database you have connected with like, database name, database driver version, maximum column length etc following are some methods of databasemetadata class. Here is the simple example for databasemetadata in jdbc. Metadata functions return information about the server instance, the databases on that instance, and the objects within the databases. The author and creation date metadata stored in a microsoft word document, for example, is not the entirety of the document but instead just a few details about the file. Learning about a data source using databasemetadata methods ibm. This means that the function returns only single data value and that value will not necessarily be the same each time you run the function, even if you pass in the same input values. Interface databasemetadata university of wisconsinmadison. Databasemetadata in jdbc example onlinetutorialspoint. Comprehensive information about the database as a whole. Java code examples to read database metadata with databasemetadata and resultsetmetadata. Following example demonstrates the usage of databasemetadata class.
113 1002 527 796 974 456 533 534 46 948 1213 361 339 116 434 791 426 570 696 82 991 907 187 1167 1338 838 630 969 181 464 1237 765 1278 784 1418 1438 407