db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j..@apache.org
Subject svn commit: r178570 [2/6] - in /incubator/derby/site/trunk: build/site/ build/site/binaries/ build/site/images/ build/site/integrate/ build/site/integrate/plugin_help/ build/site/integrate/plugin_help/images/ build/site/releases/ src/documentation/content/binaries/ src/documentation/content/xdocs/ src/documentation/content/xdocs/images/ src/documentation/content/xdocs/integrate/ src/documentation/content/xdocs/integrate/plugin_help/ src/documentation/content/xdocs/integrate/plugin_help/images/
Date Thu, 26 May 2005 02:59:29 GMT
Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/derby_app.html
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/derby_app.html?rev=178570&view=auto
==============================================================================
--- incubator/derby/site/trunk/build/site/integrate/plugin_help/derby_app.html (added)
+++ incubator/derby/site/trunk/build/site/integrate/plugin_help/derby_app.html Wed May 25 19:59:25 2005
@@ -0,0 +1,449 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.6">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Creating a Java application to access a Derby database</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://incubator.apache.org/">incubator</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://incubator.apache.org"><img class="logoImage" alt="" src="../../images/apache-incubator-logo.png" title=""></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogo">
+<a href="http://incubator.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java RDBMS."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google:');" value="Search the site with google:" size="25" name="q" id="query" type="text">&nbsp; 
+                    <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript" language="JavaScript"><!--
+              document.write("Published: " + document.lastModified);
+              //  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../../skin/')" id="menu_1.1Title" class="menutitle">Integration</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/misc.html">Summary</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.pdf">C-JDBC (PDF)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.sxw">C-JDBC (SXW)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../DOTS_Derby.html">DOTS Derby</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/UsingDotsDerbySystemTest.pdf">DOTS System</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyCodeCoverageUsingEmma.pdf">EMMA</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/JPetStoreDerby.html">iBATIS JPetStore</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyAndRedHatAppServer.pdf">JOnAS (PDF)</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2', '../../skin/')" id="menu_selected_1.2Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Eclipse Plug-ins</div>
+<div id="menu_selected_1.2" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/derby_plugin.html">10.0 Core</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/func_spec_plugins.html">1.0 UI Functional Spec</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_howto.html">10.1 Core and 1.0 UI</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_slides.html">10.1 Core and 1.0 UI Slides and Lab</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2.5', '../../skin/')" id="menu_selected_1.2.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">10.1 Core and 1.0 UI Documentation</div>
+<div id="menu_selected_1.2.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_toc.html">Getting Started</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/java_project.html">Creating an Eclipse Project</a>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.3', '../../skin/')" id="menu_1.2.5.3Title" class="menutitle">Derby Nature</div>
+<div id="menu_1.2.5.3" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature_toc.html">Adding or Removing</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature.html">Adding the Derby Nature</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/remove_nature.html">Removing the Derby Nature</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.4', '../../skin/')" id="menu_1.2.5.4Title" class="menutitle">Network Server</div>
+<div id="menu_1.2.5.4" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/server_toc.html">Starting and Stopping</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_server.html">Starting the Server</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/stop_server.html">Stopping the Server</a>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/properties.html">Derby Properties</a>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.6', '../../skin/')" id="menu_1.2.5.6Title" class="menutitle">ij</div>
+<div id="menu_1.2.5.6" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij_toc.html">Using ij</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij.html">SQL commands</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij2.html">SQL scripts</a>
+</div>
+</div>
+<div class="menupage">
+<div class="menupagetitle">Building a Java App</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/sysinfo.html">Running sysinfo</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/resources.html">Derby Manuals</a>
+</div>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div id="skinconf-txtlink"></div>
+<div class="trail">
+	        Font size: 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Creating a Java application to access a Derby database</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Creating+a+Java+application+to+access+a+Derby+database">Creating a Java application to access a Derby database</a>
+<ul class="minitoc">
+<li>
+<a href="#Steps+to+create+a+stand-alone+Java+application">Steps to create a stand-alone Java application</a>
+</li>
+<li>
+<a href="#Changing+the+application+to+use+the+Derby+Embedded+Driver">Changing the application to use the Derby Embedded Driver</a>
+</li>
+<li>
+<a href="#About+Schema+Names">About Schema Names</a>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<a name="N10010"></a><a name="Creating+a+Java+application+to+access+a+Derby+database"></a>
+<h2 class="boxed">Creating a Java application to access a Derby database</h2>
+<div class="section">
+<p>Once you've become familiar with starting the network server and running SQL queries, you'll want to use Derby from within a Java application. This section will demonstrate using Derby from a stand-alone Java application.</p>
+<p>This example will access the data in our sample database, <strong>myDB</strong>, which contains the restaurants table. By following the two <a href="ij_toc.html"><strong>ij</strong></a> sections in the help, this database and table will have already been created and ready to use. If you have not created the database and the table return to the <a href="ij_toc.html"><strong>ij</strong></a> sections and create them now.</p>
+<a name="N10025"></a><a name="Steps+to+create+a+stand-alone+Java+application"></a>
+<h3 class="boxed">Steps to create a stand-alone Java application</h3>
+<ul>
+<li>From the <strong>Java</strong> perspective, select the project in the <strong>Package Explorer</strong> view. Right-click the project to bring up the context menu and select <strong>New, Class</strong>.</li>
+</ul>
+<br>
+<br>
+<img alt="Creating a Java class in Eclipse" src="images/new_class.GIF"><p>Give the Java class a package name, <strong>myapp</strong>, name the class <strong>Restaurants</strong>, make it a public class, and include a main method in the class since this will be a stand-alone application. The image below shows an example of this. Click <strong>Finish</strong> to create the class.</p>
+<img alt="New Java class wizard" src="images/create_class.GIF"><p>The Java class shown below, <strong>Restaurants.java</strong>, connects to the Derby Network Server, inserts a row into the restaurants table, and then displays a select from the restaurants table. Copy the code below into the Java editor window for the <strong>Restaurants.java</strong> class you just created.</p>
+<pre>package myapp;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.sql.ResultSetMetaData;
+
+
+public class Restaurants
+{
+    private static String dbURL = "jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine";
+    private static String tableName = "restaurants";
+    // jdbc Connection
+    private static Connection conn = null;
+    private static Statement stmt = null;
+
+    public static void main(String[] args)
+    {
+        createConnection();
+        insertRestaurants(5, "LaVals", "Berkeley");
+        selectRestaurants();
+        shutdown();
+    }
+    
+    private static void createConnection()
+    {
+        try
+        {
+            Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
+            //Get a connection
+            conn = DriverManager.getConnection(dbURL); 
+        }
+        catch (Exception except)
+        {
+            except.printStackTrace();
+        }
+    }
+    
+    private static void insertRestaurants(int id, String restName, String cityName)
+    {
+        try
+        {
+            stmt = conn.createStatement();
+            stmt.execute("insert into " + tableName + " values (" +
+                    id + ",'" + restName + "','" + cityName +"')");
+            stmt.close();
+        }
+        catch (SQLException sqlExcept)
+        {
+            sqlExcept.printStackTrace();
+        }
+    }
+    
+    private static void selectRestaurants()
+    {
+        try
+        {
+            stmt = conn.createStatement();
+            ResultSet results = stmt.executeQuery("select * from " + tableName);
+            ResultSetMetaData rsmd = results.getMetaData();
+            int numberCols = rsmd.getColumnCount();
+            for (int i=1; i&lt;=numberCols; i++)
+            {
+                //print Column Names
+                System.out.print(rsmd.getColumnLabel(i)+"\t\t");  
+            }
+
+            System.out.println("\n-------------------------------------------------");
+
+            while(results.next())
+            {
+                int id = results.getInt(1);
+                String restName = results.getString(2);
+                String cityName = results.getString(3);
+                System.out.println(id + "\t\t" + restName + "\t\t" + cityName);
+            }
+            results.close();
+            stmt.close();
+        }
+        catch (SQLException sqlExcept)
+        {
+            sqlExcept.printStackTrace();
+        }
+    }
+    
+    private static void shutdown()
+    {
+        try
+        {
+            if (stmt != null)
+            {
+                stmt.close();
+            }
+            if (conn != null)
+            {
+                DriverManager.getConnection(dbURL + ";shutdown=true");
+                conn.close();
+            }           
+        }
+        catch (SQLException sqlExcept)
+        {
+            
+        }
+
+    }
+}
+</pre>
+<p>Once Restaurants.java is compiled without errors, run the Java application by right-clicking it from the Package Explorer view and selecting <strong>Run, Java Application</strong>.</p>
+<img alt="Running a java application" src="images/run_javaapp.GIF"><p>The output from running <strong>Restaurants.java</strong> is shown below. It shows the successful insert of a row into our restaurants table and a select of all rows in the table. If you encounter any errors when running the application make sure the Derby Network Server has been started on port 1527 and the myDB database exists in the current workspace and Java project.</p>
+<img alt="Output from a java application" src="images/completed_javaapp.GIF"><a name="N10062"></a><a name="Changing+the+application+to+use+the+Derby+Embedded+Driver"></a>
+<h3 class="boxed">Changing the application to use the Derby Embedded Driver</h3>
+<p>
+<strong>Restaurants.java</strong> accessed the Derby database, <strong>myDB</strong> using the Derby Network Client Driver. The values for loading the driver and the Database connection URL are shown below.</p>
+<ul>
+<li>
+<strong>Driver name</strong> org.apache.derby.jdbc.ClientDriver<br>
+<br>
+</li>
+<li>
+<strong>Database connection URL</strong> jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine<br>
+<br>
+</li>
+</ul>
+<p>To change the application to use the Derby Embedded Driver we need to change these values to:</p>
+<ul>
+<li>
+<strong>Driver name</strong> org.apache.derby.jdbc.EmbeddedDriver<br>
+<br>
+</li>
+<li>
+<strong>Database connection URL</strong> jdbc:derby:myDB;create=true;user=me;password=mine<br>
+<br>
+</li>
+</ul>
+<a name="N10089"></a><a name="About+Schema+Names"></a>
+<h3 class="boxed">About Schema Names</h3>
+<p>If a database is created in Derby using the embedded driver and no user name is specified, the default schema used becomes <strong>APP</strong>. Therefore any tables created in the database have a schema name of <strong>APP</strong>. However, when creating a Derby database using the Network Server, the value for the schema becomes the value of the username used to connect with as part of the database URL. In our example we first created the <strong>myDB</strong> database using the user <strong>me</strong>.</p>
+<p>When we change the application to connect using the embedded driver, the schema will default to <strong>APP</strong> unless we explicitly specify a schema, or pass the username as part of the Database connection URL. To access the table without passing the username as part of the embedded driver Database URL we would refer to the table as <strong>ME.restaurants</strong>.</p>
+<p>Only two lines of code need to be changed in Restaurants.java to use the Derby Embedded Driver to access the myDB database and insert and select into the me.restaurants table. The old values are listed below.</p>
+<pre>// variables
+private static String dbURL = "jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine";
+
+// from the createConnection method
+Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
+</pre>
+<p>The new values are shown below to use the Embedded Driver.</p>
+<pre>// variables
+private static String dbURL = "jdbc:derby:myDB;create=true;user=me;password=mine";
+
+// from the createConnection method
+Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
+</pre>
+<p>Comment out the old values and replace them with the new ones shown above. Recompile the class and if your Derby Network Server is running stop it before running the Java application with the Embedded Driver.</p>
+<p>Applications which use the Derby Embedded Driver may only access the database from the same JVM. Applications which use the Derby Network Server can access the database from other JVM's.</p>
+</div>
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+ Copyright &copy; 2004-2005 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0integrate/plugin_help/derby_app.html">derby-dev@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/derby_app.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/ij.html
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/ij.html?rev=178570&view=auto
==============================================================================
--- incubator/derby/site/trunk/build/site/integrate/plugin_help/ij.html (added)
+++ incubator/derby/site/trunk/build/site/integrate/plugin_help/ij.html Wed May 25 19:59:25 2005
@@ -0,0 +1,317 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.6">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Using ij to issue SQL commands</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://incubator.apache.org/">incubator</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://incubator.apache.org"><img class="logoImage" alt="" src="../../images/apache-incubator-logo.png" title=""></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogo">
+<a href="http://incubator.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java RDBMS."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google:');" value="Search the site with google:" size="25" name="q" id="query" type="text">&nbsp; 
+                    <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript" language="JavaScript"><!--
+              document.write("Published: " + document.lastModified);
+              //  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../../skin/')" id="menu_1.1Title" class="menutitle">Integration</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/misc.html">Summary</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.pdf">C-JDBC (PDF)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.sxw">C-JDBC (SXW)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../DOTS_Derby.html">DOTS Derby</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/UsingDotsDerbySystemTest.pdf">DOTS System</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyCodeCoverageUsingEmma.pdf">EMMA</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/JPetStoreDerby.html">iBATIS JPetStore</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyAndRedHatAppServer.pdf">JOnAS (PDF)</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2', '../../skin/')" id="menu_selected_1.2Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Eclipse Plug-ins</div>
+<div id="menu_selected_1.2" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/derby_plugin.html">10.0 Core</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/func_spec_plugins.html">1.0 UI Functional Spec</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_howto.html">10.1 Core and 1.0 UI</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_slides.html">10.1 Core and 1.0 UI Slides and Lab</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2.5', '../../skin/')" id="menu_selected_1.2.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">10.1 Core and 1.0 UI Documentation</div>
+<div id="menu_selected_1.2.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_toc.html">Getting Started</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/java_project.html">Creating an Eclipse Project</a>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.3', '../../skin/')" id="menu_1.2.5.3Title" class="menutitle">Derby Nature</div>
+<div id="menu_1.2.5.3" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature_toc.html">Adding or Removing</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature.html">Adding the Derby Nature</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/remove_nature.html">Removing the Derby Nature</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.4', '../../skin/')" id="menu_1.2.5.4Title" class="menutitle">Network Server</div>
+<div id="menu_1.2.5.4" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/server_toc.html">Starting and Stopping</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_server.html">Starting the Server</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/stop_server.html">Stopping the Server</a>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/properties.html">Derby Properties</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2.5.6', '../../skin/')" id="menu_selected_1.2.5.6Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">ij</div>
+<div id="menu_selected_1.2.5.6" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij_toc.html">Using ij</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">SQL commands</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij2.html">SQL scripts</a>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/derby_app.html">Building a Java App</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/sysinfo.html">Running sysinfo</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/resources.html">Derby Manuals</a>
+</div>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div id="skinconf-txtlink"></div>
+<div class="trail">
+	        Font size: 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Using ij to issue SQL commands</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Using+ij+to+issue+SQL+commands">Using ij to issue SQL commands</a>
+<ul class="minitoc">
+<li>
+<a href="#To+launch+">To launch ij</a>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<a name="N10010"></a><a name="Using+ij+to+issue+SQL+commands"></a>
+<h2 class="boxed">Using ij to issue SQL commands</h2>
+<div class="section">
+<p>
+<strong>ij</strong>, the interactive SQL scripting tool provided with Derby, allows you to issue ad-hoc queries against a Derby database. Running <strong>ij</strong> from within Eclipse speeds application development by testing and running SQL statements prior to coding JDBC calls.</p>
+<a name="N1001B"></a><a name="To+launch+"></a>
+<h3 class="boxed">To launch ij</h3>
+<ul>
+<li>Select the project and bring up the context menu. Select the menu item, <strong>Apache Derby, ij (Interactive SQL)</strong>.</li>
+</ul>
+<p>
+<img alt="ij menu item" src="images/start_ij.GIF"></p>
+<ul>
+<li>The <strong>Console</strong> view will show the <strong>ij</strong> prompt. For this example we assume the Derby Network Server has been started; if you haven't started it, go ahead and start it up now.<br>
+<br>
+</li>
+<li>The first step to using Derby is to connect to the database using a database JDBC connection URL.<br>The database connection URL we'll use for this example will connect to our Network Server using the Derby Network Client driver on the localhost. We'll create a database called <strong>myDB</strong> as the user 'me' with a password of 'mine.'<br>
+<br>To connect to the database from <strong>ij</strong> we need to issue the <strong>connect</strong> command, so the entire command to connect to our database looks like this: <pre>connect 'jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine';
+</pre>
+</li>
+<li>Cut and paste the above connection URL into the <strong>ij</strong> console window. It should create a database in the current workspace, under the current Java project, called <strong>myDB</strong>.<br>
+<br>
+</li>
+<li>We'll also create a table in our myDB database, insert some rows and select all rows from the table. Here is the SQL to do this: <pre>create table restaurants(id integer, name varchar(20), city varchar(50));
+insert into restaurants values (1, 'Irifunes', 'San Mateo');
+insert into restaurants values (2, 'Estradas', 'Daly City');
+insert into restaurants values (3, 'Prime Rib House', 'San Francisco');
+select * from restaurants;
+</pre>
+</li>
+<li>Cut and paste this SQL (one line at a time) into the <strong>ij</strong> console window.</li>
+</ul>
+<br>
+<br>
+<p>Sample output from our <strong>ij</strong> session which runs the sql commands listed above is shown below.</p>
+<p>
+<img alt="ij console output" src="images/ij_commands.GIF"></p>
+<p>The database connection URL shown above is used to connect to the Derby Network Server. If you want to connect to the database using the Derby JDBC embedded driver the connection URL would look like <strong>jdbc:derby:myDB;create=true</strong> and the ij command would be this:</p>
+<pre>connect 'jdbc:derby:myDB;create=true';
+</pre>
+<br>
+<br>
+<p>For detailed information on the proper syntax to use for the Connection URL refer to the Derby <em>Tools &amp; Utility Guide</em>. The section called <strong>Getting started with ij</strong> provides the necessary information to start using ij.</p>
+</div>
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+ Copyright &copy; 2004-2005 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0integrate/plugin_help/ij.html">derby-dev@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/ij.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/ij2.html
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/ij2.html?rev=178570&view=auto
==============================================================================
--- incubator/derby/site/trunk/build/site/integrate/plugin_help/ij2.html (added)
+++ incubator/derby/site/trunk/build/site/integrate/plugin_help/ij2.html Wed May 25 19:59:25 2005
@@ -0,0 +1,316 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.6">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Using ij to run SQL scripts</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://incubator.apache.org/">incubator</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://incubator.apache.org"><img class="logoImage" alt="" src="../../images/apache-incubator-logo.png" title=""></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogo">
+<a href="http://incubator.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java RDBMS."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google:');" value="Search the site with google:" size="25" name="q" id="query" type="text">&nbsp; 
+                    <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript" language="JavaScript"><!--
+              document.write("Published: " + document.lastModified);
+              //  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../../skin/')" id="menu_1.1Title" class="menutitle">Integration</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/misc.html">Summary</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.pdf">C-JDBC (PDF)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.sxw">C-JDBC (SXW)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../DOTS_Derby.html">DOTS Derby</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/UsingDotsDerbySystemTest.pdf">DOTS System</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyCodeCoverageUsingEmma.pdf">EMMA</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/JPetStoreDerby.html">iBATIS JPetStore</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyAndRedHatAppServer.pdf">JOnAS (PDF)</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2', '../../skin/')" id="menu_selected_1.2Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Eclipse Plug-ins</div>
+<div id="menu_selected_1.2" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/derby_plugin.html">10.0 Core</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/func_spec_plugins.html">1.0 UI Functional Spec</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_howto.html">10.1 Core and 1.0 UI</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_slides.html">10.1 Core and 1.0 UI Slides and Lab</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2.5', '../../skin/')" id="menu_selected_1.2.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">10.1 Core and 1.0 UI Documentation</div>
+<div id="menu_selected_1.2.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_toc.html">Getting Started</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/java_project.html">Creating an Eclipse Project</a>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.3', '../../skin/')" id="menu_1.2.5.3Title" class="menutitle">Derby Nature</div>
+<div id="menu_1.2.5.3" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature_toc.html">Adding or Removing</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature.html">Adding the Derby Nature</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/remove_nature.html">Removing the Derby Nature</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.4', '../../skin/')" id="menu_1.2.5.4Title" class="menutitle">Network Server</div>
+<div id="menu_1.2.5.4" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/server_toc.html">Starting and Stopping</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_server.html">Starting the Server</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/stop_server.html">Stopping the Server</a>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/properties.html">Derby Properties</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2.5.6', '../../skin/')" id="menu_selected_1.2.5.6Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">ij</div>
+<div id="menu_selected_1.2.5.6" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij_toc.html">Using ij</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij.html">SQL commands</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">SQL scripts</div>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/derby_app.html">Building a Java App</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/sysinfo.html">Running sysinfo</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/resources.html">Derby Manuals</a>
+</div>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div id="skinconf-txtlink"></div>
+<div class="trail">
+	        Font size: 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Using ij to run SQL scripts</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Using+ij+to+run+SQL+scripts">Using ij to run SQL scripts</a>
+<ul class="minitoc">
+<li>
+<a href="#Follow+these+steps+to+run+an+SQL+script">Follow these steps to run an SQL script</a>
+</li>
+<li>
+<a href="#Example+of+creating+and+running+an+SQL+script">Example of creating and running an SQL script</a>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<a name="N10010"></a><a name="Using+ij+to+run+SQL+scripts"></a>
+<h2 class="boxed">Using ij to run SQL scripts</h2>
+<div class="section">
+<p>
+<strong>ij</strong> scripts, files that end in an .sql extension and contain SQL commands, can be run using the Derby plug-ins. This allows you to use SQL scripts containing multiple commands and run them in a single execution of <strong>ij</strong>.</p>
+<a name="N1001B"></a><a name="Follow+these+steps+to+run+an+SQL+script"></a>
+<h3 class="boxed">Follow these steps to run an SQL script</h3>
+<ul>
+<li>Create a script which contains SQL commands and save the file with a .sql extension. Remember to make the database connection your first command in the script - no default connection exists.<br>
+<br>
+</li>
+<li>Save the file in your current workspace, under your Java project, or import it into your workspace.<br>
+<br>
+</li>
+<li>Run the script using the menu item <strong>Apache Derby, Run SQL script using 'ij'</strong>
+<br>
+<br>
+</li>
+<li>The output appears in the <strong>ij</strong> console window.<br>
+<br>
+</li>
+</ul>
+<a name="N10035"></a><a name="Example+of+creating+and+running+an+SQL+script"></a>
+<h3 class="boxed">Example of creating and running an SQL script</h3>
+<p>We'll go through a complete example below with an sql file called <strong>restaurants.sql</strong>. This script relies on a table we created in the help section, <a href="ij.html">Using ij to issue SQL commands.</a> Run that SQL prior to completing these steps.</p>
+<p>From the main Eclipse menu select <strong>File, New, File</strong>.</p>
+<img alt="Creating a new file in Eclipse" src="images/create_file.GIF"><p>Use the current Java project as the parent folder, for example, myJavaProject. Name the file <strong>restaurants.sql</strong>, and click <strong>Finish</strong>.</p>
+<p>Now the workspace will look like this.</p>
+<img alt="Adding an sql file to the Java project" src="images/create_restaurant.GIF"><p>Type the following in the restaurants.sql editor window (you may need to double click the restaurants.sql file to create an editor window to type in.)</p>
+<pre>connect 'jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine';
+insert into restaurants values (4, 'Grande Burrito', 'Oakland');
+update restaurants set city = 'Ukiah' where name = 'Irifunes';
+select * from restaurants;
+disconnect;
+exit;
+</pre>
+<p>Now save the restaurants.sql file so we can run the script. Use <strong>Ctrl + S</strong> in the windows environment to save an open file. Once the file has been saved the asterisk will disappear next to the name of the file in the editor.</p>
+<p>The last step is to run the SQL script. Right-click the <strong>restaurants.sql</strong> file in the <strong>Package Explorer</strong> view and select <strong>Apache Derby, Run SQL Script using 'ij'</strong>.</p>
+<img alt="Run SQL Script using 'ij'" src="images/restaurant_editor.GIF"><p>The <strong>Console</strong> view shows the SQL commands contained in the file and executing in <strong>ij</strong> along with the output of the commands.</p>
+<img alt="Console view of ij script output" src="images/restaurant_script.GIF"></div>
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+ Copyright &copy; 2004-2005 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0integrate/plugin_help/ij2.html">derby-dev@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/ij2.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/ij_toc.html
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/ij_toc.html?rev=178570&view=auto
==============================================================================
--- incubator/derby/site/trunk/build/site/integrate/plugin_help/ij_toc.html (added)
+++ incubator/derby/site/trunk/build/site/integrate/plugin_help/ij_toc.html Wed May 25 19:59:25 2005
@@ -0,0 +1,288 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.6">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Using ij</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://incubator.apache.org/">incubator</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://incubator.apache.org"><img class="logoImage" alt="" src="../../images/apache-incubator-logo.png" title=""></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogo">
+<a href="http://incubator.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java RDBMS."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google:');" value="Search the site with google:" size="25" name="q" id="query" type="text">&nbsp; 
+                    <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript" language="JavaScript"><!--
+              document.write("Published: " + document.lastModified);
+              //  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../../skin/')" id="menu_1.1Title" class="menutitle">Integration</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/misc.html">Summary</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.pdf">C-JDBC (PDF)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.sxw">C-JDBC (SXW)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../DOTS_Derby.html">DOTS Derby</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/UsingDotsDerbySystemTest.pdf">DOTS System</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyCodeCoverageUsingEmma.pdf">EMMA</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/JPetStoreDerby.html">iBATIS JPetStore</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyAndRedHatAppServer.pdf">JOnAS (PDF)</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2', '../../skin/')" id="menu_selected_1.2Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Eclipse Plug-ins</div>
+<div id="menu_selected_1.2" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/derby_plugin.html">10.0 Core</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/func_spec_plugins.html">1.0 UI Functional Spec</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_howto.html">10.1 Core and 1.0 UI</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_slides.html">10.1 Core and 1.0 UI Slides and Lab</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2.5', '../../skin/')" id="menu_selected_1.2.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">10.1 Core and 1.0 UI Documentation</div>
+<div id="menu_selected_1.2.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_toc.html">Getting Started</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/java_project.html">Creating an Eclipse Project</a>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.3', '../../skin/')" id="menu_1.2.5.3Title" class="menutitle">Derby Nature</div>
+<div id="menu_1.2.5.3" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature_toc.html">Adding or Removing</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature.html">Adding the Derby Nature</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/remove_nature.html">Removing the Derby Nature</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.4', '../../skin/')" id="menu_1.2.5.4Title" class="menutitle">Network Server</div>
+<div id="menu_1.2.5.4" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/server_toc.html">Starting and Stopping</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_server.html">Starting the Server</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/stop_server.html">Stopping the Server</a>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/properties.html">Derby Properties</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2.5.6', '../../skin/')" id="menu_selected_1.2.5.6Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">ij</div>
+<div id="menu_selected_1.2.5.6" class="selectedmenuitemgroup" style="display: block;">
+<div class="menupage">
+<div class="menupagetitle">Using ij</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij.html">SQL commands</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij2.html">SQL scripts</a>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/derby_app.html">Building a Java App</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/sysinfo.html">Running sysinfo</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/resources.html">Derby Manuals</a>
+</div>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div id="skinconf-txtlink"></div>
+<div class="trail">
+	        Font size: 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Using ij</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Using+ij">Using ij</a>
+<ul class="minitoc">
+<li>
+<a href="#Using+ij+to+issue+SQL+commands">Using ij to issue SQL commands</a>
+</li>
+<li>
+<a href="#Using+ij+to+run+SQL+scripts">Using ij to run SQL scripts</a>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<a name="N10010"></a><a name="Using+ij"></a>
+<h2 class="boxed">Using ij</h2>
+<div class="section">
+<p>To issue SQL commands against a Derby database, use <strong>ij</strong>, the SQL scripting tool.</p>
+<a name="N10019"></a><a name="Using+ij+to+issue+SQL+commands"></a>
+<h3 class="boxed">Using ij to issue SQL commands</h3>
+<p>ij, the interactive SQL scripting tool, can be run via the Eclipse console. See the page, <a href="ij.html">Using ij to issue SQL commands</a>
+</p>
+<a name="N10022"></a><a name="Using+ij+to+run+SQL+scripts"></a>
+<h3 class="boxed">Using ij to run SQL scripts</h3>
+<p>Entire SQL <a href="ij2.html">scripts</a>, can be executed using ij.</p>
+</div>
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+ Copyright &copy; 2004-2005 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0integrate/plugin_help/ij_toc.html">derby-dev@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/ij_toc.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/add_nature.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/add_nature.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/add_nature.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/completed_javaapp.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/completed_javaapp.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/completed_javaapp.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_class.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_class.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_class.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_file.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_file.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_file.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_restaurant.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_restaurant.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/create_restaurant.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/ij_commands.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/ij_commands.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/ij_commands.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/new_class.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/new_class.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/new_class.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/properties.gif
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/properties.gif?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/properties.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/properties_new.gif
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/properties_new.gif?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/properties_new.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/remove_nature.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/remove_nature.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/remove_nature.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/restaurant_editor.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/restaurant_editor.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/restaurant_editor.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/restaurant_script.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/restaurant_script.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/restaurant_script.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/run_javaapp.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/run_javaapp.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/run_javaapp.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/shutdown_success.gif
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/shutdown_success.gif?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/shutdown_success.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_ij.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_ij.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_ij.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_server.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_server.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_server.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_server_console.gif
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_server_console.gif?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/start_server_console.gif
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/stop_server.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/stop_server.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/stop_server.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/sysinfo_output.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/sysinfo_output.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/sysinfo_output.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/sysinfo_start.GIF
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/images/sysinfo_start.GIF?rev=178570&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/images/sysinfo_start.GIF
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/derby/site/trunk/build/site/integrate/plugin_help/java_project.html
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/integrate/plugin_help/java_project.html?rev=178570&view=auto
==============================================================================
--- incubator/derby/site/trunk/build/site/integrate/plugin_help/java_project.html (added)
+++ incubator/derby/site/trunk/build/site/integrate/plugin_help/java_project.html Wed May 25 19:59:25 2005
@@ -0,0 +1,298 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.6">
+<meta name="Forrest-skin-name" content="pelt">
+<title>Creating an Eclipse Java project</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://incubator.apache.org/">incubator</a><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="http://incubator.apache.org"><img class="logoImage" alt="" src="../../images/apache-incubator-logo.png" title=""></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogo">
+<a href="http://incubator.apache.org/derby/"><img class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java RDBMS."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<form action="http://www.google.com/search" method="get" class="roundtopsmall">
+<input value="apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google:');" value="Search the site with google:" size="25" name="q" id="query" type="text">&nbsp; 
+                    <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+    |end search
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../manuals/index.html">Manuals</a>
+</li>
+<li>
+<a class="base-not-selected" href="../../papers/index.html">Papers</a>
+</li>
+<li class="current">
+<a class="base-selected" href="../../integrate/index.html">Integration</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript" language="JavaScript"><!--
+              document.write("Published: " + document.lastModified);
+              //  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../../skin/')" id="menu_1.1Title" class="menutitle">Integration</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/index.html">Index</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/misc.html">Summary</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.pdf">C-JDBC (PDF)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/HOWTO_CJDBC_Derby_v0.2.sxw">C-JDBC (SXW)</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../DOTS_Derby.html">DOTS Derby</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/UsingDotsDerbySystemTest.pdf">DOTS System</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyCodeCoverageUsingEmma.pdf">EMMA</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/JPetStoreDerby.html">iBATIS JPetStore</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../binaries/DerbyAndRedHatAppServer.pdf">JOnAS (PDF)</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2', '../../skin/')" id="menu_selected_1.2Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">Eclipse Plug-ins</div>
+<div id="menu_selected_1.2" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/derby_plugin.html">10.0 Core</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/func_spec_plugins.html">1.0 UI Functional Spec</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_howto.html">10.1 Core and 1.0 UI</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_slides.html">10.1 Core and 1.0 UI Slides and Lab</a>
+</div>
+<div onclick="SwitchMenu('menu_selected_1.2.5', '../../skin/')" id="menu_selected_1.2.5Title" class="menutitle" style="background-image: url('../../skin/images/chapter_open.gif');">10.1 Core and 1.0 UI Documentation</div>
+<div id="menu_selected_1.2.5" class="selectedmenuitemgroup" style="display: block;">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_toc.html">Getting Started</a>
+</div>
+<div class="menupage">
+<div class="menupagetitle">Creating an Eclipse Project</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.3', '../../skin/')" id="menu_1.2.5.3Title" class="menutitle">Derby Nature</div>
+<div id="menu_1.2.5.3" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature_toc.html">Adding or Removing</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/nature.html">Adding the Derby Nature</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/remove_nature.html">Removing the Derby Nature</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.4', '../../skin/')" id="menu_1.2.5.4Title" class="menutitle">Network Server</div>
+<div id="menu_1.2.5.4" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/server_toc.html">Starting and Stopping</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/start_server.html">Starting the Server</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/stop_server.html">Stopping the Server</a>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/properties.html">Derby Properties</a>
+</div>
+<div onclick="SwitchMenu('menu_1.2.5.6', '../../skin/')" id="menu_1.2.5.6Title" class="menutitle">ij</div>
+<div id="menu_1.2.5.6" class="menuitemgroup">
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij_toc.html">Using ij</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij.html">SQL commands</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/ij2.html">SQL scripts</a>
+</div>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/derby_app.html">Building a Java App</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/sysinfo.html">Running sysinfo</a>
+</div>
+<div class="menuitem">
+<a title="" href="../../integrate/plugin_help/resources.html">Derby Manuals</a>
+</div>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<div id="skinconf-txtlink"></div>
+<div class="trail">
+	        Font size: 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Creating an Eclipse Java project</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Creating+an+Eclipse+Java+project">Creating an Eclipse Java project</a>
+</li>
+</ul>
+</div>
+<a name="N10010"></a><a name="Creating+an+Eclipse+Java+project"></a>
+<h2 class="boxed">Creating an Eclipse Java project</h2>
+<div class="section">
+<p>The steps below outline how to create a Java project using many of the default settings to make it easy to get started.</p>
+<ul>
+<li>From the main workbench window, click File &gt; New &gt; Project. The New Project wizard opens.<br>
+<br>
+</li>
+<li>Select Java Project and click Next.<br>
+<br>
+</li>
+<li>In the Project name field, type a name for your new Java project, like myJavaProject.<br>
+<br>
+</li>
+<li>For Location, choose <strong>Create project in workspace</strong> and for the Project Layout, select <strong>Use project folder as root for sources and class files</strong>.<br>
+<br>
+</li>
+<li>Click the Next button, then Finish.<br>
+<br>
+</li>
+<li>You may be prompted about switching to the Java Perspective. Answer Yes to this question.<br>
+<br>
+</li>
+<li>The Package Explorer view now shows your new Java project.<br>
+<br>
+</li>
+</ul>
+<br>
+<br>
+</div>
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
+</div>
+<div id="footer">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<div class="copyright">
+ Copyright &copy; 2004-2005 Apache Software Foundation</div>
+<div id="feedback">
+    Send feedback about the website to:
+  <a id="feedbackto" href="mailto:derby-dev@db.apache.org?subject=Feedback%C2%A0integrate/plugin_help/java_project.html">derby-dev@db.apache.org</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
+</div>
+</body>
+</html>

Propchange: incubator/derby/site/trunk/build/site/integrate/plugin_help/java_project.html
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message