THE WHATIS.COM WORD-OF-THE-DAY June 12, 2002 Java Database Connectivity ______________ TODAY'S SPONSOR: The .tv Corporation
Save 30% on Web addresses! Not only will you get a great deal on your Web addresses, but you'll also get superior customer service, innovative products and services and a place that is easy to register and manage your Web addresses. Great names are still available. Register the names you want before someone else does! Check it out now: http://WhatIs.com/r/0,,3883,00.htm?the.tvcorporation ______________ TODAY'S WORD: Java Database Connectivity See our definition with hyperlinks at http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214050,00.html Java Database Connectivity (JDBC) is an application program interface (API) specification for connecting programs written in Java to the data in popular databases. The application program interface lets you encode access request statements in Structured Query Language (SQL) that are then passed to the program that manages the database. It returns the results through a similar interface. JDBC is very similar to the SQL Access Group's Open Database Connectivity (ODBC) and, with a small "bridge" program, you can use the JDBC interface to access databases through the ODBC interface. For example, you could write a program designed to access many popular database products on a number of operating system platforms. When accessing a database on a PC running Microsoft's Windows 2000 and, for example, a Microsoft Access database, your program with JDBC statements would be able to access the Microsoft Access database. JDBC actually has two levels of interface. In addition to the main interface, there is also an API from a JDBC "manager" that in turn communicates with individual database product "drivers," the JDBC-ODBC bridge if necessary, and a JDBC network driver when the Java program is running in a network environment (that is, accessing a remote database). When accessing a remote database, JDBC takes advantage of the Internet's file addressing scheme and a file name looks much like a Web page address (or Uniform Resource Locator). For example, a Java SQL statement might identify the database as: jdbc:odbc://www.somecompany.com:400/databasefile JDBC specifies a set of object-oriented classes for the programmer to use in building SQL requests. An additional set of classes describes the JDBC driver API. The most common SQL data types, mapped to Java data types, are supported. The API provides for implementation-specific support for Microsoft Transaction Server requests and the ability to commit or roll back to the beginning of a transaction. RELATED TERMS: application program interface http://searchwin2000.techtarget.com/sDefinition/0,,sid1_gci213778,00.html Java http://searchsolaris.techtarget.com/sDefinition/0,,sid12_gci212415,00.html database http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci211895,00.html Structured Query Language http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214230,00.html Open Database Connectivity http://searchvb.techtarget.com/sDefinition/0,,sid8_gci214133,00.html driver http://searchstorage.techtarget.com/sDefinition/0,,sid5_gci212002,00.html Uniform Resource Locator http://searchnetworking.techtarget.com/sDefinition/0,,sid7_gci213251,00.html object-oriented http://searchwin2000.techtarget.com/sDefinition/0,,sid1_gci212681,00.html class http://searchvb.techtarget.com/sDefinition/0,,sid8_gci211790,00.html data type http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci211903,00.html Microsoft Transaction Server http://searchwin2000.techtarget.com/sDefinition/0,,sid1_gci213747,00.html ______________________ SELECTED LINKS: Rawn Shah's "Integrating Databases with Java via JDBC" on the JavaWorld Web site offers an overview. http://www.javaworld.com/javaworld/jw-05-1996/jw-05-shah.html Sun Microsystems' JDBC Database Access API will lead you to a FAQ and free software. http://java.sun.com/products/jdbc Search400.com has hundreds of links related to Java Database Connectivity. http://www.search400.com/ SearchDatabase.com offers hundreds of technical resources covering JDBC and other key industry technologies. http://searchdatabase.techtarget.com/bestWebLinks/0,,sid13_tax281601,00.html ______________________ WHATIS DISCUSSION FORUM | Challenge #2 THE SCENARIO: Company Beta held a meeting to inform employees that they would begin monitoring employee e-mail. Management says it's their duty to prevent improper use of e-mail. Employees are concerned that monitoring e-mail will change the culture of the company. Who's right? You be the judge! http://whatis.discussions.techtarget.com/WebX?[EMAIL PROTECTED]^5@.1dcf9e64/63!viewtype= ______________________ QUIZ #27 | Security awareness for end users Studies show that a company's biggest security threat is its own employees. The SANS Institute recommends that organizations should take time to educate their employees about computer security and periodically test employees to make sure they understand the basics. To help you in your efforts to raise security awareness in your organization, we've created the following quiz: http://searchsecurity.techtarget.com/sDefinition/0,,sid14_gci826572,00.html _________________________________________________________ LESS THAN 2 WEEKS UNTIL OUR FREE SECURITY DECISIONS EVENT Time's running out to attend Security Decisions June 19-21 at the Hilton Chicago Hotel. There are still seats left but you should act now or risk being shut out. FREE attendance available at: http://www.securityconf.com/html/registration.htm Benefit from top strategies to make the most cost-effective security purchases, expert tactics to close specific security holes in your system, and the most effective ways to manage network security (without breaking the bank). Apply today! ______________________________ RECENT ADDITIONS AND UPDATES [1] subset symbol http://whatis.techtarget.com/definition/0,,sid9_gci831748,00.html [2] gap analysis http://whatis.techtarget.com/definition/0,,sid9_gci831294,00.html [3] XSD http://searchwebservices.techtarget.com/sDefinition/0,,sid26_gci831325,00.html [4] PersonalJava http://searchsolaris.techtarget.com/sDefinition/0,,sid12_gci831420,00.html [5] Resilient Packet Ring http://searchnetworking.techtarget.com/sDefinition/0,,sid7_gci754865,00.html ____________________________________________________________________ ::::::::::::::::::: WHATIS.COM CONTACTS ::::::::::::::::::: LOWELL THING, Site Editor ([EMAIL PROTECTED]) ____________________________________________________________________ MARGARET ROUSE, Assistant Editor ([EMAIL PROTECTED]) ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, All Rights Reserved. If you would like to sponsor this or any techtarget newsletter, please contact Gabrielle DeRussy at [EMAIL PROTECTED] Unsubscribe from 'Word of the Day' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://WhatIs.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
