cancel
Showing results for 
Search instead for 
Did you mean: 

How to get database password in ReadyAPI?

SOLVED
rajs2020
Frequent Contributor

How to get database password in ReadyAPI?

I have some JDBC tasks which have a working database connection. I want to connect to a database with a groovy script but cannot do it due to an authentication error.

The connection string of the database has the username=OneDbUser and password = password_value. In the password field, the password field is hidden behind circles. I could not connect to the database with a groovy script or with the GUI client for the database. In both cases, I used the username and password given in the connection string. It looks like the password in connection string is different from the hidden password in the password field.

 

So, how do I find out what is the actual password? How do I connect to a DB with a groovy script?

 

1 ACCEPTED SOLUTION

Accepted Solutions
nmrao
Community Hero

Re: How to get database password in ReadyAPI?

If it works from jdbc step, then is it possible to open project xml and see if not tried already?
While this question is not directory related to ReadyAPI, I understand, please check with DBA to get it or reset. Password had to reset time to time.

You can get lot of sample for db connection on the net using groovy.


Regards,
Rao.

View solution in original post

2 REPLIES 2
nmrao
Community Hero

Re: How to get database password in ReadyAPI?

If it works from jdbc step, then is it possible to open project xml and see if not tried already?
While this question is not directory related to ReadyAPI, I understand, please check with DBA to get it or reset. Password had to reset time to time.

You can get lot of sample for db connection on the net using groovy.


Regards,
Rao.

View solution in original post

nmrao
Community Hero

Re: How to get database password in ReadyAPI?

By the way, it is not mentioned which database is used.
Depending on it, the connection string will change and respective driver library has to used.
I believe, the tool has support for some databases out-of-the-box(please check documentation) or $READYAPI_HOME/lib directory.
If a particular library is not supported OOTB, one can download the respective driver , copy it under $READYAPI_HOME/bin/ext and restart the tool. This is applicable to both jdbc step / groovy script step as well.

Since you mentioned that ablee to connect to db, you may not need to download any drivers. But that is just information only.


Regards,
Rao.
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors