Forum Discussion

M_McDonald's avatar
M_McDonald
Super Contributor
16 years ago

Option to make JDBC password transient or separate keystore.

I would like to avoid storing the JDBC password in the project file, so it would be great if there was an option to keep the password only while the project is open.

Another option would be to use a keystore separate from the project file.

This is important to me because we share projects among various people and they each need to use their own username and password.
  • M_McDonald's avatar
    M_McDonald
    Super Contributor
    16 years ago
    But even if I set the password via a script, won't the value be saved with the project?
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    16 years ago
    Well, I thought that the script would just read from a file on the computer that the project is running on, so each computer will ahve a file with its own password/username.

    /Nenad
    http://eviware.com
  • M_McDonald's avatar
    M_McDonald
    Super Contributor
    16 years ago
    I think I see what you mean now.

    I have solved the problem for myself in 2 ways:


    • Using a dialog box to collect the username and password on opening the project and storing them as metaClass variables, then putting an expansion referencing these variables in the JDBC connection.

    • Using the jTDS driver and the native dll for trusted access to SQL Server (Windows only.)


    Thanks.