Service Virtualization

 View Only

TDM DB approach failing in Devtest 10.3

  • 1.  TDM DB approach failing in Devtest 10.3

    Posted Nov 06, 2019 03:00 AM
    Hi Team,


    We have been using TDM steps [DDVS approach] in vsm to connect to Oracle DB using provided jars from below link. It was supporting all these while for Lisa 7.5, Lisa 8.2 , Devtest 9.5, Devtest 10.1, 10.2.4 and currently we are in Devtest 10.3 version. For Devtest 10.3, recently we started facing an issue, where DB connection is frequently getting disconnected and seeing repeated DB connection failure errors in vse.logs. On restart of VSE component, we are getting  DB connectivity for sometime. ojdbc7.jar is the JDBC connector jar  which we are using. As below jars are been compiled using jdk1.6, would like to know how can we get the latest DDVS jars compiled on jdk1.8 version to support Devtest 10.3. 


    Please advice.

    Jar Reference Link:

    https://community.broadcom.com/enterprisesoftware/search?s=MetaModel-core-3.2.1&rf=%5ECommunityKey%3A94bda077-625b-4914-8ac3-c88a06c2cc23%5E

    DDVS JARS:

    lisa-ext-ddvs
    MetaModel-core-3.2.1
    MetaModel-csv-3.2.1
    MetaModel-excel-3.2.1
    MetaModel-full-3.2.1
    MetaModel-jdbc-3.2.1
    MetaModel-mongodb-3.2.1


    Error from vse.log:

    Target exception: java.lang.RuntimeException: Internal Errororg.eobjects.metamodel.MetaModelException: Could not determine default schema name: Closed Connection
    in inline evaluation of: ``if (incomingRequest.getArguments().get("param")!=null) { query = TDMQuery . . . '' at line number 6
    at bsh.BshScriptEngine.evalSource(BshScriptEngine.java:97)
    at bsh.BshScriptEngine.eval(BshScriptEngine.java:61)
    at javax.script.AbstractScriptEngine.eval(AbstractScriptEngine.java:264)
    at com.itko.lisa.test.ScriptExecHandler.executeScript(ScriptExecHandler.java:674)

    Regards,
    Anupam