HSQLDB example source code file (TestSelfTempTable2.txt)

This example HSQLDB source code file (TestSelfTempTable2.txt) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - HSQLDB tags/keywords

autocommit, commit, commit, connect, connect, password, password, purposefully, sa, set, shutdown, this, user, user

The HSQLDB TestSelfTempTable2.txt source code

-- This script depends on TestSelfTempTable1.txt to set up the objects tested.

SET AUTOCOMMIT false;
/*c0*/SELECT * FROM tmptbl1;
/*c0*/SELECT * FROM tmptbl2;
CONNECT USER altuser2 PASSWORD password;
/*e*/SELECT * FROM tmptbl1;
/*e*/SELECT * FROM tmptbl2;
CONNECT USER altuser1 PASSWORD password;
/*c0*/SELECT * FROM tmptbl1;
/*c0*/SELECT * FROM tmptbl2;
/*u1*/INSERT INTO tmptbl1 VALUES(1);
/*u1*/INSERT INTO tmptbl1 VALUES(2);
/*c2*/SELECT * FROM tmptbl1;
COMMIT;
-- Purposefully not committing these inserts
/*c0*/SELECT * FROM tmptbl1;
/*u1*/INSERT INTO tmptbl2 VALUES(1);
/*u1*/INSERT INTO tmptbl2 VALUES(2);
/*c2*/SELECT * FROM tmptbl2;

CONNECT USER SA password "";
SHUTDOWN;