Forum Discussion

chikki78's avatar
chikki78
Occasional Contributor
6 years ago

JDBC DB2 schema option missing

JDBC DB2 schema option missing while trying to add the details.

Please find the attachment.

 

 

    • richie's avatar
      richie
      Community Hero
      6 years ago

      Hey chikki78 

       

      I'm sorry - I'm not clear what the problem is - are you saying the connection string you want isn't in the listing?

       

      I can see a connection option in yoru attached screenshot - but I don't know what it's supposed to represent.

       

      also in the screenshot the host is set as your local loopback ip address.  Surely the DB2 instance isn't local to your machine where  you're running ReadyAPI!?

       

      Cheers

       

      richie

      • chikki78's avatar
        chikki78
        Occasional Contributor
        6 years ago

        Hi Richie,

        in DB2 we have schema option available right.where i need to provide those details.

         

        In Groovy we can provide by below example. my question is how to provide the schema option.I tried to set it in properties but it did not helped me.

         

        Example in groovy:

        sql = Sql.newInstance('jdbc:db2://10.x.x.x:50000/dbname:currentSchema=MY_QA;','dbuser', 'dbpwd','com.ibm.db2.jcc.DB2Driver');

        where i need to priovide the below part

        "currentSchema=MY_QA"