Java Database

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 Training courses from the book’s author: http://courses.coreservlets.com/

• • • • • Personally developed and taught by Marty Hall Available onsite at your organization (any country) Topics and pace can be customized for your developers Also available periodically at public venues Topics include Java programming, beginning/intermediate servlets and JSP, advanced servlets and JSP, Struts, JSF/MyFaces, Ajax, GWT, Ruby/Rails and more. Ask for custom courses!

© Prentice Hall and Sun Microsystems Press. Personal use only.

18

Training courses from the book’s author: http://courses.coreservlets.com/

• • • • • Personally developed and taught by Marty Hall Available onsite at your organization (any country) Topics and pace can be customized for your developers Also available periodically at public venues Topics include Java programming, beginning/intermediate servlets and JSP, advanced servlets and JSP, Struts, JSF/MyFaces, Ajax, GWT, Ruby/Rails and more. Ask for custom courses!

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 (or JDK) already includes the appropriate JDBC driver and many developers already have Access installed. However, you would be unlikely to use Microsoft Access for serious applications, since it is not designed to handle a large...