JDBC Metadata, MySQL, and Oracle Recipes: A Problem-Solution by Mahmoud Parsian

By Mahmoud Parsian

First e-book to marketplace on metadata particular recipes relating to JDBC and its use with MySQL and Oracle, databases usual to Java.

Compliant with the hot Java EE 5.

Provides minimize and paste code templates that may be instantly personalized and utilized in each one developer’s software development.

Show description

Read Online or Download JDBC Metadata, MySQL, and Oracle Recipes: A Problem-Solution Approach PDF

Similar organization and data processing books

Languages and Compilers for Parallel Computing: 10th International Workshop, LCPC'97 Minneapolis, Minnesota, USA, August 7–9, 1997 Proceedings

This e-book constitutes the completely refereed post-workshop lawsuits of the tenth foreign Workshop on Languages and Compilers for Parallel Computing, LCPC'97, held in Minneapolis, Minnesota, united states in August 1997The publication provides 28 revised complete papers including 4 posters; all papers have been conscientiously chosen for presentation on the workshop and went via an intensive reviewing and revision section afterwards.

Cloud Computing: Web-basierte dynamische IT-Services (Informatik im Fokus) (German Edition)

Als Internetdienst erlaubt Cloud Computing die Bereitstellung und Nutzung von IT-Infrastruktur, Plattformen und Anwendungen. Dabei wird stets die aktuell benötigte Menge an Ressourcen zur Verfügung gestellt und abgerechnet. In dem Buch vermitteln die Autoren einen Überblick über Cloud-Computing-Architektur, ihre Anwendungen und Entwicklung.

Data Management in a Connected World: Essays Dedicated to Hartmut Wedekind on the Occasion of His 70th Birthday

Info administration structures play the main the most important position in development huge software s- tems. given that smooth purposes aren't any longer unmarried monolithic software program blocks yet hugely versatile and configurable collections of cooperative providers, the knowledge mana- ment layer additionally has to conform to those new requisites.

Additional resources for JDBC Metadata, MySQL, and Oracle Recipes: A Problem-Solution Approach

Example text

Qxd 30 1/27/06 12:42 PM Page 30 CHAPTER 2 ■ DATABASE METADATA, PART 1 The Solution The solution is generic and can support MySQL, Oracle, and other relational databases. Oracle➥ DatabaseMetaData class) is an unsupported feature; therefore, we have to use a try-catch block. If the method returns a SQLException, we return the message “unsupported feature” in the XML result. DatabaseMetaData; … /** * Get database product name and version information. * This method calls 4 methods (getDatabaseMajorVersion(), * getDatabaseMinorVersion(), getDatabaseProductName(), * getDatabaseProductVersion()) to get the required information * and it represents the information as XML.

When a RowSetReader object reads data into a RowSet object, it creates a RowSetMetaData object and initializes it using the methods in the RowSetMetaData interface. Then the reader passes the RowSetMetaData object to the rowset. execute(); an application programmer would not use them directly. 3. How Do You Discover Database Metadata? To discover metadata information about a database, you must create a DatabaseMetaData object. Note that some database vendors might not implement the DatabaseMetaData interface.

Albert Einstein T he goal of this chapter (and the next) is to show you how to use JDBC’s database metadata API, which you can use to get information about tables, views, column names, column types, stored procedures, result sets, and databases. It will be of most interest to those who need to write applications that adapt themselves to the specific capabilities of several database systems or to the content of any database. , dynamically), you will have to use metadata. You can use database metadata to • Discover database schema and catalog information.

Download PDF sample

Rated 4.82 of 5 – based on 4 votes