What next with Derby

The WwdEmbedded.java program is described here. -Most of the code related to the database activities performed is included +

+Most of the code related to the database activities performed is included in this document but you may find it helpful to open the program file and follow along in a text viewer or editor. The SECTION NAMES referred to in this text can be found in the comments within the program code and serve as cross-reference @@ -37,7 +37,7 @@ from the WwdUtils class. The utility class code is not described here but is available for review in the file WwdUtils.java

Initialize the program INITIALIZATION SECTION: -The initial lines of code identify the Java libraries used in the program +The initial lines of code identify the Java libraries used in the program, then set up the Java class WwdEmbedded and the main method signature. Refer to a standard Java programming guide for information on these program constructs.import java.sql.*; @@ -93,7 +93,7 @@ Program objects needed to perform subsequent SQL operations are initialized here and a check is made to see if the required data table exists.

The statement object s is initialized. If the utility method WwdUtils.wwdChk4Table does -not find the WISH_LIST table it is create by executing +not find the WISH_LIST table it is created by executing the SQL stored in the variable createString via this statement object.

s = conn.createStatement(); if (! WwdUtils.wwdChk4Table(conn)) @@ -110,13 +110,13 @@

Interact with the DatabaseADD / DISPLAY RECORD SECTION: This section uses the utility method WwdUtils.getWishItem to -gather information from the User. It then utilizes the objects setup previously +gather information from the User. It then utilizes the objects set up previously to insert the data into the WISH_LIST table and then display all records. A standard do loop causes the program to repeat this series of steps until exit is entered. The data related activities performed in this section are:

The setString method sets the substitution parameter of the psInsert object to -the value entered by the User then executeUpdate is called +the value entered by the User. Then executeUpdate is called to perform the database insert.psInsert.setString(1,answer); psInsert.executeUpdate();

The statement object s is used to select @@ -137,7 +137,7 @@ When an application starts the Derby engine it should shutdown all databases prior to exiting. The attribute ;shutdown=true in the Derby connection URL performs the shutdown. The shutdown process cleans up records -in the transaction log to insure a faster startup the next time the database +in the transaction log to ensure a faster startup the next time the database is booted.

This section verifies that the embedded driver is being used then issues the shutdown command and catches the shutdown exception to confirm the database shutdown cleanly. The shutdown status is displayed before the Modified: db/derby/docs/trunk/src/workingwithderby/twwdIntro.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/workingwithderby/twwdIntro.dita?view=diff&rev=441307&r1=441306&r2=441307 ============================================================================== --- db/derby/docs/trunk/src/workingwithderby/twwdIntro.dita (original) +++ db/derby/docs/trunk/src/workingwithderby/twwdIntro.dita Thu Sep 7 17:23:46 2006 @@ -40,7 +40,7 @@ It is written and implemented completely in Java, and provides users with a small footprint standards-based database engine that can be tightly embedded into any Java based solution. Derby insures data integrity and provides sophisticated -transactional support. In it's default configuration there is no separate +transaction support. In its default configuration there is no separate database server to be installed or maintained by the end user. For more information on Derby visit the Derby website at: http://db.apache.org/derby.

Performing the Working @@ -72,9 +72,10 @@

On UNIX Korn Shell platforms:

"$JAVA_HOME/bin/java" -version

The output from the command will look -something like this:java version "1.4.2_04" Java(TM) 2 Runtime Environment, -Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) -Client VM (build 1.4.2_04-b05, mixed mode)The output you see +something like this:java version "1.4.2_04" +Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) +Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) +The output you see may be different from what is shown here, because the java -version command outputs vendor-specific information. If the command produced an error or the version listed is not 1.3 or higher, please install a Java development kit Modified: db/derby/docs/trunk/src/workingwithderby/twwdactivity1.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/workingwithderby/twwdactivity1.dita?view=diff&rev=441307&r1=441306&r2=441307 ============================================================================== --- db/derby/docs/trunk/src/workingwithderby/twwdactivity1.dita (original) +++ db/derby/docs/trunk/src/workingwithderby/twwdactivity1.dita Thu Sep 7 17:23:46 2006 @@ -22,14 +22,14 @@ Creating the database and running SQL Connection URLembedded drivercreate=true -IJDatabasecreatingconnecting +ijDatabasecreatingconnecting toDerbylogfile, message and errorSQLcreate tableinsertselect -Run the Derby IJ tool.

+Run the Derby ij tool.

On Windows platforms:: java -jar %DERBY_HOME%\lib\derbyrun.jar ij @@ -101,7 +101,7 @@ -Exit the IJ tool.exit; +Exit the ij tool.exit; Browse the key files created by the activity.

The derby.log message and @@ -124,8 +124,9 @@

-
Description of connection command: connect 'jdbc:derby:firstdb;create=true';
-
connect - the IJ command to establish a connection to +
Description of connection command: +connect 'jdbc:derby:firstdb;create=true';
+
connect - the ij command to establish a connection to a database

The Derby connection URL enclosed in single quotes:

jdbc:derby: - JDBC protocol specification for the Derby @@ -136,7 +137,7 @@
;create=true - The Derby URL attribute used to create databases. Derby does not have an SQL create database command.

-
; (semicolon) - the IJ command terminator.
+
; (semicolon) - the ij command terminator.

Modified: db/derby/docs/trunk/src/workingwithderby/twwdactivity2.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/workingwithderby/twwdactivity2.dita?view=diff&rev=441307&r1=441306&r2=441307 ============================================================================== --- db/derby/docs/trunk/src/workingwithderby/twwdactivity2.dita (original) +++ db/derby/docs/trunk/src/workingwithderby/twwdactivity2.dita Thu Sep 7 17:23:46 2006 @@ -19,13 +19,13 @@ limitations under the License. --> -Activity 2: Run SQL using the Client Driver +Activity 2: Run SQL using the Client driver This activity uses Derby within a Client-Server configuration by using the Network Server. The ij tool is the client application that connects to the Derby Network Server. A database called seconddb is created and some basic SQL commands are executed. -Network ServerClient Driver +Network ServerClient driver