Para executar o programa NsSample:
java org.apache.derby.tools.sysinfoEste comando mostra os arquivos jar do Derby presentes no caminho de classes, assim como suas respectivas vers??es.
java nserverdemo.NsSampleSe a execu????o do programa for bem-sucedida, ser?? recebida uma sa??da semelhante ?? mostrada a seguir:
Using JDBC driver: org.apache.derby.jdbc.ClientDriver Derby Network Server created [NsSample] Unable to obtain a connection to network server, trying again after 3000 ms. O servidor est?? pronto para aceitar conex??es na porta 1621. N??mero da conex??o: 1. [NsSample] Derby Network Server started. [NsSample] Sample Derby Network Server program demo starting. Please wait ..................... N??mero da conex??o: 2. [NsSampleWork] Begin creating table - SAMPLETBL and necessary indexes. [NsSampleClientThread] Thread id - 1; started. [NsSampleWork] Thread id - 1; requests database connection, dbUrl =jdbc:derby:NSSampledb; [NsSampleClientThread] Thread id - 2; started. [NsSampleWork] Thread id - 2; requests database connection, dbUrl =jdbc:derby://localhost:1621/NSSampledb;create=true; N??mero da conex??o: 3. [NsSampleWork] Thread id - 2; deleted 1 row with t_key = 9631 [NsSampleWork] Thread id - 2; deleted 1 row with t_key = 9595 [NsSampleWork] Thread id - 2 selected 1 row [754,Derby29 ,4.0290892E7,9389] [NsSampleWork] Thread id - 2; updated 1 row with t_key = 9389 [NsSampleWork] Thread id - 2; inserted 1 row. [NsSampleWork] Thread id - 2; deleted 1 row with t_key = 9476 [NsSampleWork] Thread id - 2 selected 1 row [51,Derby29 ,4.0290892E7,9389] [NsSampleWork] Thread id - 2; deleted 1 row with t_key = 9389 [NsSampleWork] Thread id - 2 selected 1 row [486,Derby25 ,6.138386E23,9383] [NsSampleWork] Thread id - 2; inserted 1 row. [NsSampleWork] Thread id - 2; closed connection to the database. [NsSampleClientThread] Thread id - 2; finished all tasks. [NsSampleWork] Thread id - 1; deleted 1 row with t_key = 9383 [NsSampleWork] Thread id - 1 selected 1 row [948,Derby33 ,7609340.0,9100] [NsSampleWork] Thread id - 1 selected 1 row [948,Derby33 ,7609340.0,9100] [NsSampleWork] Thread id - 1 selected 1 row [948,Derby33 ,7609340.0,9100] [NsSampleWork] Thread id - 1; updated 1 row with t_key = 9100 [NsSampleWork] Thread id - 1 selected 1 row [54,Derby33 ,7609340.0,9100] [NsSampleWork] Thread id - 1 selected 1 row [54,Derby33 ,7609340.0,9100] [NsSampleWork] Thread id - 1 selected 1 row [54,Derby33 ,7609340.0,9100] [NsSampleWork] Thread id - 1; updated 1 row with t_key = 9100 [NsSampleWork] Thread id - 1 selected 1 row [55,Derby33 ,7609340.0,9100] [NsSampleWork] Thread id - 1; closed connection to the database. [NsSampleClientThread] Thread id - 1; finished all tasks. [NsSample] Shutting down network server. N??mero da conex??o: 4. Encerramento bem-sucedido. [NsSample] End of Network server demo.