1 Reply Latest reply on Apr 19, 2017 8:27 PM by thatJeffSmith-Oracle

    How can I stop CLI tests prompting for a password? (SQL Developer 4.2)

    GJW1
    GJW1 Apr 19, 2017 8:23 PM

      Hi all,

       

      I am trying to create a "headless" SQL developer install in order to run tests against an existing repository and hook into my Jenkins instance.

       

      Following the instructions in Creating a connection using CLI fails , I have created two connections. 

      sdcli migration -actions=mkconn -connDetails=unit_test_repos_JIRA:oracle:unit_test_repos/password:jira:1521:jira
sdcli migration -actions=mkconn -connDetails=hr_JIRA:oracle:hr/password:jira:1521:jira

       

      I execute the tests like this:

      sdcli unittest -run -test -name V_CREATE_VIEW_FAILURE -repo unit_test_repos_JIRA -db hr_JIRA -log 1

       

      However, I always get prompted for the passwords when I execute the tests:

      [oracle@jira bin]$ sdcli unittest -run -test -name V_CREATE_VIEW_FAILURE -repo unit_test_repos_JIRA -db hr_JIRA -log 1
 Oracle SQL Developer
 Copyright (c) 1997, 2017, Oracle and/or its affiliates. All rights reserved.

Password for unit_test_repos_JIRA?
Password for hr_JIRA?
UT_SUCCESS
Command Completed.

       

      How can I save the passwords along with the connection and remove the prompts?

       

      Thanks in advance for any help.

      Graham