How to run SQL queries on the Derby Database for WCC

Document ID : KB000039384
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary:

These are steps on how to connect to the Derby DB and run SQL queries from the command prompt.

 

Instructions:

For Linux

=========

1) cd $CA_WCC_INSTALL_LOCATION/bin

2) ./wcc_config.sh -u ejmcommander -p ejmcommander --displaydb

Logging in as ‘ejmcommander’ – SUCCESS

 

Database server connection

Host Name: localhost

Port: 1527

Database instance name: WCC_MAIN

Platform: derby

User: wcc

Password: *****

 

3) cd ../derby/lib

4) java -jar derbyrun.jar ij

5) Connect ‘jdbc:derby://localhost:1527/WCC_MAIN’ user ‘wcc’ password ‘*****’;

(Password will be what you chose during install)

 

After you have connected to the database, you will see the ij prompt and be able to use SQL queries.

For example:

ij> show tables;

ij> describe MON_JOB;

ij> select * from MON_JOB;

 

For Windows

===========

1) cd %CA_WCC_INSTALL_LOCATION%\bin

2) wcc_config.bat -u ejmcommander -p ejmcommander --displaydb

Logging in as ‘ejmcommander’ – SUCCESS

 

Database server connection

Host Name: localhost

Port: 1527

Database instance name: WCC_MAIN

Platform: derby

User: wcc

Password: *****

 

3) cd ..\derby\lib

4) java -jar derbyrun.jar ij

5) Connect ‘jdbc:derby://localhost:1527/WCC_MAIN’ user ‘wcc’ password ‘*****’;

(Password will be what you chose during install)

 

After you have connected to the database, you will see the ij prompt and be able to use SQL queries.

For example:

ij> show tables;

ij> describe MON_JOB;

ij> select * from MON_JOB;