locked
Elastic Pool across JDBC transparent to application RRS feed

  • Question

  • Hello,

    Our application uses JDBC to talk to Azure SQL (using the https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server official driver). We have customers asking whether our application will be supported on an Azure SQL Elastic Pool. Would we need to modify the application in anyway to operate successfully with a SQL Elastic Pool, or will existing JSBC operations continue to run as if connected to a single Azure SQL instance? Clearly we'd have to provision the Elastic Pool first.

    Thanks,

    Ben

    Monday, March 6, 2017 5:13 PM

All replies

  • Hello,

    To my knowledge, there is no need to change your applications for elastic pools, if they having working fine with SQL Azure already. As you say, it is transparent for the application.

    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, March 6, 2017 5:40 PM
  • Alberto is correct, no connection string changes to your application are required to take advantage of Elastic Pools on the backend for managing performance and price.

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, April 5, 2017 10:07 PM