5. Network Server + Network Client

(1) NetworkServerの起動

サーバ側を起動する前に、sampleデータベースの保存ディレクトリへ移動しておく。

cd C:\opt\Cloudscape_10.1\demo\databases
C:\opt\Cloudscape_10.1\demo\databases>C:\opt\Cloudscape_10.1\frameworks\NetworkServer\bin\setNetworkServerCP.bat
C:\opt\Cloudscape_10.1\demo\databases>C:\opt\Cloudscape_10.1\frameworks\NetworkServer\bin\startNetworkServer.bat

(2) NetworkClientの起動

C:\>C:\opt\Cloudscape_10.1\frameworks\NetworkServer\bin\setNetworkClientCP.bat
C:\>C:\opt\Cloudscape_10.1\frameworks\NetworkServer\bin\ij.bat
C:\>java org.apache.derby.tools.ij
ij version 10.1
ij> connect 'jdbc:derby://localhost:1527/sample';
ij> set schema 'SAMP';
0 rows inserted/updated/deleted
ij> SELECT * FROM EMPLOYEE;
EMPNO |FIRSTNME    |&|LASTNAME       |WOR&|PHO&|HIREDATE  |JOB     |EDLEV&|SEX |BIRTHDATE |SALARY     |BONUS      |COMM

























































































































































































































































-




























































































































000010|CHRISTINE   |I|HAAS           |A00 |3978|1965-01-01|PRES    |18    |F   |1933-08-24|52750.00   |1000.00    |4220.00
000020|MICHAEL     |L|THOMPSON       |B01 |3476|1973-10-10|MANAGER |18    |M   |1948-02-02|41250.00   |800.00     |3300.00

32 rows selected
ij> exit;

C:\>

(3) NetworkServerの停止

停止用にコマンドプロンプトを立ち上げる。

C:\>C:\opt\Cloudscape_10.1\frameworks\NetworkServer\bin\setNetworkServerCP.bat
C:\>C:\opt\Cloudscape_10.1\frameworks\NetworkServer\bin\stopNetworkServer.bat