Forum Discussion

mogranovitch's avatar
mogranovitch
Occasional Contributor
3 years ago

Use of global/project property on setting Database Configuration

Hi guys, I'd like to stop using hard coded values for setting Password on each Database configuration: I have multiple databases for multiple projects/environments and passwords changing every month...
Configuration
Function Tests
Test Setup
mogranovitch's avatar
mogranovitch
Occasional Contributor

Hi Richie!

Thank you for your response.

Here are two screenshots of the PostgreSQL DB config screen:

1. Working with hard-coded password

 

2. Not working with parameterized password value. I tried both 'as is' value' and percent-encoded:

 

 

Thanks again!

richie's avatar
richie
Community Hero
3 years ago
Hey mogranovitch,

I dont think i used those property fields....i cant be sure...but i dont think i did.

Im curious, if in say the password property youve setup, instead of using an expansion, if you hardcode the value instead, do you connect ok? I think yousay you did, but just wanted to confirn

Have you tried just adding expansions into the dynamically generated fields (generated relative to which driver you specify) instead?

So in my sqlserver connection, when i select the driver, i get a host, and password, dbname and i think thats it (going off memory here)

So...in my sqlserver (if i did have a working db connection) in the password field did you try adding the expansion in there? i.e. ${#Project#password}

I "think" thats what i did when i did this before about 4 years ago. I had to switch to 2 different databases (local and remote) depending on which environment and whatever i did, it worked like a charm!

Cheers

Rich
  • mogranovitch's avatar
    mogranovitch
    Occasional Contributor
    3 years ago

    Hi Rich!

     

    Thanks again!

     

    For your first question the answer is yes - it works fine if password is hard-coded.

    For you second question the answer is no:

    I had problems connecting to postgreSQL using user & password in the JDBC drivers configuration and was advised by Smartbear to not use it there.

    I might try again to add new postgreSQL driver with "?user=<USER>&password=<PASSWORD>" at the end and try to use parameter there.

     

    Regards,

    Mikhail