Using dblook

The syntax for the command to launch the dblook utility is as follows.

dblook -d connectionURL [options]

The value for connectionURL is the complete URL for the database. Where appropriate, the URL includes any connection URL attributes that might be required to access the database. For complete information on connection URL attributes, see "Setting attributes for the database connection URL" in the Derby Reference Manual.

For example, to connect to the database myDB, the URL would simply be 'jdbc:derby:myDB'. To connect using the Network Server to the database 'C:\private\tmp\myDB' on a remote server (port 1527), the URL would be:

'jdbc:derby://localhost:1527/"C:\private\tmp\myDB";user=someusr;password=somepwd'

As with other Derby utilities, you must ensure that no other JVMs are started against the database when you call the dblook utility, or an exception will occur and will print to the dblook.log file. If this exception is thrown, the dblook utility will exit. To recover, you must ensure that no other Derby applications running in a separate JVM are connected to the source database. These connections need to be shut down. Once all existing JVMs running against the database have been shut down, the dblook utility will execute successfully.

You can also start the Derby Network Server and run the dblook utility as a client application while other clients are connected to the server.

Related concepts
Generating the DDL for a database
Related reference
dblook options
dblook examples