This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 95%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Hello All,
Requesting few information on SQL server V2019+ and Azure SQL.
We are a team who is working on Migration of IBM DB2 to Azure SQL / SQL SERVER. In DB2 we have Procedure called as JAVA STORED PROCEDURE, Where the Javacode is deployed on DB2 and java code is executed using Stored procedure.
We are checking if we have a feature in Azure SQL where we can deploy the jar or the class file of Java and execute them as stored procedure. And these procedure should take in parameters if required.
Currently we found the documentation for External libraries where we can deploy the java code by creating External Libraries in SQL SERVER 2019 and SQL SERVER 2022. Whereas, we did not find any documentation for Azure SQL.
Are the external Libraries supported with Azure SQL?
REF: [https://learn.microsoft.com/en-us/sql/language-extensions/how-to/call-java-from-sql?view=sql-server-ver16
Also to deploy the class file/jar to SQL SERVER, we have to provide the location of the jar /class file. Once the set is done, is the Created lib still looks for the jar file in that path specified or an instance is deployed to SQL server ?
Any help/information would be of a great help for us.
Thank you
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi @AKSHAY RANGA ,
Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Are the external Libraries supported with Azure SQL?
No, externals calls are only supported on SQL Server on-premise, but not on SQL Azure.
Hi @AKSHAY RANGA
Are the external Libraries supported with Azure SQL?
No. In SQL Server 2017, R language and Windows platform are supported. R, Python, and Java on the Windows and Linux platforms are supported in SQL Server 2019 and later. On Azure SQL Managed Instance, R and Python are supported.
Please refer to this article: sys.external_libraries (Transact-SQL)
Once the set is done, is the Created lib still looks for the jar file in that path specified or an instance is deployed to SQL server ?
As far as I understand, it is the former one.
Best regards,
Cosmog Hong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.