Service Virtualization

Expand all | Collapse all

DB2 sql exception 

  • 1.  DB2 sql exception 

    Posted 08-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 

    Posted 08-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 

    Posted 08-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 09-05-2018 10:55 AM

    Hello Shanmuga,

     

    Did Marcy and Shiney's comments help you?

     

    Heloisa



  • 5.  Re: DB2 sql exception 

    Posted 11-15-2018 06:48 AM

    yes it solved