Service Virtualization

  • Private Community
Back to discussions
Expand all | Collapse all

Is there a property that can be set to limit SQL attempts to 1 try?

  • 1.  Is there a property that can be set to limit SQL attempts to 1 try?

    Posted Apr 05, 2017 10:49 AM

    We have a policy where if you have the wrong password X times, it'll lock you out of a Database.  



  • 2.  Re: Is there a property that can be set to limit SQL attempts to 1 try?
    Best Answer

    Posted Apr 05, 2017 06:27 PM

    As far as I know, there is no such feature available in CA DevTest. However, my team faced some challenges where CA LISA was continuously attempting connections to the database so we developed our custom step to validate DB connection before SQLs execution. 

     

    Attached jar supports DB2 connection. It will help you if you are trying to connect to DB2. Let me know in case you want to connect with other databases. I'll make changes and share updated jar.

     

    To use this custom solution, copy attached jar to hotdeploy folder and look for new custom step inside custom steps/ extensions [right click and add step]. This step can be used just before in-built database connection step.

     

    Thanks,

    Kumar



  • 3.  Re: Is there a property that can be set to limit SQL attempts to 1 try?

    Posted Apr 06, 2017 07:28 AM

    Thank you so much for the reply, I'll give it a shot.