Section 4.5 Java DB Fundamentals

Learning Objectives

After you have completed this section, you should be able to

• understand the important concepts and technologies related to Java DB.
• set up Java DB and use it to access databases in your Java applications.

Activities

• Carefully read the learning objectives.
• Watch the related section of the presentation for Chapter 18;
• Read section 18.10, Java DB/Apache Derby of Chapter 18.
• Relevant documents are found at http://www.oracle.com/technetwork/java/javadb/overview/index.html
• See also the documents at https://docs.oracle.com/javadb/
• Find answers to the study questions below.
• Try to find a sample web application on the Web that uses Java DB, and work through it, especially if you choose to do Assignment 3C.

Study Questions

1. How is Java DB related to Apache Derby?
2. What server-side programming language can you use with Java DB for developing web-based applications?
3. What are the system requirements to run Java DB?
4. How do you install Java DB in your environment?
5. How do you configure your web server so that it can work with Java DB?
6. How does a web server work with Java DB?
7. How do you set up a user in Java DB to access specific data?
8. How do you set up your path for Java DB?
9. How do you set the root password?
10. Why do you need to delete the anonymous user?
11. How do you start the Java DB server?
12. How do create a Derby database and run SQL statements to manipulate or access the data?

Review

Do the self-review exercises for Chapter 18, and revisit your answers to the study questions.

Summary

Read Java DB FAQs at http://www.oracle.com/technetwork/java/javadb/overview/faqs-jsp-156714.html