Category:DatabaseMetaData

From Java Example Source Code

These Java examples shows how to deal with DatabaseMetaData.

Using DatabaseMetaData, you can get comprehensive information about the database.

DatabaseMetaData is implemented by driver vendors to let users know the capabilities of a Database Management System (DBMS) in combination with the driver based on JDBC technology ("JDBC driver") that is used with it. Different relational DBMSs often support different features, implement features in different ways, and use different data types. In addition, a driver may implement a feature on top of what the DBMS offers. Information returned by methods in this interface applies to the capabilities of a particular driver and a particular DBMS working together. Note that as used in this documentation, the term "database" is used generically to refer to both the driver and DBMS.

In order to run these examples, one or more of the following libraries may be required: In order to run this example program, one of the following libraries may be required:

• MySQL JDBC driver. You can download it from MySQL Connector/J — for connecting to MySQL from Java
• Oracle JDBC driver. You can download it from JDBC driver for Oracle.
• MSSQL JDBC driver. There are several vendors provide JDBC driver for MSSQL, you should chose one of them:
  • jTDS - SQL Server and Sybase JDBC driver. It is an open source JDBC 3.0 Type 4 driver for Microsoft SQL Server (6.5, 7.0, 2000 and 2005) and Sybase. jTDS is the fastest JDBC driver for MS SQL Server and is a complete implementation of the JDBC spec. You can download it from jTDS - SQL Server and Sybase JDBC driver
  • MSSQL JDBC driver from Microsoft.
    • JDBC driver for MSSQL 2000. You can download it from SQL Server 2000 Driver for JDBC Service Pack 3
    • JDBC driver for MSSQL 2005. You can download it from Microsoft SQL Server 2005 JDBC Driver 1.2
• PostgreSQL JDBC driver. You can download it from PostgreSQL JDBC driver. It is a pure Java (Type IV) implementation.
• HSQLDB JDBC Driver. HSQLDB is the leading SQL relational database engine written in Java. It has a JDBC driver and supports a rich subset of ANSI-92 SQL plus SQL 99 and 2003 enhancements. You can download it from hsqldb.