Calling a Data Source in an Application

Applications can call an OpenAccess SDK JDBC data source using a logical name to retrieve the javax.sql.DataSource object. This object loads the driver and can be used to establish a connection to the database.

Once the data source has been registered with JNDI, it can be used by your JDBC application as shown in the following example:

Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("EmployeeDB");
Connection con = ds.getConnection("scott", "tiger");

In this example, the JNDI environment is first initialized. Next, the initial naming context is used to find the logical name of the data source (EmployeeDB). The Context.lookup() method returns a reference to a Java object, which is narrowed to a javax.sql.DataSource object. Finally, the DataSource.getConnection() method is called to establish a connection with the database.

See Creating and Managing JDBC Data Sources for information about example data sources shipped with the JDBC Client that you can use as a template for creating your own data sources.