Configuring JDBC Resources

A JDBC Datasource is a Java EE resource that you can create and manage using Web Server.

The JDBC API is the API for connectivity with relational database systems. The JDBC API has two parts:

• An application-level interface used by the application components to access databases.

• A service provider interface to attach a JDBC driver to the Java EE platform.

A JDBC Datasource object is an implementation of a data source in the Java programming language. In basic terms, a data source is a facility for storing data. It can be as sophisticated as a complex database for a large corporation or as simple as a file with rows and columns. A JDBC datasource is a Java EE resource that can be created and managed through Web Server.

The JDBC API provides a set of classes for Java with a standard SQL database access interface to ensure uniform access to a wide range of relational databases.

Using JDBC, SQL statements can be sent to virtually any database management system (DBMS). It is used as an interface for both relational and object DBMSs.

Adding a JDBC Resource

To add a JDBC resource through CLI, execute the following command.

wadm> create-jdbc-resource --user=admin --password-file=admin.pwd --host=serverhost
--port=8989 --config=config1 --datasource-class=oracle.jdbc.pool.OracleDataSource jdbc

See CLI Reference, create-jdbc-resource(1).

In the previous example, com.pointbase.jdbc.jdbcDataSource represents the JDBC driver class.

For a list of supported JDBC drivers, see JDBC Drivers Known to Work With Web Server.