Accessing the Network Server by using the network client driver

When connecting to the Network Server, your application needs to
load a driver and connection URL that is specific to the Network Server. In
addition, you must specify a user name and password if you are using authentication.

The driver that you need to access the Network Server is:

org.apache.derby.jdbc.ClientDriver

The syntax of the URL that is required to access the Network Server is:

Retrieve message text from the server. A stored procedure
is called to retrieve the message text with each SQLException and might
start a new unit of work. Set this property to false if you do not want the
performance impact or when starting new units of work.

retrieveMessageText

The default is true.

Table 3. Server-Specific DataSource properties

Property

Type

Description

URL attributes

Notes

connectionAttributes

String

Set to the list of Derby embedded
connection attributes separated by semicolons.

Various

This property is also available using EmbeddedDataSource.
See the Derby Reference Manual for more information
about the various connection attributes.

Note that setAttributesAsPassword , which is available for the embedded
DataSource, is not available for the client DataSource.

Network client security
The Derby Network Client allows you to select a security mechanism by specifying a value for the securityMechanism property.