Service Virtualization

Expand all | Collapse all

Driver based JDBC

  • 1.  Driver based JDBC

    Posted 01-21-2019 06:43 AM

    Hi There,

     

    I need to virtualize Driver based JDBC traffic which is upon SQL server,

    i reffered devtest doc on same. but not getting any cluw.

     

    Can we virtualize using RR pair as live env. is often down.

    If Yes, what could be the format of req and rsp file.

    I have an output response file which is an xml data, but not sure what could be the input request as its and sql query.

     

    Thanks,

    Sabir



  • 2.  Re: Driver based JDBC

    Posted 01-21-2019 10:18 AM

    Take a look at these links which refer to Agent virtualization:

    https://communities.ca.com/message/242157227-re-jdbc-virtualization-using-ca-devtest?commentID=242157227#comment-2421572…  

    Agent-based JDBC virtualization 

    Pay particular attention to abrsh01 notes. I copied them here: 

    1. JDBC Virtualization is not meant to replace a database. It is meant to handle a few small calls. 
    2. JDBC Virtualization can be very tricky. The JDBC protocol is very chatty and there are many more messages between the driver and DB than most people realize. 

    My suggestion is to research if the virtualization can be done at the business object layer rather than the JDBC layer. It will be simpler than trying to virtualize in the JDBC layer.  



  • 3.  Re: Driver based JDBC

    Posted 01-24-2019 03:34 AM

    Thank you,
    Will have a look