Layer7 API Management

  • Private Community

  • 1.  Test Connection Issue with SQL server in LAC

    Posted Jun 05, 2018 11:03 AM
      |   view attached

    Created an API using sql server. I observed test connection to SQL server is intermittent, for some attempts test connection is successful but frequently it gives error as shown in attachment. Please advise.



  • 2.  Re: Test Connection Issue with SQL server in LAC

    Broadcom Employee
    Posted Jun 12, 2018 08:49 AM

    Hi Rajdeep,

     

    Do you see any errors in the web server logs? (i.e: catalina for tomcat).

    I've seen these types of errors with network instability (inconsistent connections to the DB server).

     

    Could you also confirm the version of LAC, MS SQL & JDBC driver you are running?

     

    Regards,

    Joe



  • 3.  Re: Test Connection Issue with SQL server in LAC

    Broadcom Employee
    Posted Dec 17, 2018 11:50 AM

    Good afternoon,

     

    Were you able to resolve the issue? What was the final result?

     

    Sincerely,


    Stephen Hughes
    Broadcom Support