Embedded server example You can start the Network Server in another thread automatically when starts by setting the derby.drda.startNetworkServer property, or you can start it by using a program. Embedded server example

See for details on this property.

The following example shows how to start the Network Server by using a program:

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

The program that starts the Network Server can access the database by using either the embedded driver or the Network Client driver. The server framework's attempt to boot the local JDBC driver is ignored because it has already been booted within the application's JVM. The server framework simply accesses the instance of that is already booted. There is no conflict between the application and the server framework.

The remote client can then connect through the client driver:

String nsURL="jdbc:derby://localhost:1527/sample"; java.util.Properties props = new java.util.Properties(); props.setProperty("user","usr"); props.setProperty("password","pwd"); Connection conn = DriverManager.getConnection(nsURL, props); /*interact with */ Statement s = conn.createStatement(); ResultSet rs = s.executeQuery( "SELECT * FROM HotelBookings");