Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

SQL etc

Posted Nov 23, 1998

Introduction to Databases for the Web: Pt 4

By Selena Sol

JDBC

To tell you the truth, if I were to recommend a backend architecture for a web-based database interface, I would probably recommend the CGI architecture we just discussed.

In my opinion and experience, CGI is still the most stable, cross-platform, easy to maintain method for managing such a mission critical application. Alternative technologies like CORBA, Java, Active-X, and Cold Fusion are too difficult, too proprietary, or too buggy.

Nevertheless, no discussion of Web Databases would be complete without a discussion of JDBC.

What is JDBC

JDBC is Java's version of the DBI module in Perl 5. It provides a standard interface between you and the database server.

As with DBI, JDBC provides a standard API which you can use regardless of what Database is being used in the backend. Also, just as DBI is supported by a host of DBD (Database Dependent) modules to connect DBI to the multitude of proprietary systems, JDBC is supported by a large set of JDBC drivers.

[JDBC Architecture]
Click for full size image

Fortunately, as in the case of DBI, the JDBC interface and most of the JDBC drivers you will need are installed by default so you already have them if you have installed the JDK. Drivers that are not installed by default can be downloaded by going to www.javasoft.com/products/jdbc/index.html.

This tutorial assumes that you are already familiar with Java programming. If you are not, you may want to read Intro to Web Programming.

Limitations of JDBC

Of course, if you have been keeping up with the news, you will know that Java is still somewhat buggy and slow. However, the language promises to be with us as a basic tool for many years to come.

And though it still is a bit painful to use Java in an internet setting in which one cannot control the browsers, operating systems, or hardware specs of the users, it can still be worthwhile for you to learn and play with it.

At very least, JDBC is extremely useful for server-side application development in which you can control the environment to a much greater degree.

So to conclude this tutorial on web databases, we will take a walk through JDBC technology and present an actual Java GUI that uses JDBC to connect to the datasource we installed for the CGI section.



SQL etc Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
SQL etc Forum
Topic By Replies Updated
MySQL rollback UAL225 0 August 21st, 09:56 PM
Complex Search Query Galway 0 May 20th, 10:04 PM
change collation at once supercain 2 May 15th, 06:18 AM
SQL Features, tools and utilities question Neomite 1 April 10th, 09:13 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date