94 lines
6.2 KiB
HTML
94 lines
6.2 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="concept" />
|
||
|
|
<meta name="DC.Title" content="Get started with JDBC" />
|
||
|
|
<meta name="abstract" content="The Java Database Connectivity (JDBC) driver shipped with the Developer Kit for Java is called the Developer Kit for Java JDBC driver. This driver is also commonly known as the native JDBC driver." />
|
||
|
|
<meta name="description" content="The Java Database Connectivity (JDBC) driver shipped with the Developer Kit for Java is called the Developer Kit for Java JDBC driver. This driver is also commonly known as the native JDBC driver." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jdbc.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jdbctydr.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jdbcreqs.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jdbctutr.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="dasrjndi.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="jdbcgets" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>Get started with JDBC</title>
|
||
|
|
</head>
|
||
|
|
<body id="jdbcgets"><a name="jdbcgets"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Get started with JDBC</h1>
|
||
|
|
<div><p>The Java™ Database Connectivity (JDBC) driver shipped with
|
||
|
|
the Developer Kit for Java is called the Developer Kit for Java JDBC
|
||
|
|
driver. This driver is also commonly known as the native JDBC driver.</p>
|
||
|
|
<p>To select which JDBC driver suits your needs, consider the following suggestions:</p>
|
||
|
|
<ul><li>Programs running directly on a server where the database resides should
|
||
|
|
use the native JDBC driver for performance. This includes most servlet and
|
||
|
|
JavaServer Pages (JSP) solutions, and applications written to run locally
|
||
|
|
on an iSeries™ server.</li>
|
||
|
|
<li>Programs that must connect to a remote iSeries server use the <a href="../rzahh/jdbc.htm" target="_blank">IBM<sup>®</sup> Toolbox for Java JDBC
|
||
|
|
driver</a>. The IBM Toolbox for Java JDBC driver is a robust implementation
|
||
|
|
of JDBC and is provided as part of IBM Toolbox for Java. Being pure Java, the IBM Toolbox for Java JDBC driver is trivial to set up for
|
||
|
|
clients and requires little server setup.</li>
|
||
|
|
<li>Programs that run on an iSeries server and need to connect to a remote, non-iSeries
|
||
|
|
database use the native JDBC driver and set up a Distributed
|
||
|
|
Relational Database Architecture™ (DRDA<sup>®</sup>) connection to that remote server.</li>
|
||
|
|
</ul>
|
||
|
|
<p> To get started with JDBC, see the following: </p>
|
||
|
|
<blockquote> <p><strong><a href="jdbctydr.htm">Types of JDBC drivers</a></strong> This
|
||
|
|
topic defines the JDBC driver types. Driver types are defined to categorize
|
||
|
|
the technology used to connect to the database.</p>
|
||
|
|
<p><strong><a href="jdbcreqs.htm">Requirements</a></strong>
|
||
|
|
This topic indicates the requirements you need to access the following:</p>
|
||
|
|
<ul><li>Core JDBC</li>
|
||
|
|
<li>JDBC 2.0 optional package</li>
|
||
|
|
<li>Java Transaction
|
||
|
|
API (JTA)</li>
|
||
|
|
</ul>
|
||
|
|
<p><strong><a href="jdbctutr.htm">JDBC tutorial</a></strong> This is
|
||
|
|
an important first step towards writing a JDBC program and having it run on
|
||
|
|
an iSeries server
|
||
|
|
with the native JDBC driver.</p>
|
||
|
|
</blockquote>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="jdbctydr.htm">Types of JDBC drivers</a></strong><br />
|
||
|
|
This topic defines the Java Database Connectivity (JDBC) driver
|
||
|
|
types. Driver types are used to categorize the technology used to connect
|
||
|
|
to the database. A JDBC driver vendor uses these types to describe how their
|
||
|
|
product operates. Some JDBC driver types are better suited for some applications
|
||
|
|
than others.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="jdbcreqs.htm">JDBC requirements</a></strong><br />
|
||
|
|
Before you write and deploy your JDBC applications, you may need to include specific jar files in your classpath.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="jdbctutr.htm">JDBC tutorial</a></strong><br />
|
||
|
|
The following is a tutorial on writing a Java Database
|
||
|
|
Connectivity (JDBC) program and having it run on the an iSeries server
|
||
|
|
with the native JDBC driver. It is designed to show you the basic steps required
|
||
|
|
for your program to run JDBC.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="dasrjndi.htm">Use JNDI for the examples</a></strong><br />
|
||
|
|
DataSources work hand-in-hand with the Java Naming and Directory Interface (JNDI).
|
||
|
|
JNDI is a Java abstraction layer for directory services just as Java Database
|
||
|
|
Connectivity (JDBC) is an abstraction layer for databases.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="jdbc.htm" title="The IBM Developer Kit for Java JDBC driver, also known as the "native" driver, provides programmatic access to iSeries database files. Using the Java Database Connectivity (JDBC) API, applications written in the Java language can access JDBC database functions with embedded Structured Query Language (SQL), run SQL statements, retrieve results, and propagate changes back to the database. The JDBC API can also be used to interact with multiple data sources in a distributed, heterogeneous environment.">Access your iSeries database with the IBM Developer Kit for Java JDBC driver</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|