Jdba

How JDBC works?
The applications access the database by making calls to the JDBC API.
The JDBC driver translates the application's JDBC calls into the protocol of the database server.
When it is finished accessing the database, the application closes the connection.
The application server returns the connection to the connection pool..
How to create JDBC URL?
4.
1serverName – the address of the server we'll connect to; this could be a domain name or IP address pointing to the server.2instanceName – the instance to connect to on serverName; it's an optional field, and the default instance will be chosen if the field isn't specified..
Is JDBC an API?
JDBC is an API(Application programming interface) used in java programming to interact with databases.
The classes and interfaces of JDBC allow the application to send requests made by users to the specified database..
SQLJ programs allow direct embedding of Java bind expressions within SQL statements.
JDBC requires separate get and/or set call statements for each bind variable and specifies the binding by position number.
SQLJ provides strong typing of query outputs and return parameters and allows type-checking on calls.

JDBC makes it possible to do establish a connection with a data source, send queries and update statements, and process the results.

How JDBC works?