ODBC using Apache Derby
Not what you're looking for?
The purpose of this 3 page paper is to discuss Open Database Connectivity (ODBC) using Apache Derby Including strengths and weaknesses Open Database Connectivity (ODBC) is one of the most popular ways today to code a database application.
Embedded SQL applications tend to lack interoperatiliby. Applications might have to modified to work with other RDBMS ODBC applications do not require the explicit declaration and use of host
variables.
Purchase this Solution
Solution Summary
This paper describes Open Database Connectivity using Apache Derby, including the strengths and weaknesses of using Open Database Connectivity.
Solution Preview
Problem
The purpose of this 3 page paper is to discuss Open Database Connectivity
(ODBC) using Apache Derby Including strengths and weaknesses
Solution:
The ODBC support for Apache Derby or IBM Cloudscape is made possible with the DB2 Runtime Client. Distributed relation database architecture (DRDA) is the common protocol used for communication between the client and the server, and is provided by the Runtime Client (Ibm.com, n.d).
IBM had made its Cloudscape database, and is also known as Apache Derby. The current version of IBM Cloudscape 10.1 is Apache Derby 10.1. IBM had done this not just with the intent of promoting Open Source code, but also in order to promote standards based application development.
ODBC using Apache Derby: Strengths
a) Support for .Net and Java:
Apache Derby provides support for Java as well as the .Net platform, which will ultimately give it an edge in the future, although there are several other databases providing this facility, this is the one that is ultimately going to make the difference.
Apache Derby has the support for Java, which in turn allows it to connect to use ODBC through JDBC. Apart from ...
Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Javscript Basics
Quiz on basics of javascript programming language.