JDBC

-



JDBC is a Java API for executing SOL statements. It consists of a set of classes and interfaces written in JAVA programming language. JDBC provides a standard API for tool/database developers and makes it possible to write database applications using a pure JAVA API. Basic JDBC interaction in its simplest form can be broken down into four steps:

1.  Open a connection to the database.
2.  Execute a SQL statement.
3.  Process the results.
4.  Close the connection to the database

Using JDBC API, it isn’t necessary to write one program to access a system database, another program to access an Oracle database, another program to access an Informix database and so on. One can write a single program using a JDBC API and the program will be able to send SQL statement to the appropriate database. And with an application returning JAVA programming language, one also doesn’t have to worry about writing different applications to run on different platforms. The combination of JAVA and JDBC lets programmers write it once it anywhere.

                 Microsoft’s ODBC API is probably the most widely used programming interface for accessing relational databases. It offers the ability to connect almost all databases on all platforms. So why not just use ODBC from JAVA?
         
The answer is that you can use ODBC from JAVA, but this is the best done with the help of JDBC in the form of the JDBC-ODBC bridge. The question now becomes,” Why do we need JDBC?” There are several answers to these questions:

1. ODBC is not appropriate for direct use from JAVA because it uses a C interface. Calls from JAVA to native C code have a number of drawbacks in the security, implementations, robustness and automatic portability of applications.
2. A literal transmission of ODBC C API into a JAVA API would not be desirable. For example, JAVA has no pointers and ODBC makes copies use of them, including the notoriously error-prone generic pointer “void”. You can think of JBBC as ODBC translated into an object oriented interface that is natural for JAVA programmers.

3. ODBC is hard to learn. It makes simple and advanced features together and it has complex options even for simple queries. JBBC on the other hand was design to keep simple thing while allowing more advanced capabilities where required.

4. A JAVA API like JDBC is needed in order to enable a “pure JAVA “solution. When ODBC is used, the ODBC driver manager and drivers must be manually installed on every client machine. When the JDBC driver i.e. written completely in JAVA. However JDBC code is automatically installable, portable and secure on all JAVA platforms from network computers to the mainframe.

Comments

Post a Comment

Popular posts from this blog

AUDIO SPOTLIGHTING

-
Image
INTRODUCTION n   Audio spot lighting is a very recent technology that creates focused beams of sound similar to light beams coming out of a flashlight. By ‘shining’ sound to one location, specific listeners can be targeted with sound without others nearby hearing it, ie to focus sound into a coherent and highly directional beam. It uses a combination of non-linear acoustics and some fancy mathematics. But it is real and is fine to knock the socks of any conventional loud speaker. n   The Audio Spotlight & Hyper Sonic Sound Technology (developed by American Technology Corporation), uses ultrasonic energy to create extremely narrow beams of sound that behave like beams of light. Audio spotlighting exploits the property of non-linearity of air. When inaudible ultrasound pulses are fired into the air, it spontaneously converts the inaudible ultrasound into audible sound tones, hence proved that as with water, sound propagation in air is just as non-linear, and can be calculated math
Read more

Electronic Reconnaissance, ELECTRONIC COUNTERMEASURES (ECM), ELECTRONIC COUNTER-COUNTERMEASURES (ECCM)

-
Electronic Reconnaissance: Reconnaissance aims to give to field players, at a tactical level, the information they need: Where are (and where will be) the targets, what are their defenses, what military means to use, what kind of weapon is the best suited, when to conduct the attack, etc. Due to short reaction time in Air Defense, this task is generally carried out directly by the AEW system. In fact in some cases the AEW platform is a C3I system itself that controls the fighters in real time. For ground targets, due to slower evolution of the situation and to a more complex environment (collateral damage avoidance, mask), a specific mission is needed. This mission uses SAR/MTI systems either fitted in POD carried by a manned aircraft (business jet or fighter), or carried by an unmanned vehicle (UAV). The main objective of these missions is to re-acquire the targets (in case they are moved as Ballistic Missile Launchers), and to identify and locate them accurately. Once again fusion
Read more

INTERFACING OF EEPROM with 8051

-
Image
7.1 Introduction As we know, ROM is a memory that does not lost its contents when the power is turned off. For this reason ROM is also called Non-Volatile Memory. There are different types of ROM such as PROM, EPROM, EEPROM, Flash EPROM and Mask ROM. In which PROM refers to the Kind of ROM that the user can burn information into. PROM is a user programmable memory. PROM is referred to as OTP (One time programmable). EPROM was invented to allow making changes in the contents of PROM after it is burned. In short, one can program the memory chip and erase it thousands of time. This is especially necessary during development of microcontroller based project. EEPROM is electrically erasable programmable ROM. EEPROM has several advantages over EPROM. EEPROM does not require external eraser and programming device. Flash EPROM has become a popular user programmable memory chip. The reason behind that is the eraser of entire content takes less than a second that why it is named Flash memory. Wh
Read more