Service Virtualization

  • 1.  Getting Closed Connection error

    Posted Jan 14, 2017 08:22 PM

    Hi,

    I have created a VS and deployed it to VSE. And the service runs without any issues for some time(May be 2 hours). VS is getting error ed out and getting following error.

     

     

     

     

    ============================================================================

    | Exception:

    ============================================================================

    | Message:     Error doing random data sets

    ----------------------------------------------------------------------------

    | Trapped Exception: Database query problem

    | Trapped Message:  

     

    ============================================================================

    | Exception:

    ============================================================================

    | Message:     Database query problem

    ----------------------------------------------------------------------------

    | Trapped Exception: Closed Connection

    | Trapped Message:   java.sql.SQLRecoverableException: Closed Connection



  • 2.  Re: Getting Closed Connection error

    Posted Jan 16, 2017 03:57 AM

    Hi Narasimha,

     

    It seems to be Virtual Service related problem due to data sets, can you let me know which is the protocol your using to create/ what is the protocol in your Virtual Model file ?

     

    Thanks,

    Abhi



  • 3.  Re: Getting Closed Connection error

    Posted Jan 17, 2017 08:10 PM

    Hi Abhi,

    I have created VS from scratch.



  • 4.  Re: Getting Closed Connection error

    Posted Jan 18, 2017 04:19 AM

    Is their any datasets involved in your Model file? If yes, then which type of datasets your using it?

     

    Thanks,

    Abhi



  • 5.  Re: Getting Closed Connection error

    Posted Jan 18, 2017 11:54 PM

    Hi Abhi,

    I am using "Read Rows from a JDBC table" Data set.



  • 6.  Re: Getting Closed Connection error

    Posted Jan 19, 2017 03:26 AM

    Hi Narasimha,

     

    From the error we can get to know that it's due to Data set.

     

    What is the query you have wrote like(don't paste actual query) what its trying to query from DB? Because in error it says "Database query problem".

    Let me know about it.

     

    Thanks,

    Abhi



  • 7.  Re: Getting Closed Connection error

    Posted Jan 22, 2017 06:47 PM

    Hi Abhi,

     

    I am using simple query as follows

     

    select * from {{Table name}}