SQL server and Java?

I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only. It then led me to a cool website, SQL Server development – build an app using SQL server where you can get to see the high-level requirements of starting to build a solution based on a wide variation of languages and operating systems. https://www.microsoft.com/en-us/sql-server/developer-get-started/

There are many combinations possible with SQL Server being the back-end database of choice.

operatingcode.JPG

Now you can use SQL Server 2017 on Red Hat Enterprise Linux (RHEL), SQL Server 2017 running on Ubuntu to create PHP apps. Or how about SQL Server 2017 running on Docker and installing the necessary dependencies to create Python apps with SQL Server.

Once you select your requirements if goes through an example of what is required from an installation perspective and programming one. Lets look at the tool with quick snippets.

For example, RHEL SQL Server 2017 to create java apps

First step – install SQL Server.

sqllinux1.JPG

Then install java.

javasql.JPG

Then maven to help manage dependencies, build, test and run your Java project.

maven.JPG

Then the rest of tool shows you how to connect to the database and work with them.

A useful website. I enjoyed playing around with all the possible combinations. SQL Server is really giving people a lot of options – check it out.

 

Leave a Reply