O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required