Java is a computer programming language and is a core component of Sun Microsystems' Java platform and has achieved a universality that delivers offshore Java development seamlessly. JDBC (Java Database Connectivity) is an API for Java programming language that defines how a client can access a database, which when you outsource Java development leads to a homogeneous interface among heterogeneous systems. Database Web Services enables application-to-application interaction over the Web regardless of platform, language, or data formats.
JDBC Features
JDBC contains methods for querying and updating a database. JDBC is oriented towards relational databases. JDBC API dynamically chooses the correct Java packages and registers them with the JDBC Driver; a JDBC Driver is used to create JDBC connections. These connections support methods for querying and reporting. Java developers can execute statements remotely when data sources are distributed due to offshore Java development. The connections can accept and run "creating" and "executing" commands, e.g., SQL's update commands like CREATE, INSERT, UPDATE, and DELETE. It can also execute query commands such as SELECT. An update statement is one that updates data in the database and returns a number that is the count of the number of rows affected. Query statements fetch rows of information from the database to the client. There can be any number of rows in the returned data. Data can be retrieved by attributes like a name or a column number. JDBC Drivers are client-side adapters that translate Java program requests to a language that the DBMS can understand and respond to - critical interface that makes it plausible to outsource Java development.
JDBC API can be used by a Java developer to design Java applications that access any kind of tabular data, e.g., data in an RDBMS by using 3 programming steps.
Architecture for Accessing a Database
2-Tier Architecture
Java app interfaces directly with the data source - a client-server configuration where the user's commands are directly processed by the data source and results are sent back to the user.
Source: docs.oracle.com
3-Tier Architecture
Java app interfaces with a middle tier, which sends the commands to the data source - makes it easy to control access, simplifies app deployment, and provides performance advantages.
Database Web Services features
Database Web Services allows seamless interaction between applications even though they have varying platforms, languages, or data formats. When you outsource Java development, the free interfacing between client and server apps becomes crucial. Database Web Services are standard mechanisms for easily accessing remote content and applications. Using stored procedures via standard Web Services protocols, a client app can query and retrieve information from a database repository, even remotely in case of offshore Java development. The non-dependency can work through heterogeneous, distributed, and non-connected environments. The core components like XML, SOAP, WSDL, and UDDI are used across the industry powering up enhanced offshore Java development. Web services are implemented in the middle tier application servers. Database Web Services works either by accessing database resources as a Web service or consuming external Web services from the database itself. Some salient features of Database Web Services are:
JDBC Features
JDBC contains methods for querying and updating a database. JDBC is oriented towards relational databases. JDBC API dynamically chooses the correct Java packages and registers them with the JDBC Driver; a JDBC Driver is used to create JDBC connections. These connections support methods for querying and reporting. Java developers can execute statements remotely when data sources are distributed due to offshore Java development. The connections can accept and run "creating" and "executing" commands, e.g., SQL's update commands like CREATE, INSERT, UPDATE, and DELETE. It can also execute query commands such as SELECT. An update statement is one that updates data in the database and returns a number that is the count of the number of rows affected. Query statements fetch rows of information from the database to the client. There can be any number of rows in the returned data. Data can be retrieved by attributes like a name or a column number. JDBC Drivers are client-side adapters that translate Java program requests to a language that the DBMS can understand and respond to - critical interface that makes it plausible to outsource Java development.
JDBC API can be used by a Java developer to design Java applications that access any kind of tabular data, e.g., data in an RDBMS by using 3 programming steps.
- Connecting to a data source, such as a database
- Sending update or query statements to the database
- Receiving and processing the information returned from the database
- JDBC API - provides access to data in a database via Java programming language; executes SQL commands, receives results, and updates changes; interfaces with multiple data sources in a heterogeneous and distributed architecture
- JDBC Driver Manager - defines objects which can connect Java apps to a JDBC Driver
- JDBC Test Suite - helps to determine that JDBC drivers will run the program
- JDBC-ODBC Bridge - provides JDBC access via ODBC Drivers
Architecture for Accessing a Database
2-Tier Architecture
Java app interfaces directly with the data source - a client-server configuration where the user's commands are directly processed by the data source and results are sent back to the user.
Source: docs.oracle.com
3-Tier Architecture
Java app interfaces with a middle tier, which sends the commands to the data source - makes it easy to control access, simplifies app deployment, and provides performance advantages.
Database Web Services features
Database Web Services allows seamless interaction between applications even though they have varying platforms, languages, or data formats. When you outsource Java development, the free interfacing between client and server apps becomes crucial. Database Web Services are standard mechanisms for easily accessing remote content and applications. Using stored procedures via standard Web Services protocols, a client app can query and retrieve information from a database repository, even remotely in case of offshore Java development. The non-dependency can work through heterogeneous, distributed, and non-connected environments. The core components like XML, SOAP, WSDL, and UDDI are used across the industry powering up enhanced offshore Java development. Web services are implemented in the middle tier application servers. Database Web Services works either by accessing database resources as a Web service or consuming external Web services from the database itself. Some salient features of Database Web Services are:
- Enhanced PL/SQL
- Java-in-the-database
- SQL Query
- DML
internetworld2011.blogspot.com
ReplyDelete