Service Virtualization

  • 1.  DB2 sql exception 

    Posted Aug 21, 2018 06:11 AM

    Hi , I have added JDBC step in the VSM and deployed the service on the server . while testing the connection in the jdbc step we are getting connection successful but while hitting the service url we are getting the below error. 

    java.sql.SQLException: Connections could not be acquired from the underlying database!

     

    This leads to socket timed out exception . Could you please advise . Same stub working with oracle driver but not working with DB2 (com.ibm.db2.jcc.DB2Driver )



  • 2.  Re: DB2 sql exception 

    Broadcom Employee
    Posted Aug 21, 2018 09:36 AM

    Can you share the entire stack trace ?  Also, what version of Devtest are you seeing this? 



  • 3.  Re: DB2 sql exception 

    Broadcom Employee
    Posted Aug 21, 2018 09:41 AM

    There is a couple of reasons why you can get this error:

     

    1. The credentials you are using are not valid with DB2.

    2. You do not have access from the VSE of where the VSM is running to the DB2 database.

     

    Is the above error showing in the vse.log?



  • 4.  Re: DB2 sql exception 

    Posted Sep 05, 2018 10:55 AM

    Hello Shanmuga,

     

    Did Marcy and Shiney's comments help you?

     

    Heloisa



  • 5.  Re: DB2 sql exception 

    Posted Nov 15, 2018 06:48 AM

    yes it solved