Network client driver examples

Example 1

The following example connects to the default server name localhost on the default port, 1527, and to the database sample. It specifies the user and password URL attributes. You must set these attributes before attempting to connect to the server.

jdbc:derby://localhost:1527/sample;user=judy;password=no12see

Example 2

The following example specifies both Derby and Network Client driver attributes:
jdbc:derby://localhost:1527/sample;create=true;user=judy;
password=no12see

Example 3

This example connects to the default server name localhost on the default port, 1527, and includes the path in the database name portion of the URL.

jdbc:derby://localhost:1527/c:/my-db-dir/my-db-name;user=judy;
password=no12see

Example 4

The following example shows how to use the network client driver to connect the network client to the Network Server:

String databaseURL = "jdbc:derby://localhost:1527/sample";
// Load Derby Network Client driver class
Class.forName("org.apache.derby.jdbc.ClientDriver");
// Set user and password properties
Properties properties = new Properties();
properties.put("user", "APP");
properties.put("password", "APP");
// Get a connection
Connection conn = DriverManager.getConnection(databaseURL, properties); 
Related concepts
Accessing the Network Server by using the DB2 Universal Driver
Related reference
Network client security
Network client tracing