What is JDBC and JNDI?

Table of Contents

JDBC is Java Database Connectivity API, while JNDI is Java Naming and Directory Interface API. The main thing here is that in a JNDI directory you’re actually storing a JDBC DataSource, so, you’re simply using JDBC to obtain a Connection via JNDI lookup.

What is JNDI name?

A JNDI name is a user-friendly name for an object. These names are bound to their objects by the naming and directory service that is provided by a J2SE server. Because J2SE components access this service through the JNDI API, an object’s user-friendly name is its JNDI name.

What is a JNDI connection?

A JNDI DataSource object is a file that contains the configuration details necessary to connect to a database. The DataSource object must be registered on a JNDI server, where it is identified using a JNDI name. You can register your DataSource object directly on your application server via its JNDI service.

What is JNDI DataSource?

What is a JNDI string?

It is an API to providing access to a directory service, that is, a service mapping name (strings) with objects, reference to remote objects or simple data. This is called binding. The set of bindings is called the context. Applications use the JNDI interface to access resources.

What JDBC means?

Java™ EE Database Connectivity
JDBC stands for Java™ EE Database Connectivity. In Java EE development, this is a well known and commonly used technology for implementing database interaction. JDBC is a call-level API, meaning that SQL statements are passed as strings to the API, which then takes care of executing them on the RDMS.

What is a JNDI DataSource?

What is JNDI name example?

A name that is bound within a context is the JNDI name of the object. In Specifying a Resource Reference, for example, the JNDI name for the JDBC resource (or data source) is jdbc/ejbTutorialDB .

How does JDBC work?

The JDBC API is implemented through the JDBC driver. The JDBC Driver is a set of classes that implement the JDBC interfaces to process JDBC calls and return result sets to a Java application. The database (or data store) stores the data retrieved by the application using the JDBC Driver.

How incorporate JDBC write steps with example?

Fundamental Steps in JDBC

Import JDBC packages.
Load and register the JDBC driver.
Open a connection to the database.
Create a statement object to perform a query.
Execute the statement object and return a query resultset.
Process the resultset.
Close the resultset and statement objects.
Close the connection.

How do you write a JDBC program in Java?

A JDBC program comprises the following FIVE steps:

STEP 1: Allocate a Connection object, for connecting to the database server.
STEP 2: Allocate a Statement object, under the Connection created earlier, for holding a SQL command.
STEP 3: Write a SQL query and execute the query, via the Statement and Connection created.

How do I access a JDBC connection pool using JNDI?

Using JNDI, a web application can access a JDBC connection pool by looking up the jdbc-resource that configures it. The jdbc-resources can access the name in its web descriptor. The following web descriptors example refer to the connection pool created in the earlier example.

What is the JNDI name of the JDBC- resources configuration?

WEB-INF/web.xml WEB-INF/sun-web.xml In the above example, jdbc/myJdbc is the name by which the pool is referenced in the web application and jdbc/MyPool is the JNDI name of the jdbc-resources configuration. The following is an example for using the pool in a web application.

Why use a JNDI connection?

I find that the reason for using a JNDI connection is typically less technical than organizational. Specifying resources this way can also be useful if you want to let the target app use the same configuration between development/QA/environments, although given the way that Dodeca organizes connections, it isn’t an issue.

How to create a new database using JDBC application?

The following steps are required to create a new Database using JDBC application − Import the packages − Requires that you include the packages containing the JDBC classes needed for database programming.