You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram. To start, here are three criteria [...]
November 18, 2008
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good. The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There [...]
October 9, 2008
The Design Decomposition Blog is written by Doug Barry.
JDBC is a Java API for executing SQL statements¹. It consists of a set of
classes and interfaces written in Java. Although JDBC resembles Microsoft
Corporation's Open Database Connectivity (ODBC) API, JDBC provides a more
natural Java interface. It does, however, build on ODBC, so people familiar with
ODBC will find it easy to use JDBC. Both JDBC and ODBC are based on the X/Open
SQL CLI (Call Level Interface).
Using JDBC, SQL statements can be sent
to virtually any database management system (DBMS). It is used as an interface
for both relational and object DBMSs.
JDBC uses the call-level approach when using the Java programming language.
This is illustrated by the JDBC statements in this diagram.
An example of a JDBC statement that creates a new Person instance would be:
PreparedStatement insertPerson =
con.prepareStatement(
"INSERT INTO PERSON " +
"VALUES (?,?)");
If you also wanted to manipulate this new Person instance in the host
program, you would need Java code in addition to this code fragment that
populates the instance in Java along with the instance in the database. Also see transparent
persistence vs. JDBC call-level interface (new
window).
There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.
Search this site for more articles
Custom Search
Browse this site for more articles
Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current
article: JDBC.
Related recent articles from Google News
Download soapUI 3.6 Beta 2 / 3.5.1 / Free Soft Sailor (blog) Some of SoapUI new major features: Query Builder (Data Driven testing); AMF Testing (Protocol); JMS Testing (Protocol); JDBC Testing (Protocol); ... 30 Aug 2010 at 8:52am
Expert Oracle JDBC Programming by R.M. Menon Average Customer Review: based on 5 reviews. Customer Review: This book is about Oracle JDBC programming, not generic database neutral JDBC programming but Oracle specific. There are many JDBC books available and many Oracle and Oracle programming books but this concentrates narrowly on JDBC for Oracle, and how to get the best performance out of that combination. It is aimed at an audience that...
JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) by Seth White, Maydene Fisher, Rick Cattell, Graham Hamilton, Mark Hapner Average Customer Review: based on 22 reviews. Customer Review: JDBC is one of the most mature and widely used Java APIs. Even after the arrival of more recent tools and technologies like EJB's CMP and JDO, JDBC still remains a simple, fast, and reliable way of storing objects' state in an RDBMS. While conceptually this technology is quite straightforward, its evolution has made it more complex ...
JDBC Recipes: A Problem-Solution Approach by Mahmoud Parsian Average Customer Review: based on 4 reviews. Customer Review: I used some of the examples from this book (by cut-and-paste -- just chnaged the db URL, user/password) and they worked great. I needed to write some code for handling images and the BLOB code examples provided very good starting point. Thanks. Alex Hanif alex.hanif@yahoo.com
based on 5 reviews.
based on 22 reviews.
based on 4 reviews.