It would help if we could see the contents of the password field. I assume you have set it to ${secpass.something.plaintext}, where "something" is the name of a password in your stored passwords that has the "Permit use via context variable reference" checkbox ticked. In the following screenshots, I set a stored password called "testpwd" to 7layer, which is the password for my ssg db, then referenced it in the jdbc connection by password reference. The test button worked fine.
As for the locking out, that is probably due to a configuration at the DB that locks out a user with too many failed attempts to connect. If you are not sending the right password (or the literal context variable string '${secpass.something.plaintext}', which is my suspicion), then your tests will lock you out.
------------------------------
Jay MacDonald - Adoption Architect - Broadcom API Management (Layer 7)
------------------------------
Original Message:
Sent: 06-30-2020 08:26 AM
From: Pavansai C
Subject: CA API Gateway- JDBC Connection issue
UKB R67 siteminder changes UKB R67 siteminder changes
Hi There,
We are getting the below error when trying to test the connection.