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

SQL

Ensure That Your Environment Variables Are Properly Set

Make sure that you have issued the setEmbbeddedCP command in Windows or setEmbeddedCP.sh in Linux. These commands are case-sensitive in Linux, so make sure you type the shell command correctly. This command sets up the appropriate environment variables for running Apache Derby on your operating system.

Use Declared Tables for Temporary Storage

The DECLARE statement is very similar to the CREATE statement, except that it is used to create temporary tables that are used only during a session. The only object that can be declared is a table, and it exists only for the current user who created it.

The creation of a temporary table does not update the catalog, so locking, logging, and other ...

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