Service Virtualization

  • 1.  JDBC connection now working

    Posted Mar 18, 2019 07:17 PM

    Hi,

     

    I am using Devtest10.3 to read values from Maria DB(Mysql tool). I am using step "Read Rows from a JDBC Table" . I have specified the password and all other parameters. 

     

    When I am running the test locally it is working fine and I am able to create connection through JDBC. However, if the test is running thorugh command prompt or build.xml (ANT), I am getting below error :

     

    Standard Output from JUnitRunLISA

    java.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'username'@'machine name' (using password: NO)

    It seems it is not picking the password. Require urgent help.


  • 2.  Re: JDBC connection now working

    Broadcom Employee
    Posted Mar 19, 2019 04:58 PM

    How are you executing this from the command line?

    Is this through command line on the same machine you tested locally?



  • 3.  Re: JDBC connection now working

    Posted Mar 19, 2019 07:09 PM

    Hi Marcy,

     

    It is actually working now with command line through Test Runner but it is not working through Ant build.xml.

     

    Also, is there a way we can parameterize the password in "Read Rows from a JDBC Table" step becaise if the password change tomorrow, I would have to go to all scripts manually and change the password.. Can it be defined at a single place ?



  • 4.  Re: JDBC connection now working

    Posted Mar 19, 2019 07:09 PM

    To add here is I am running on local