At this point, you have a database server, but you have no database to store your data. To create a database, we will connect to the network server through the ij interactive JDBC tool and create our initial tables.
- 1. In a new terminal window, change directories to be in derby/frameworks/NetworkServer/bin/ again.
- 2. Open up setNetworkClientCP.ksh in a text editor and add the DERBY_INSTALL=../../.. line.
- 3. Issue the following commands to set your client environment and connect to the Derby network server:
bash$ . setNetworkClientCP.ksh bash$ sh ij.ksh ij version 10.1 ij> connect 'jdbc:derby://localhost:1527/MYDB;create=true';
You should now see a directory called MYDB.