Execu????o do programa exemplo NsSample

Para executar o programa NsSample:

  1. Abra a linha de comando e torne o diret??rio %DERBY_HOME%\demo\ o diret??rio corrente, onde %DERBY_HOME% ?? o diret??rio onde o Derby foi instalado.
  2. Defina a vari??vel de ambiente CLASSPATH incluindo o diret??rio corrente ("."), e incluindo tamb??m os seguintes arquivos jar para que se possa utilizar o Network Server e o driver cliente da rede:
    derbynet.jar
    O arquivo jar do Network Server. Dever?? estar presente na vari??vel de ambiente CLASSPATH, para que se possa utilizar qualquer uma das fun????es do Network Server.
    derbyclient.jar
    Este arquivo jar dever?? estar presente na vari??vel de ambiente CLASSPATH, para que se possa utilizar o driver cliente da rede.
    derby.jar
    O arquivo jar do motor de banco de dados Derby.
    derbytools.jar
    O arquivo jar das ferramentas do Derby.
  3. A defini????o da vari??vel de ambiente CLASSPATH pode ser testada executando o seguinte comando Java:
    java org.apache.derby.tools.sysinfo
    Este comando mostra os arquivos jar do Derby presentes no caminho de classes, assim como suas respectivas vers??es.
  4. Ap??s o ambiente ter sido definido corretamente, o programa NsSample ser?? executado a partir deste diret??rio:
    java nserverdemo.NsSample
    Se 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.
    
A execu????o do programa NsSample tamb??m cria o seguinte diret??rio e arquivo:
NSSampledb
Este diret??rio cont??m o banco de dados NSSampledb.
derby.log
Este arquivo de log cont??m as mensagens de progresso e erro do Derby.