Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Object Oriented Programming Articles
Page 557 of 589
Explain Single and multi-tire architectures of ODBC?
Generally, ODBC architecture is of two types single-tier and multi-tier.Single-tier architectureThis is an ODBC architecture which involves single-tier ODBC drivers. In singletier ODBC architecture, the ODBC driver receives ODBC requests/calls from the application and directly interacts with database files. It passes the SQL commands corresponding to the received calls and retrieves the results.Example: Microsoft AccessMultiple-tier architectureThis is an ODBC architecture which involves multiple-tier ODBC drivers. This is a common architecture and is based on client server communication.Client: The application that makes ODBC requests, the driver and the DriverManager together considered as a client.Server: The database and the database software (that ...
Read MoreWhat are the disadvantages of ODBC drivers?
Beside its advantages, ODBC has several drawbacks. Following are the main drawbacks of ODBC.Keeps on changing: ODBC is provided by Microsoft and like other Microsoft products it keeps evolving and the companies using ODBC should keep up with it. In addition to this, you need to pay to use ODBC SDK 8 and later versions.Usage of JNI libraries: Though ODBC solves vendor dependency problems by providing common API to interact with all the databases, at the end of the day ODBC is also a native API therefore, you need to use JNI in your Java applications which is not suggestable.Uncertain: ...
Read MoreWhat are the main features of JDBC?
Following are the new features of JDBC:Makes JDBC calls: While using JDBC Java applications can make JDBC calls these calls submit SQL statements to the driver which in turn accesses the data from the database.Portability: JDBC provides wide level portability.Using JDBC you can request any type of queries from the database.You can use JDBC with different Java applications such like Java Applets, Java Servlets, Java Server Pages (JSPs). Enterprise JavaBeans (EJBs). To communicate with database.JDBC provides support for advanced datatypes such as BLOB, CLOB etc.Using JDBC you can set save points for database and layer you can rollback to desired ...
Read MoreExplain the architecture of JDBC?
If you want to develop a Java application that communicates with a database, you should use JDBC API. A driver is the implementation of the said API; various vendors provide various drivers, you need to use a suitable driver with respect to the database you need to communicate with. The driver manager loads the driver and manages the driver.Following are the components of JDBC:JDBC DriverManager: The DriverManager class of the java.sql package manages different types of JDBC drivers. This class loads the driver classes. In addition to this whenever a new connection establishes it chooses and loads the suitable driver ...
Read MoreHow many types of JDBC Drivers are there?
There are 4 types of JDBC drivers namely, Type-1, Type-2, Type-3 and, Type-4.Type1 It is the ODBC − JDBC bridge driver, it acts as a bridge between JDBC and, ODBC database connectivity mechanism. Using this you can access the databases which support only ODBC. Initially, it is used extensively, since most of the databases supported only ODBC.Whenever Java application sends a request to the JDBC-ODBC bridge driver the request internally calls the ODBC equivalent function and the ODBC driver retrieves the result from the underlying database and sends it back to the JDBC-ODBC bridge driver.Advantages of type1 driverFollowing are the advantages ...
Read MoreWhat is type3 driver of JDBC what are the advantages and disadvantages of it?
In a Type 3 driver, a three-tier approach is used to access databases. The JDBC clients use standard network sockets to communicate with a middleware application server. The socket information is then translated by the middleware application server into the call format required by the DBMS, and forwarded to the database server.This kind of driver is extremely flexible, since it requires no code installed on the client, a single driver can actually provide access to multiple databases. You can think of the application server as a JDBC "proxy, " meaning that it makes calls for the client application. As a ...
Read MoreWhat are the main classes and interfaces of JDBC?
JDBC API is available in two packages java.sql, core API and javax.sql JDBC optional packages. Following are the important classes and interfaces of JDBC.Class/interfaceDescriptionDriverManagerThis class manages the JDBC drivers. You need to register your drivers to this.It provides methods such as registerDriver() and getConnection().DriverThis interface is the Base interface for every driver class i.e. If you want to create a JDBC Driver of your own you need to implement this interface. If you load a Driver class (implementation of this interface), it will create an instance of itself and register with the driver manager.StatementThis interface represents a static SQL statement. ...
Read MoreWhat are the types of statements in JDBC?
There are three types of statements in JDBC namely, Statement, Prepared Statement, Callable statement.StatementThe Statement interface represents the static SQL statement. It helps you to create a general purpose SQL statements using Java.Creating a statementYou can create an object of this interface using the createStatement() method of the Connection interface.Create a statement by invoking the createStatement() method as shown below.Statement stmt = null; try { stmt = conn.createStatement( ); . . . } catch (SQLException e) { . . . } finally { . . . }Executing the ...
Read MoreWhat are bind variables? How to execute a query with bind variables using JDBC?
A bind variable is an SQL statement with a temporary variable as place holders which are later replaced with appropriate values. For example, if you have a table named employee in the database created as shown below:+---------+--------+----------------+ | Name | Salary | Location | +---------+--------+----------------+ | Amit | 30000 | Hyderabad | | Kalyan | 40000 | Vishakhapatnam | | Renuka | 50000 | Delhi | | Archana | ...
Read MoreWhat are advantages of using JSP?
Following table lists out the other advantages of using JSP over other technologies −vs. Active Server Pages (ASP)The advantages of JSP are twofold. First, the dynamic part is written in Java, not Visual Basic or other MS specific language, so it is more powerful and easier to use. Second, it is portable to other operating systems and non-Microsoft Web servers.vs. Pure ServletsIt is more convenient to write (and to modify!) regular HTML than to have plenty of println statements that generate the HTML.vs. Server-Side Includes (SSI)SSI is really only intended for simple inclusions, not for "real" programs that use form ...
Read More