Forum Discussion

TCal's avatar
TCal
New Contributor
4 years ago

We’ve updated Microsoft JDBC drivers for SQL Server that are bundled with ReadyAPI

I Installed ReadyApi 3.9.2 and none of my jdbc connections will work on various projects.  The common Complaint is: Failed to get a connection for the specified properties; com.microsoft.sqlserver.j...
Assertions
Data-Driven Testing
richie's avatar
richie
Community Hero
4 years ago

Hey TCal,

 

Sorry, just to be clear. Are you saying you upgraded your ReadyAPI! version to v3.9.2 and since upgrading from ReadyAPI version 'X' to ReadyAPI v3.9.2, your SQLServer connections no longer work, or do you mean something different?

 

Is the ReadyAPI version the only thing that changed?

 

ReadyAPI v3.9.2 has Java 16 bundled with it (according to what ive just read), and if youre saying your previous JDBC/JTDS connections worked fine on a previous ReadyAPI version, but after upgrading to v3.9.2 the db connections are broken then thats likely to be the cause of your issue.  I.e. the version of Java being used differs to version prior to the upgrade

 

Your JDBC/JDTS .jars use specific versions of Java and so youll need to ensure the version of Java running on your machine is the version that is supported by your JDBC/JTDS drivers.

 

Whenever setting up a db connection i determine the following:

 

1. What version of the RDBMS (Oracle 12? SQLServer 16?) am i connecting to?

2. What JDBC driver files are required to my specific database version?

3. What type of authentication will i be using to connect? Windows? SQL? MIxed mode?

4. What versions of JDBC drivers are required to connect to the specific version of RDBMS?

5. What version of Java supports the JDBC drivers i need to use to connect to my DB?

6. What are the connection string/url properties/parameters i need to set, to configure the connection to my DB. There are standard ones for each RDBMS, but there are additional optionals that have to be set correctly before successful connection can be made.  The DBA who administers your DB would be a ble to tell you this, but these config parms in your connection string wouldnt have changed based on changing readyapi version - theyd only change if there was a change at the server end of things.

 

Oh.....i dont know if you get 32bit as well as 64bit ReadyAPI anymore, but your version of Java has to match the "bit type". So if using 32bit ReadyAPI, then your Java must be 32bit.  if you're using 64bit ReadyAPI, then your Java needs to be 64bit

 

cheers,

 

rich

  • TCal's avatar
    TCal
    New Contributor
    4 years ago

    Thank Rich,

     

    Yes you are correct in understanding my issue. Upgrade from ReadyAPI 3.9.1 to 3.9.2 and jdbc connections are failing.  My understanding is that readyApi uses a self-contained Java - unless you specifically tell it to use your local installation.  

     

    I will see about updating Java - but considering all you mention about java - it has been working with ReadyAPI for at least the last 10 version upgrades.  I am on Windows 10 and use 64 bit versions of applications when available. 

     

    My current java version is:

    java version "1.8.0_161"
    Java(TM) SE Runtime Environment (build 1.8.0_161-b12)
    Java HotSpot(TM) Client VM (build 25.161-b12, mixed mode, sharing)

     

    Tom