0: jdbc:farrago:rmi://localhost> set schema 'test';
No rows affected (0.032 seconds)
0: jdbc:farrago:rmi://localhost> create global temporary table gtt (id integer primary key, textvalue varchar(20)) on commit preserve rows;
No rows affected (0.234 seconds)
0: jdbc:farrago:rmi://localhost>insert into gtt values(2,'a test 2');
1 row affected (0.391 seconds)
0: jdbc:farrago:rmi://localhost> insert into gtt values(1,'a test 1');
1 row affected (0.25 seconds)
0: jdbc:farrago:rmi://localhost> select * from gtt;
+-----+------------+
| ID | TEXTVALUE |
+-----+------------+
| 1 | a test 1 |
| 2 | a test 2 |
+-----+------------+
2 rows selected (0.281 seconds)
0: jdbc:farrago:rmi://localhost> !quit
Closing: de.simplicit.vjdbc.VirtualConnection

C:\eigenbase\eigenbase-0.7.3\bin>sqllineClient
Connecting to jdbc:farrago:rmi://localhost
Connected to: Eigenbase Data Management System (version 0.7.3)
Driver: FarragoJdbcDriver (version 0.7)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
sqlline version 1.0.4-jh by Marc Prud'hommeaux
0: jdbc:farrago:rmi://localhost> set schema 'test';
No rows affected (0.032 seconds)
0: jdbc:farrago:rmi://localhost> select * from gtt;
Error: java.lang.NullPointerException: null (state=,code=0)
0: jdbc:farrago:rmi://localhost>

(following notes from http://farrago.sourceforge.net/status.html)