84 lines
5.5 KiB
HTML
84 lines
5.5 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="task" />
|
||
|
|
<meta name="DC.Title" content="Setting up your server to use SQLJ" />
|
||
|
|
<meta name="abstract" content="Before running a Java program that contains embedded SQLJ statements, ensure that you set up your server to support SQLJ. SQLJ support requires that you modify the CLASSPATH environment variable for your server." />
|
||
|
|
<meta name="description" content="Before running a Java program that contains embedded SQLJ statements, ensure that you set up your server to support SQLJ. SQLJ support requires that you modify the CLASSPATH environment variable for your server." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="classpth.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sqlj.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="instextn.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jsqlover.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="sqljsetup" />
|
||
|
|
<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>Setting up your server to use SQLJ</title>
|
||
|
|
</head>
|
||
|
|
<body id="sqljsetup"><a name="sqljsetup"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Setting up your server to use SQLJ</h1>
|
||
|
|
<div><p>Before running a Java™ program that contains embedded SQLJ
|
||
|
|
statements, ensure that you set up your server to support SQLJ. SQLJ support
|
||
|
|
requires that you modify the CLASSPATH environment variable for your server.</p>
|
||
|
|
<div class="section"><p> For more information about working with Java classpaths,
|
||
|
|
see the following page:</p>
|
||
|
|
<blockquote> <p><a href="classpth.htm">Java classpath</a></p>
|
||
|
|
</blockquote>
|
||
|
|
<p><strong>Using
|
||
|
|
SQLJ and J2SDK</strong></p>
|
||
|
|
<p>To set up SQLJ on a server running any supported
|
||
|
|
version of J2SDK, complete the following steps:</p>
|
||
|
|
</div>
|
||
|
|
<ol><li class="stepexpand"><span>Add the following files to the CLASSPATH environment variable for
|
||
|
|
your server: </span> <ul><li>/QIBM/ProdData/Os400/Java400/ext/sqlj_classes.jar</li>
|
||
|
|
<li>/QIBM/ProdData/Os400/Java400/ext/translator.zip</li>
|
||
|
|
</ul>
|
||
|
|
<p><strong>Note:</strong> You need to add translator.zip only when you want
|
||
|
|
to run the SQLJ translator (sqlj command). You do not need to add translator.zip
|
||
|
|
if you only want to run compiled Java programs that use SQLJ. for more information,
|
||
|
|
see the following page:</p>
|
||
|
|
<blockquote> <p><a href="sqlj.htm">The SQLJ
|
||
|
|
translator (sqlj)</a></p>
|
||
|
|
</blockquote>
|
||
|
|
</li>
|
||
|
|
<li class="stepexpand"><span>At an iSeries™ command
|
||
|
|
prompt, use the following command to add a link to runtime.zip from your
|
||
|
|
extensions directory. Type the command on one line, then press <strong>Enter</strong>.
|
||
|
|
</span> <pre> ADDLNK OBJ('/QIBM/ProdData/Os400/Java400/ext/runtime.zip')
|
||
|
|
NEWLNK('/QIBM/UserData/Java400/ext/runtime.zip')</pre>
|
||
|
|
For
|
||
|
|
more information about installing extensions, see the following page:
|
||
|
|
<blockquote> <p><a href="instextn.htm">Install extensions for the IBM<sup>®</sup> Developer
|
||
|
|
Kit for Java</a></p>
|
||
|
|
</blockquote>
|
||
|
|
</li>
|
||
|
|
</ol>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="jsqlover.htm" title="You can access Java programs from SQL statements and programs. This can be done using Java stored procedures and Java user-defined functions (UDFs).">Use Java SQL routines</a></div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="linklist"><strong>Collected links</strong><br />
|
||
|
|
|
||
|
|
<div><a href="classpth.htm" title="The Java(TM) virtual machine uses the Java classpath to find classes during runtime. Java commands and tools also use the classpath to locate classes. The default system classpath, the CLASSPATH environment variable, and the classpath command parameter all determine what directories are searched when looking for a particular class.">Java classpath</a></div>
|
||
|
|
<div><a href="sqlj.htm" title="The SQLJ translator, sqlj, generates a serialized profile containing information about the SQL operations found in the SQLJ program. The SQLJ translator uses the /QIBM/ProdData/Java400/ext/translator.zip file.">The SQLJ translator (sqlj)</a></div>
|
||
|
|
<div><a href="instextn.htm" title="Extensions are packages of Java classes that you can use to extend the functionality of the core platform. Extensions are packaged in one or more ZIP files or JAR files, and are loaded into the Java virtual machine by an extension class loader.">Install extensions for the IBM Developer
|
||
|
|
Kit for Java</a></div></div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|