skip to main content
Using the JDBC Client : Configuring JDBC Data Sources : Calling a Data Source in an Application
 

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.