Murach's Java SE 6
How to work with a Derby database

Apache Derby is an open-source, Java-based, relational database management system that's included in Java SE 6. In this chapter, you'll learn the basics of working with a Derby database, whether it's embedded in an application or whether you access it over a server. That includes learning how to use the ij tool to create and query a database.
Chapter 22 How to work with a Derby database
An introduction to Derby 760
An overview of Derby 760
How to configure your system to work with a Derby database 762
How to use the ij tool to work with a Derby database 764
How to start and stop the ij tool 764
How to connect to and disconnect from a database 764
How to create a database and connect to it 766
How to run SQL statements 766
How to run SQL scripts from the ij prompt 768
How to run SQL scripts from the command prompt 770
How to use JDBC to work with an embedded database 772
How to set the default directory for the database 772

How to connect to the database and start the database engine

 772
How to disconnect from the database and shut down the database engine 774

A class that creates an embedded Derby database

 776
How to use JDBC to work with a networked database 782
How to start the Derby server 782

How to connect to a database on the server

 784
How to learn more about Derby 786
How to view the Derby documentation 786

How to navigate through the documentation

 786


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's Java SE 6

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.