Network client driver examples
Derby Server and Administration Guide
26
· Use bitwise OR operators ( | ) with two or more trace values. For example, to trace
PROTOCOL flows and connection calls, specify this value for traceLevel:
TRACE_PROTOCOL_FLOWS | TRACE_CONNECTION_CALLS
· Use a bitwise complement operator ( ~ ) with a trace value to specify all except a
certain trace. For example, to trace everything except PROTOCOL flows, specify
this value for traceLevel:
~TRACE_PROTOCOL_FLOWS
For more information, see "traceLevel=value attribute" in the Derby Reference Manual.
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 Derby
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.
