Previous Next JavaScript must be enabled to correctly display this content

## Running `CountTableRows` When the Store is Secure and a Password File is Used

If you will be running `CountTableRows` against a secure store such as that deployed in the Deploying a Secure Store appendix, and you have compiled, built, and packaged `CountTableRows` and all the necessary artifacts in the manner described in the Model For Building & Packaging Secure Clients appendix, then `CountTableRows` can be run against the secure store by typing the following at the command line of the Hadoop cluster's access node:

    export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:\
        /opt/oracle/kv-ee/lib/kvclient.jar:\
        /opt/oracle/nosql/apps/examples/CountTableRows-pwdServer.jar

    cd /opt/oracle/nosqlapps/kv

    hadoop jar examples/CountTableRows-pwdClient.jar \
        hadoop.table.CountTableRows \
        -libjars /opt/oracle/kv-ee/lib/kvclient.jar,\
        /opt/oracle/kv-ee/lib/sklogger.jar,\
        /opt/oracle/kv-ee/lib/commonutil.jar,\
        /opt/oracle/kv-ee/lib/failureaccess.jar,\
        /opt/oracle/kv-ee/lib/antlr4-runtime-nosql-shaded.jar,\
        /opt/oracle/kv-ee/lib/jackson-core.jar,\
        /opt/oracle/kv-ee/lib/jackson-databind.jar,\
        /opt/oracle/kv-ee/lib/jackson-annotations.jar,\
        /opt/oracle/nosql/apps/examples/CountTableRows-pwdServer.jar \
        example-store \
        kv-host-1:5000 \
        vehicleTable \
        /user/example-user/CountTableRows/vehicleTable/<000N> \
        example-user-client-pwdfile.login \
        example-user-server.login

The following items in the command lines above are the client side artifacts of `CountTableRows`,

    examples/CountTableRows-pwdClient.jar

    example-user-client-pwdfile.login

whereas the following items are the server side artifacts.

    /opt/oracle/nosql/apps/examples/CountTableRows-pwdServer.jar

    example-user-server.login

Rather than using an Oracle Wallet, the mechanism used for storing the user's password is a password file, which is contained in the `CountTableRows-pwdServer.jar` artifact.