You can use the ij tool to connect to a Derby database.
You must add the DERBY_HOME/bin directory in your PATH environment variable before you can run the ij tool.
ijThe ij script starts the ij tool and sets up the environment variables like CLASSPATH.
ij> connect 'jdbc:derby:testdb;create=true';This command creates a database called testdb in the current directory, populates the system tables, and connects to the database. You can then run any SQL statements from the ij command line.