94 lines
6.4 KiB
HTML
94 lines
6.4 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="reference" />
|
||
|
|
<meta name="DC.Title" content="JDBC" />
|
||
|
|
<meta name="abstract" content="JDBC is an application programming interface (API) included in the Java platform that enables Java programs to connect to a wide range of databases." />
|
||
|
|
<meta name="description" content="JDBC is an application programming interface (API) included in the Java platform that enables Java programs to connect to a wide range of databases." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="page1.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jdbcenhancev5r4.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jdbcenhance.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzahhjdbcenhancev5r2.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jdbcproperties.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sqltypes.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="jdbc2" />
|
||
|
|
<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>JDBC</title>
|
||
|
|
</head>
|
||
|
|
<body id="jdbc2"><a name="jdbc2"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">JDBC</h1>
|
||
|
|
<div><p>JDBC is an application programming interface (API) included in
|
||
|
|
the Java™ platform
|
||
|
|
that enables Java programs to connect to a wide range of databases.</p>
|
||
|
|
<div class="section"><p>The IBM<sup>®</sup> Toolbox
|
||
|
|
for Java JDBC
|
||
|
|
driver allows you to use JDBC API interfaces to issue structured query language
|
||
|
|
(SQL) statements to and process results from databases on the server. You
|
||
|
|
can also use <a href="../rzaha/jdbc.htm">IBM Developer
|
||
|
|
Kit for Java JDBC driver</a>, called the 'native' JDBC driver:</p>
|
||
|
|
<ul><li> Use the IBM Toolbox
|
||
|
|
JDBC driver when the Java program is on one system and the database
|
||
|
|
files are on another system, as in a client/server environment</li>
|
||
|
|
<li>Use the native JDBC driver when both the Java program and database files are on the
|
||
|
|
same iSeries™ server</li>
|
||
|
|
</ul>
|
||
|
|
<p>For more information about IBM Toolbox for Java JDBC classes and examples, ongoing
|
||
|
|
improvements, JDBC properties, and unsupported SQL types, see the following
|
||
|
|
pages:</p>
|
||
|
|
<blockquote><a href="jdbc.htm">JDBC classes</a></blockquote>
|
||
|
|
<blockquote><a href="jdbcenhance.htm#jdbcenhance">Enhancements to JDBC support for Version 5 Release 3</a></blockquote>
|
||
|
|
<blockquote><span class="synph" id="jdbc2__jdbcprop"><a name="jdbc2__jdbcprop"><!-- --></a><span class="kwd"></span></span><a href="jdbcproperties.htm#jdbcproperties">IBM Toolbox for Java JDBC properties</a></blockquote>
|
||
|
|
<blockquote><span class="synph" id="jdbc2__sqltypes.html"><a name="jdbc2__sqltypes.html"><!-- --></a><span class="kwd"></span></span><a href="sqltypes.htm#sqltypes">JDBC SQL Types</a></blockquote>
|
||
|
|
</div>
|
||
|
|
<div class="section"><h4 class="sectiontitle">Different versions of JDBC</h4><p>Different versions of
|
||
|
|
the JDBC API exist, and the IBM Toolbox for Java JDBC driver supports the following
|
||
|
|
versions:</p>
|
||
|
|
<ul><li>JDBC 1.2 API (the java.sql package) is included in the Java Platform
|
||
|
|
1.1 core API and JDK 1.1.</li>
|
||
|
|
<li>JDBC 2.1 core API (the java.sql package) is included in both the Java 2
|
||
|
|
Platform, Standard Edition (J2SE) and the Java 2 Platform Enterprise Edition (J2EE).</li>
|
||
|
|
<li>JDBC 2.0 Optional Package API (the javax.sql package) is included in J2EE
|
||
|
|
and is available as a <a href="http://java.sun.com/products/jdbc/index.html" target="_blank">separate download from Sun</a>. These extensions were
|
||
|
|
formerly named the JDBC 2.0 Standard Extension API.</li>
|
||
|
|
<li>JDBC 3.0 API (the java.sql and javax.sql packages) is included in J2SE,
|
||
|
|
Version 1.4.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="jdbcenhancev5r4.htm">Enhancements to IBM Toolbox for Java JDBC support for V5R4</a></strong><br />
|
||
|
|
Several JDBC functions were enhanced for i5/OS™ Version 5 Release 4.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="jdbcenhance.htm">Enhancements to JDBC support for Version 5 Release 3</a></strong><br />
|
||
|
|
Several JDBC functions were enhanced for i5/OS™ Version 5 Release 3.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzahhjdbcenhancev5r2.htm">Enhanced JDBC functions for i5/OS Version 5 Release 2</a></strong><br />
|
||
|
|
Several JDBC functions were enhanced for i5/OS™ Version 5 Release 2.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="jdbcproperties.htm">IBM Toolbox for Java JDBC properties</a></strong><br />
|
||
|
|
Many properties can be specified when connecting to a server database using JDBC. All properties are optional and can be specified either as part of the URL or in a java.util.Properties object. If a property is set in both the URL and a Properties object, the value in the URL will be used.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sqltypes.htm">JDBC SQL Types</a></strong><br />
|
||
|
|
Not all of the SQL types described by the JDBC specification are
|
||
|
|
supported by DB2<sup>®</sup> for i5/OS™. </li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="page1.htm" title="IBM Toolbox for Java is a set of Java classes that allow you to use Java programs to access data on your iSeries servers. You can use these classes to write client/server applications, applets, and servlets that work with data on your iSeries. You can also run Java applications that use the IBM Toolbox for Java classes on the iSeries Java virtual machine (JVM).">IBM Toolbox for Java</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|