SearchOracle.com Definitions (Powered by WhatIs.com)
Java Database Connectivity
definition -
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.
Learn more about Java / J2EE
-
Eight key Oracle developer tools
Article - Consultant Sridhar Bogelli provides a refresher on some of the key tools that developers use to customize Oracle E-Business Suite applications. -
Java and the Empowered Database
Article - This article by Norbert Ehreke proposes an approach where the modeling is done in the relational tier and as much business logic as possible is handled within the database by employing a set of... -
Oracle Java application performance, part 1: Creating dynamic strings
Tip - Tips about using dynamic strings in Oracle and how they can improve Java application performance. -
Oracle Java application performance, part 2: JDBC driver comparisons
Tip - A comparison of the performance of OCI and thin drivers. -
Unable to view Oracle tables in NetBeans
Ask the Expert - I am very new to databases (Oracle 9.2 installed) and my problem is I'm not able to view tables in NetBeans 5.5 even after establishing the connection with the database via NetBeans. -
Can I make a second connection to Oracle without losing the first?
Ask the Expert - Is it possible to have a stored procedure make a second connection to Oracle without losing where you're at in the first connection? -
Impact of Oracle 9i upgrade on Java front end
Ask the Expert - I am using Java as the front end, so what is the impact of the upgrade? Do I need to upgrade Java versions or ODBC Drivers? -
Why isn't Oracle user-friendly?
Ask the Expert - Working with SQL Server is simple. Oracle is an enterprise database and powerful but why has it never been user-friendly? -
Web Services 101 for DBAs and data architects
Tip - Web services promise simplified interfaces for application-to-application interaction. This chapter describes the key technologies that enable them (such as XML, WSDL, SOAP and UDDI) and then peeks...
CONTRIBUTORS:Susan Adams, Tory Jackson, and Patrick Lok
last updated25 Oct 1999
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.comMore resources from around the web:
Oracle White Papers: Fusion Middleware