2.3 JDBC Driver Requirements

A JDBC driver is necessary for Java applications that have native JDBC support to access SQL Views. Java Database Connectivity (JDBC) is an API for the Java programming language that defines how a client can access a database. It provides methods for querying and updating data in a database.

Defining the JDBC access mode for Java applications involves installing derbyclient.jar to the target program’s classpath. Each database tool handles this differently. The class for the JDBC driver is: org.apache.derby.jdbc.ClientDriver.

The URL is:

jdbc:derby://host:port/database_name_and_credentials

A sample URL is:

jdbc:derby://localhost:1560/MOSQL;user=formula;password=formula;

For more information, consult your documentation for the JDBC drivers.