3. If the method returns a ResultSet:
a. In a loop, position the cursor using the next method, and retrieve data from
each column of the current row of the ResultSet object using getXXX
methods.
b. Invoke the close method to close the ResultSet object.
Example: The following code demonstrates how to use DatabaseMetaData methods
to determine the driver version, to get a list of the stored procedures that are
available at the data source, and to get a list of datetime functions that the driver
supports. The numbers to the right of selected statements correspond to the
previously-described steps.
Connection con;
DatabaseMetaData dbmtadta;
ResultSet rs;
int mtadtaint;
String procSchema;
String procName;
String dtfnList;
...
dbmtadta = con.getMetaData(); // Create the DatabaseMetaData object 1
mtadtaint = dmtadta.getDriverVersion(); 2
// Check the driver version
System.out.println("Driver version: " + mtadtaint);
rs = dbmtadta.getProcedures(null, null, "%");
// Get information for all procedures
while (rs.next()) { // Position the cursor 3a
procSchema = rs.getString("PROCEDURE_SCHEM");
// Get procedure schema
procName = rs.getString("PROCEDURE_NAME");
// Get procedure name
System.out.println(procSchema + "." + procName);
// Print the qualified procedure name
}
dtfnList = dbmtadta.getTimeDateFunctions();
// Get list of supported datetime functions
System.out.println("Supported datetime functions:");
System.out.println(dtfnList); // Print the list of datetime functions
rs.close(); // Close the ResultSet 3b
Related concepts
“JDBC connection objects” on page 19
Related reference
“Driver support for JDBC APIs” on page 252
“JDBC differences between the current IBM Data Server Driver for JDBC and
SQLJ and earlier DB2 JDBC drivers” on page 370
DatabaseMetaData methods for identifying the type of data
source
You can use the DatabaseMetaData.getDatabaseProductName and
DatabaseMetaData.getProductVersion methods to identify the type and level of the
database manager to which you are connected, and the operating system on which
the database manager is running.
Figure 7. Using DatabaseMetaData methods to get information about a data source
22 Application Programming Guide and Reference for Java
™
To Next Page
Loading...
Need help?
General