JDBC solution (Turn)

Resolving JDBC Solutions


The rise and development of Java has accelerated the development of Internet and intranet applications. More and more businesses are using Java languages that are not platform-limited to develop complex business
Critical tasks.

As the founder of the Java language, JavaSoft company has long foreseen that the market needs a data access technology for Java, and has long been working with Merant company to develop
Java JDBC Technology as a standard for Java Database Connectivity technology.

Four types of JDBC solutions
JDBC is a common SQL (Structured Query Language) database access framework with a simple and powerful application interface (API). Using JDBC Api,java to develop
People can encode in a single standardized function library to generate a Java application system that is independent of the database management system (DBMS).
JDBC defines the SQL invocation level interface (call levels INTERFACE,CLI) as the standard of the X/open organization. The purpose of the X/open organization is to provide an open system based
Data access standards to achieve mutual compatibility. JDBC is the use of a single standardized interface to access a variety of data sources, to achieve interoperability between application systems.

JavaSoft the JDBC driver into four major categories, namely Jdbc/odbc Bridge, Nativeapi Partlyjava, Netprotocol All
Java and native Protocol Alljava.

Jdbc/odbc Bridge is a thin compilation component that converts JDBC feature calls to ODBC feature calls. Use JDBC/ODBC Bridge,java developer to edit
Write compatible JDBC Application systems and small applications that can be used in conjunction with any ODBC connectivity solution currently on the market.

The Nativeapi Partlyjava driver converts the JDBC call to the client API for the specified dedicated database system, thereby leveraging the sql*net, I
Connect and Openclient are connected to Oracle, Informix, and Sybase databases, respectively. The biggest advantage of using the Partlyjava driver is that you can
Leverage existing database middleware in the enterprise.

The Netprotocol Alljava driver converts a JDBC call into a network protocol that is not restricted by any database, and the server can compile the network protocol
For the database protocol. This JDBC solution has a single, Universal, Java-only driver that can connect many different databases. What kind of network protocol to take as
Mediation, depending on the JDBC driver provider.

The Nativeprotocol Alljava driver is a database-specific JDBC driver that converts a JDBC call into a network protocol that the database can use directly.
The client therefore has direct access to the database server. Fundamentally, the Nativeprotocol Alljava driver can be a purely local Java JDBC
Client, fully replace the client API, such as Sql*net, Iconnect, and Openclient.

Implementing JDBC drivers in different environments
The industry has many options to establish a JDBC connection. Choosing a JDBC solution should primarily consider the structural characteristics of the Java program you are using.
The biggest advantage of Java is that it is not subject to the common features of platform constraints, if you choose an execution solution that contains non-Java components, or choose a specific database type of execution scenario,
Can seriously affect versatility.

In the process of selection, both Short-and long-term goals should be taken into account. For users looking for near-term goals, if the selection criteria involves C and C + + languages, then you must
When considering the API or other proprietary technologies of a particular database vendor, the Netprotocol Alljava solution may be a relatively reliable strategy that helps
To fully implement data connections across the network.