Service Virtualization

  • 1.  JDBC Step connection error

    Posted 09-14-2021 08:08 AM
    Hi Community,

    I'm trying to create a step to connect to the database, but when testing the connection I always come across the error below:

    Do you know what it can be? I already have the sqljdbc4-4.0 jar in my shared folder.
    Regards,
    João Paulo Ramos


  • 2.  RE: JDBC Step connection error

    Broadcom Employee
    Posted 09-14-2021 09:02 AM
    HI Ramos
             Please try the following:

    1. In case you have chosen the connection pool option, then uncheck it and try again. 

    2. Share the workstation.log file to see the complete exception

    --
    regards
    Sankar Natarajan

    This electronic communication and the information and any files transmitted with it, or attached to it, are confidential and are intended solely for the use of the individual or entity to whom it is addressed and may contain information that is confidential, legally privileged, protected by privacy laws, or otherwise restricted from disclosure to anyone else. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, you are hereby notified that any use, copying, distributing, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error, please return the e-mail to the sender, delete it from your computer, and destroy any printed copy of it.





  • 3.  RE: JDBC Step connection error

    Posted 09-14-2021 09:19 AM
      |   view attached
    Hi Sankar,

    1 . Got the same error uncheckink the connection Pool Option
    2. Attached

    Attachment(s)

    log
    workstation.log   8.54 MB 1 version


  • 4.  RE: JDBC Step connection error
    Best Answer

    Posted 09-15-2021 12:58 AM
    Hi Ramos,

    Check the connection String for your step, it should be like :
    jdbc:sqlserver://<<servername>>:<<port>>/<<db>>

    If the issue still persists please share the format for the connection string as well.

    Thanks.

    ------------------------------
    Regards,
    Vaibhav Jain
    Capgemini
    ------------------------------



  • 5.  RE: JDBC Step connection error

    Posted 09-15-2021 08:57 AM
    Hey Ramos, is this also resolved post reinstallation?

    Thanks

    ------------------------------
    Regards,
    Vaibhav Jain
    Capgemini
    ------------------------------



  • 6.  RE: JDBC Step connection error

    Posted 09-15-2021 09:08 AM
    In fact, one thing doesn't have to do with the other.
    I changed the connection string to what you recommended and it worked.


    Thank you for the assist,
    JP



  • 7.  RE: JDBC Step connection error

    Posted 09-15-2021 09:18 AM
    Glad to hear that. Thanks for the update.

    Cheers.

    ------------------------------
    Regards,
    Vaibhav Jain
    Capgemini
    ------------------------------