NOTE: Even though the title says SQL 2019 and I mention SQL 2019 above, there is very little in the post that is SQL Server 2019 specific. So, in the rest of this post, we see what I did to be able to write, debug, and compile Java code in VS Code for use in SQL Server 2019. I know that VS Code does support Java, so why not “kill two birds with one stone”: So, I thought “I have heard a lot of Visual Studio Code, why not see what that can do”. However, even though it might be possible, writing Java code in Visual Studio is not straightforward. I then started on a new Java post (which I have not finished yet), and it became clear I needed an IDE, (intelli-sense, debug, etc.), but which IDE?Īs you, my readers, probably know by now, I am a Microsoft and Windows guy at heart, so for me, the natural choice for an IDE has always been Visual Studio. Me not being a Java “person” I do not have a Java IDE, (for the code I wrote I did not need one either), so I used my regular text editor Sublime Text 3, and I compiled the code from command line ( $ javac. Another reason the code is simplistic is that I am not a Java “person” in fact, the only Java code I have ever written is what is in those posts.

The code in the posts is very, very simplistic where I was just trying to get the ideas across how and what to do. Seeing that I am “somewhat” interested in the SQL Server Extensibility Framework I wrote some posts about the Java language extensions: SQL Server 2019 Extensibility Framework & Java. The Java language extensions make it possible to execute Java code from inside SQL Server, the same way we can run R/Python code. As you know, SQL Server 2019 introduces the Java language extensions as part of the SQL Server Extensibility Framework.

How to use visual studio code + server