Chapter 18. Configuring MS Access, MySQL, and Oracle9i

Topics in This Chapter

  • Configuring a DSN to connect to Microsoft Access

  • Installing and configuring MySQL

  • Creating databases and users in MySQL

  • Installing and configuring Oracle9i

  • Using the Database Configuration Assistant to create a database in Oracle9i

  • Manually creating a database in Oracle9i

  • Creating users in Oracle9i

  • Testing your database through a JDBC connection

  • Determining the JDBC version of your database driver

  • Setting up the example music table

In this chapter, we provide details for configuring three popular databases for use with JDBC: Microsoft Access, MySQL, and Oracle9i.

The first database, Microsoft Access, is an excellent database for practice and experimentation because the Java SDK ...

Get Core Servlets and JavaServer Pages™: Volume 1: Core Technologies, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.