Testing Your Connection

To test your newly cataloged connection to the Apache Derby database, you can connect to the database from the DB2 command line as follows:

bash$ db2 CONNECT TO database USER user-name

The DB2 command line prompts you for a password and then tries to connect to the requested database. If the connection is successful, DB2 returns output like the following:

Enter current password for lynn:

   Database Connection Information

 Database server        = Apache Derby CSS10000
 SQL authorization ID   = lynn
 Local database alias   = YMLD

WHY DO I NEED TO SPECIFY A USER ID AND PASSWORD?

By default, Apache Derby does not enable any user authentication, so it might seem surprising that you have to specify a user ID and password for any connection ...

Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial