A common question we get on the derby-user list is how to talk to a Derby database running in embedded mode from a separate client, such as a report tool or visual query tool.

You can do this by starting a network server in the same VM as the embedded database.

The code is pretty simple

import org.apache.derby.drda.NetworkServerControl;
import java.net.InetAddress;
NetworkServerControl server = new NetworkServerControl
	(InetAddress.getByName("localhost"),1527);
server.start(null);

Then you just connect to it using the standard network client URL, e.g.

"jdbc:derby://localhost:1527/sample"