Pointbase full Java Database Server Option mode

A feature rich full java database named pointbase is included in the

"Sun Java[TM] System Application Server Platform Edition 8"

Since J2EE version 1.4 IBM's Cloudscape database is replaced by pointbase. The pointbase database can be used as an embedded database from your java application or in client/Server Mode. To start the Pointbase database in the so called "server option mode" you can use a command like

java -Djava.security.manager -Djava.security.policy="%AS_POINTBASE_SAMPLESDB%\databases\pointbase.policy" -classpath ".;%AS_POINTBASE%\lib\pbembedded.jar" -Ddatabase.home="%AS_POINTBASE_SAMPLESDB%\databases" -Dpointbase.ini="%AS_POINTBASE_SAMPLESDB%\databases\pointbase.ini" -Dpointbase.lib="%AS_POINTBASE%/lib" com.pointbase.net.netServer


If you start the database server without parameters it will start listening on port 9092. If you append a commandline parameter /help you will see a message with all possible parameters:

Options:

/help - display this message.
/win - show a GUI windows.
/file - log the display level data to a file.
/d: - set message display level ( 0 thru 3).
/port: - listen on the specified port.
/noconsole - start the server with no prompt. Useful in as background thread
/pointbase.ini: Loads the ini properties from the file needed for PointBase Server

For a non-GUI server, the following commands may be used:

Key Meaning
------ -------
x or q stops the server and quits
c prints the list of current active connections
l prints the list of current locks in the system
h or ? prints this message
v prints the server version

For example you can add /port:4711 to start the server listening on port 4711.

I used this possibility to start more than one database server on different ports and bundle them to a database cluster by using the c-jdbc driver available from c-jdbc homepage