The gsEmbedded program

Interact with the database

ADD / DISPLAY -RECORD SECTION: This section uses the utility method gsUtils.getWishItem to +RECORD SECTION: This section uses the utility method WwdUtils.getWishItem to gather information from the user. It then uses 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 Modified: db/derby/docs/branches/10.3/src/getstart/twwdactivity3_Setup.dita URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/getstart/twwdactivity3_Setup.dita?view=diff&rev=549281&r1=549280&r2=549281 ============================================================================== --- db/derby/docs/branches/10.3/src/getstart/twwdactivity3_Setup.dita (original) +++ db/derby/docs/branches/10.3/src/getstart/twwdactivity3_Setup.dita Wed Jun 20 15:30:02 2007 @@ -23,7 +23,7 @@ This activity loads the database engine using a simple Java JDBC program. -gsEmbedded.java programrunning +WwdEmbedded.java programrunning CLASSPATH environment variable @@ -39,7 +39,7 @@ variable, to locate the binary files (jar files and class files) that are needed to run and other Java applications. Before performing this activity, you need to set -the classpath and compile the gsEmbedded.java program.

+the classpath and compile the WwdEmbedded.java program.

Copy the program files into the DERBYTUTOR directory and set the CLASSPATH environment variable. @@ -65,18 +65,18 @@ at the end of each command so that your current working directory is included in the classpath and the files are copied to the correct location. -Compile the gsEmbedded.java program.javac gsEmbedded.java +Compile the WwdEmbedded.java program.javac WwdEmbedded.java A command prompt appears if the compilation -is successful. The binary file gsEmbedded.class is created. +is successful. The binary file WwdEmbedded.class is created. If an error message appears, verify that the JDK is properly installed. -Run the program.The gsEmbedded.java program populates +Run the program.The WwdEmbedded.java program populates a table with wish-list items. The program prompts you for text input (up to 32 characters), stores the text input in a database table, and then lists the items stored in the table. The program continues to ask for wish-list items until the you type the command exit or a problem is encountered. Some basic information on program progress is displayed at the -beginning and the end of the program. java gsEmbedded +beginning and the end of the program. java WwdEmbedded org.apache.derby.jdbc.EmbeddedDriver loaded. Connected to database jdbcDemoDB . . . . creating table WISH_LIST Modified: db/derby/docs/branches/10.3/src/getstart/twwdactivity4.dita URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/getstart/twwdactivity4.dita?view=diff&rev=549281&r1=549280&r2=549281 ============================================================================== --- db/derby/docs/branches/10.3/src/getstart/twwdactivity4.dita (original) +++ db/derby/docs/branches/10.3/src/getstart/twwdactivity4.dita Wed Jun 20 15:30:02 2007 @@ -26,54 +26,54 @@ client/server implementation that uses the Network Server. -gsClient.java programorg.apache.derby.jdbc.ClientDriver +WwdClient.java programorg.apache.derby.jdbc.ClientDriver This activity assumes you have performed the preceding activities and have a working directory called DERBYTUTOR, and have copies of the program files from the $/demo/programs/workingwithderby/ -directory. A basic knowledge of the gsEmbedded.java program +directory. A basic knowledge of the WwdEmbedded.java program and experience starting and connecting to the Network Server are helpful. -You will need to use a text editor to create the gsClient.java +You will need to use a text editor to create the WwdClient.java program. You will create a client -program, gsClient.java, by changing a few lines of the gsEmbedded.java program. +program, WwdClient.java, by changing a few lines of the WwdEmbedded.java program. You can run the client program in multiple command shells, allowing simultaneous update from two or more sources.

You use two command windows (Server-Shell and Client-Shell) in this activity. You use the Server-Shell to start the Network Server and display Network Server messages. You use the Client-Shell to edit, compile and run -the newly created gsClient.java program. You set the CLASSPATH environment +the newly created WwdClient.java program. You set the CLASSPATH environment variable in the Client-Shell to support the client JDBC program.

-Create the gsClient program using the following +Create the WwdClient program using the following steps: Open a command window (Client-Shell). Change to the DERBYTUTOR directory. -Make a copy of the gsEmbedded.java program -called gsClient.java. +Make a copy of the WwdEmbedded.java program +called WwdClient.java. Operating System Command UNIX (Korn Shell) -cp gsEmbedded.java gsClient.java +cp WwdEmbedded.java WwdClient.java Windows -copy gsEmbedded.java gsClient.java +copy WwdEmbedded.java WwdClient.java -Open the gsClient.java file in a text editor +Open the WwdClient.java file in a text editor and update the class name to reflect the new file name:Original declaration - public class gsEmbedded + public class WwdEmbedded New declaration - public class gsClient + public class WwdClient Edit the DEFINE VARIABLES SECTION of the program so that the driver variable contains the name of the "jdbc:derby://localhost:1527/" + dbName + ";create=true"; -Compile the application.javac gsClient.java +Compile the application.javac WwdClient.java A command prompt appears if the compilation -is successful. The binary file gsClient.class is created. +is successful. The binary file WwdClient.class is created. If an error message appears, modify the line indicated so that it is identical to the example. @@ -142,7 +142,7 @@ Include the dot (.) at the end of the command so that your current working directory is included in the classpath. -Run the program: java gsClient +Run the program: java WwdClient org.apache.derby.jdbc.ClientDriver loaded. Connected to database jdbcDemoDB Enter wish-list item (enter exit to end): @@ -207,7 +207,7 @@ command windows and perform the substeps of the "Run the client program" step in each window. Both clients will operate without a problem. In contrast, it would not be possible for a program that uses the embedded driver (for -example, gsEmbedded.java) to access the database until the +example, WwdEmbedded.java) to access the database until the database or the Network Server is shut down.

You may have noticed that the client program does not shut down the database. This is because the database is a shared resource in a client/server environment and, in most cases, should