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
Select Business Solutions, a Provider of Mainframe Reporting and Data Access ... PR Web (press release) Highlights of this new release are enhancements or changes to the VSAM Interface, IMS Interface, JDBC Interface, Java Interface and the Copybook facility. Select Business Solutions is pleased to announce the release of a new version of Nomad for z/OS. 3 Feb 2012 at 9:53am
Using the Tomcat 7 JDBC Connection Pool in Production TheServerSide.com One of the new features with Apache Tomcat 7 is the JDBC Connection Pool which is offered as a replacement to the commons-dbcp connection pool that is tailored to better serve highly concurrent (multi-core / multi-cpu) environments. 31 Jan 2012 at 9:04am
Koenig Now Offers Training on Advanced Java SBWire (press release) This Koenig course covers advanced user-interface programming and the enterprise features of the Java SE platform. It aims at introducing the advanced features of Java SE by including new sections on JAXP, JDBC 4, Java Networking, and many other Java ... and more » 3 Feb 2012 at 9:41am
Apache Shiro: Java security framework Help Net Security Authentication - Support logins across one or more pluggable data sources (LDAP, JDBC, ActiveDirectory, etc). Authorization - Perform access control based on roles or fine-grained permissions, also using pluggable data sources. 31 Jan 2012 at 3:31am
ZK with Non-relational Database mongoDB TheServerSide.com Typically, for relational databases developers either use plain JDBC or some sophisticated object-relational mapping library like Hibernate. This series of small talk will show how developers can develop non-relational database driven ZK applications. 26 Jan 2012 at 1:42pm
Database Programming with JDBC and Java by George Reese Description: Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not. This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to mainta...
JDBC: Practical Guide for Java Programmers (The Practical Guides) by Gregory D. Speegle Description: JDBC: Practical Guide for Java Programmers is the quickest way to gain the skills required for connecting your Java application to a SQL database. Practical, tutorial-based coverage keeps you focused on the essential tasks and techniques, and incisive explanations cement your understanding of the API features you'll use again and again. No other resource presents so concisely or s...
CodeNotes for J2EE: EJB, JDBC, JSP and Servlets by Gregory Brill Description: CodeNotes provides the most succinct, accurate, and speedy way for a developer to ramp up on a new technology or language. Unlike other programming books, CodeNotes drills down to the core aspects of a technology, focusing on the key elements needed in order to understand it quickly and implement it immediately. It is a unique resource for developers, filling the gap between compre...
