skywolf:~% cd tom tomcat.tar.gz tomcat/ skywolf:~% cd tomcat/to tomcat.tar.gz tomcat/ skywolf:~% cd tomcat/tomcat/webapps/tmp/ skywolf:~/tomcat/tomcat/webapps/tmp% java -classpath .:/h/u2/csc309h/lib/pointbase/pbembedded41ev.jar:/h/u2/csc309h/lib/pointbase/pbtools41ev.jar com.pointbase.tools.toolsCommander Do you wish to create a new database? [default: N]: Y Select product to connect with: Embedded (E), or Server (S)? [default: E]: Please enter the driver to use: [default: [com.pointbase.jdbc.jdbcUniversalDriver]: Please enter the database URL to use: [default: [jdbc:pointbase:embedded:sample]: Username: [default: PUBLIC]: Password: [default: PUBLIC]: ************************************************************* *** *** *** P L E A S E W A I T *** *** *** *** Creating new database... This may take a few minutes. *** *** *** ************************************************************* PointBase Commander 4.1EV EMBEDDED Interactive SQL command language. Linux/2.4.27-i686-cdf-server (C) Copyright 1998 - 2001 PointBase(R), Inc. All rights reserved. SQL> select * from systables; SQL> SCHEMAID TABLENAME ------------ ------------------------------------------------------------ 4 SYSCHECKCONSTRAINTS 4 SYSCOLUMNPRIVILEGES 4 SYSCOLUMNS 4 SYSCONSTRAINTROUTINEDEPEND 4 SYSINDEXES 4 SYSINDEXKEYS 4 SYSKEYCONSTRAINTCOLUMNS 4 SYSPAGESIZEMAP 4 SYSPARAMETERS 4 SYSREFERENTIALCONSTRAINTS 4 SYSROUTINEPRIVILEGES 4 SYSROUTINES 4 SYSSCHEMATA 4 SYSSQLDATATYPES 4 SYSSQLSTATEMENTS 4 SYSTABLECONSTRAINTS 4 SYSTABLEPRIVILEGES 4 SYSTABLES 4 SYSTRIGGERCOLUMNS 4 SYSTRIGGERROUTINEDEPEND 4 SYSTRIGGERS 4 SYSUSERS 4 SYSVIEWS 4 SYSVIEWTABLES 24 Rows Selected. SQL>create table student (id integer, name character(40), birthday date); SQL> OK SQL> insert into student values (1, 'John', date '1980-1-1'); SQL> 1 row(s) affected SQL> commit; SQL> OK SQL> select * from student; SQL> ID NAME BIRTHDAY ------------ ------------------------------------------ ---------- 1 John 1980-01-01 1 Row Selected. SQL> exit; SQL> EXIT; skywolf:~/tomcat/tomcat/webapps/tmp%java -classpath .:/h/u2/csc309h/lib/pointbase/pbembedded41ev.jar:/h/u2/csc309h/lib/pointbase/pbtools41ev.jar com.pointbase.tools.toolsConsole skywolf:~/tomcat/tomcat/webapps/tmp%java -classpath .:/h/u2/csc309h/lib/pointbase/pbembedded41ev.jar:/h/u2/csc309h/lib/pointbase/pbtools41ev.jar com.pointbase.tools.toolsCommander Do you wish to create a new database? [default: N]: Select product to connect with: Embedded (E), or Server (S)? [default: E]: Please enter the driver to use: [default: [com.pointbase.jdbc.jdbcUniversalDriver]: Please enter the database URL to use: [default: [jdbc:pointbase:embedded:sample]: Username: [default: PUBLIC]: Password: [default: PUBLIC]: PointBase Commander 4.1EV EMBEDDED Interactive SQL command language. Linux/2.4.27-i686-cdf-server (C) Copyright 1998 - 2001 PointBase(R), Inc. All rights reserved. SQL> select * from student; SQL> ID NAME BIRTHDAY ------------ ------------------------------------------ ---------- 1 John 1980-01-01 1 Row Selected. SQL>delete from student; SQL> 1 row(s) affected SQL> select * from student; SQL> ID NAME BIRTHDAY ------------ ------------------------------------------ ---------- 0 Rows Selected. SQL> exit; SQL> EXIT; skywolf:~/tomcat/tomcat/webapps/tmp% java -classpath .:/h/u2/csc309h/lib/pointbase/pbembedded41ev.jar:/h/u2/csc309h/lib/pointbase/pbtools41ev.jar com.pointbase.tools.toolsCommander Do you wish to create a new database? [default: N]: Select product to connect with: Embedded (E), or Server (S)? [default: E]: Please enter the driver to use: [default: [com.pointbase.jdbc.jdbcUniversalDriver]: Please enter the database URL to use: [default: [jdbc:pointbase:embedded:sample]: Username: [default: PUBLIC]: Password: [default: PUBLIC]: PointBase Commander 4.1EV EMBEDDED Interactive SQL command language. Linux/2.4.27-i686-cdf-server (C) Copyright 1998 - 2001 PointBase(R), Inc. All rights reserved. SQL> select * from student; SQL> ID NAME BIRTHDAY ------------ ------------------------------------------ ---------- 1 John 1980-01-01 1 Row Selected. SQL>set autocommit on; SQL> SET AUTOCOMMIT ON; SQL> AUTOCOMMIT set from "OFF" to "ON" SQL> SQL> help; SQL> HELP; Commander command summary: ------------------------- SET TIMING ON Begin showing timing for commands. SET TIMING OFF End showing timing for commands. SET SCREENHEIGHT The number of lines per page. SET SCREENWIDTH The number of characters per line. SET PAUSE ON Turn ON pause after every command. SET PAUSE OFF Turn OFF pause after every command. SET DATA ON/OFF Turn ON/OFF the display of result set data. SET NULLS NULL value display. SHOW SYSTEM Report Database Meta Information DESCRIBE Report Table Information UNLOAD TABLE Unloads a table in SQL format. UNLOAD DATABASE Unloads a database in SQL format. SHOW MEMORY Report memory used by the Java virtual machine. RUN Run a SQL script from the file. RUNJDBCMETA ( args... ) Run a method in the JDBC database meta data. -- Single line comment. /* ... */ multiple line comment. EXIT/QUIT Exit program. SQL> delete from student; SQL> 1 row(s) affected SQL> exit; SQL> EXIT; skywolf:~/tomcat/tomcat/webapps/tmp%java -classpath .:/h/u2/csc309h/lib/pointbase/pbembedded41ev.jar:/h/u2/csc309h/lib/pointbase/pbtools41ev.jar com.pointbase.tools.toolsCommander Do you wish to create a new database? [default: N]: Select product to connect with: Embedded (E), or Server (S)? [default: E]: Please enter the driver to use: [default: [com.pointbase.jdbc.jdbcUniversalDriver]: Please enter the database URL to use: [default: [jdbc:pointbase:embedded:sample]: Username: [default: PUBLIC]: Password: [default: PUBLIC]: PointBase Commander 4.1EV EMBEDDED Interactive SQL command language. Linux/2.4.27-i686-cdf-server (C) Copyright 1998 - 2001 PointBase(R), Inc. All rights reserved. SQL> select * from student; SQL> ID NAME BIRTHDAY ------------ ------------------------------------------ ---------- 0 Rows Selected. SQL> exit; SQL> EXIT; skywolf:~/tomcat/tomcat/webapps/tmp%java -cp /u/csc309h/lib/pointbase/pbembedded41ev.jar:. DBTest select tablename from systables SYSCHECKCONSTRAINTS SYSCOLUMNPRIVILEGES SYSCOLUMNS SYSCONSTRAINTROUTINEDEPEND SYSINDEXES SYSINDEXKEYS SYSKEYCONSTRAINTCOLUMNS SYSPAGESIZEMAP SYSPARAMETERS SYSREFERENTIALCONSTRAINTS SYSROUTINEPRIVILEGES SYSROUTINES SYSSCHEMATA SYSSQLDATATYPES SYSSQLSTATEMENTS SYSTABLECONSTRAINTS SYSTABLEPRIVILEGES SYSTABLES SYSTRIGGERCOLUMNS SYSTRIGGERROUTINEDEPEND SYSTRIGGERS SYSUSERS SYSVIEWS SYSVIEWTABLES STUDENT skywolf:~/tomcat/tomcat/webapps/tmp%java -cp /u/csc309h/lib/pointbase/pbembedde d41ev.jar:. DBInteractive My friends database - main menu ------------------------------- What do you want to do? 1) Add a new friend 2) List all my friends 3) Quit Enter your choice [1|2|3]: 2 Friend #1: Radu , 123 , Toronto My friends database - main menu ------------------------------- What do you want to do? 1) Add a new friend 2) List all my friends 3) Quit Enter your choice [1|2|3]: 1 Enter new friend's name: Nan Enter new friend's phone number: 789 Enter new friend's address: Canada New friend added. My friends database - main menu ------------------------------- What do you want to do? 1) Add a new friend 2) List all my friends 3) Quit Enter your choice [1|2|3]: 2 Friend #1: Radu , 123 , Toronto Friend #2: Nan , 789 , Canada My friends database - main menu ------------------------------- What do you want to do? 1) Add a new friend 2) List all my friends 3) Quit Enter your choice [1|2|3]: 3 Goodbye. skywolf:~/tomcat/tomcat/webapps/tmp%ls DBInfo.class DBTest.class PointBase(R) Console.rc movies.class DBInfo.java DBTest.java Simple_Examples.txt movies.java1 DBInteractive.class EmbServer.log URLs.dat pointbase.ini DBInteractive.java Makefile friends$1.wal sample$1.wal DBTable.class PB-Commander.sh friends.dbn sample.dbn DBTable.java PB-Console.sh movielist web.xml skywolf:~/tomcat/tomcat/webapps/tmp%java -classpath .:/h/u2/csc309h/lib/pointbase/pbembedded41ev.jar:/h/u2/csc309h/lib/pointbase/pbtools41ev.jar com.pointbase.tools.toolsCommander Do you wish to create a new database? [default: N]: Select product to connect with: Embedded (E), or Server (S)? [default: E]: Please enter the driver to use: [default: [com.pointbase.jdbc.jdbcUniversalDriver]: Please enter the database URL to use: [default: [jdbc:pointbase:embedded:sample]: jdbc:pointbase:embedded:friends Username: [default: PUBLIC]: Password: [default: PUBLIC]: PointBase Commander 4.1EV EMBEDDED Interactive SQL command language. Linux/2.4.27-i686-cdf-server (C) Copyright 1998 - 2001 PointBase(R), Inc. All rights reserved. SQL> select tablename from systables; SQL> TABLENAME --------------------------------------------------------------------------- SYSCHECKCONSTRAINTS SYSCOLUMNPRIVILEGES SYSCOLUMNS SYSCONSTRAINTROUTINEDEPEND SYSINDEXES SYSINDEXKEYS SYSKEYCONSTRAINTCOLUMNS SYSPAGESIZEMAP SYSPARAMETERS SYSREFERENTIALCONSTRAINTS SYSROUTINEPRIVILEGES SYSROUTINES SYSSCHEMATA SYSSQLDATATYPES SYSSQLSTATEMENTS SYSTABLECONSTRAINTS SYSTABLEPRIVILEGES SYSTABLES SYSTRIGGERCOLUMNS SYSTRIGGERROUTINEDEPEND SYSTRIGGERS SYSUSERS SYSVIEWS SYSVIEWTABLES FRIENDS 25 Rows Selected. SQL>describe friends; SQL> describe friends; FRIENDS NAME CHARACTER(20) NULLABLE: NO PHONE CHARACTER(20) NULLABLE: NO ADDRESS CHARACTER(20) NULLABLE: NO SQL> select * from friends; SQL> NAME PHONE ADDRESS ---------------------- ---------------------- ---------------------- Radu 123 Toronto Nan 789 Canada 2 Rows Selected. SQL> exit; SQL> EXIT; skywolf:~/tomcat/tomcat/webapps/tmp%cd ../jdbc jdbc.tar jdbc/ skywolf:~/tomcat/tomcat/webapps/tmp% cd ../jdbc/WEB-INF/classes/ skywolf:~/tomcat/tomcat/webapps/jdbc/WEB-INF/classes% ls DBInfo.class SQLGateway.class movielist pb.sh DBInfo.java SQLGateway.java movielist$1.wal pointbase.ini EmbServer.log Trivial.class movielist.dbn sample$1.wal Makefile Trivial.java movies.class sample.dbn PointBase(R) Console.rc URLs.dat movies.java skywolf:~/tomcat/tomcat/webapps/jdbc/WEB-INF/classes% cat pointbase.ini database.home=/h/u3/t4/00/t4niunan/tomcat/tomcat/webapps/tmp transaction.isolationlevel=TRANSACTION_READ_COMMITTED database.pagesize=4096 cache.size=2063 sort.size=1024 skywolf:~/tomcat/tomcat/webapps/jdbc/WEB-INF/classes%cp pointbase.ini ../../../../bin/. cp: overwrite `../../../../bin/./pointbase.ini'? y skywolf:~/tomcat/tomcat/webapps/jdbc/WEB-INF/classes%javac SQLGateway.java skywolf:~/tomcat/tomcat/webapps/jdbc/WEB-INF/classes% ls -l SQLG SQLGateway.class* SQLGateway.java* skywolf:~/tomcat/tomcat/webapps/jdbc/WEB-INF/classes% ls -l SQLGateway.class -rwx------ 1 t4niunan ta 3398 Jul 21 23:50 SQLGateway.class skywolf:~/tomcat/tomcat/webapps/jdbc/WEB-INF/classes%cd ../../../../bin/ skywolf:~/tomcat/tomcat/bin% ./start.sh using existing server.xml file... Using CATALINA_BASE: /h/u3/t4/00/t4niunan/tomcat/tomcat Using CATALINA_HOME: /u/csc309h/lib/tomcat-5.0.27 Using CATALINA_TMPDIR: /h/u3/t4/00/t4niunan/tomcat/tomcat/temp Using JAVA_HOME: /local/lib/java Using JPDA_TRANSPORT: Using JPDA_ADDRESS: skywolf:~/tomcat/tomcat/bin% mozilla & skywolf:~/tomcat/tomcat/bin% ./start.sh using existing server.xml file... Using CATALINA_BASE: /h/u3/t4/00/t4niunan/tomcat/tomcat Using CATALINA_HOME: /u/csc309h/lib/tomcat-5.0.27 Using CATALINA_TMPDIR: /h/u3/t4/00/t4niunan/tomcat/tomcat/temp Using JAVA_HOME: /local/lib/java Using JPDA_TRANSPORT: Using JPDA_ADDRESS: skywolf:~/tomcat/tomcat/bin% ./stop.sh Using CATALINA_BASE: /h/u3/t4/00/t4niunan/tomcat/tomcat Using CATALINA_HOME: /u/csc309h/lib/tomcat-5.0.27 Using CATALINA_TMPDIR: /h/u3/t4/00/t4niunan/tomcat/tomcat/temp Using JAVA_HOME: /local/lib/java Using JPDA_TRANSPORT: Using JPDA_ADDRESS: skywolf:~/tomcat/tomcat/bin%exit logout Connection to cdf.toronto.edu closed.