# Network client driver examples

The following examples specify the user and password URL attributes. To enable user authentication, the property derby.connection.requireAuthentication must be set to true, otherwise, Derby does not require a user name and password. For details on how to enable user authentication, please see "Working with user authentication" in the Java DB Developer's Guide.

For a multi-user product, you would typically set it for the system in the derby.properties file for your server, since it is in a trusted environment. Below is a sample derby.properties file that conforms to these examples:

    derby.connection.requireAuthentication=true
    derby.authentication.provider=BUILTIN
    derby.user.judy=no12see

Important: Derby's BUILTIN authentication mechanism is suitable only for development and testing purposes. It is strongly recommended that production systems rely on LDAP or a user-defined class for authentication. It is also strongly recommended that production systems protect network connections with SSL/TLS.

#### Example 1

The following example connects to the default server name localhost on the default port, 1527, and to the database sample.

    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.
    // If you are running on JDK 6 or higher, you do not
    // need to invoke Class.forName(). In that environment, the
    // network client driver loads automatically.
    //
    Class.forName("org.apache.derby.jdbc.ClientDriver");
    // Set user and password properties
    Properties properties = new Properties();
    properties.setProperty("user", "judy");
    properties.setProperty("password", "no12see");
    // Get a connection
    Connection conn = DriverManager.getConnection(databaseURL, properties);

Parent topic: Accessing the Network Server by using the network client driver
Related concepts
Network client security
Related reference
Network client tracing