T O P
AutoModerator

#Please ensure that: + Your *code* is *properly formatted* as *code block* - see the *sidebar* (About on mobile) for instructions + You include *any and all error messages* in full + You ask *clear questions* + You *demonstrate effort* in solving your question/problem - plain posting your assignments is forbidden (and such posts will be removed) as is asking for or giving solutions. Trying to solve problems on your own is a very important skill. Also, see [*Learn to help yourself*](https://www.reddit.com/r/javahelp/wiki/learn_to_help_yourself) in the *sidebar* **If any of the above points is not met, your post can and will be removed without further warning.** Code is to be formatted as **code block** (*old reddit:* empty line before the code, each code line indented by 4 spaces, *new reddit:* https://imgur.com/a/fgoFFis) or linked via an external *code hoster*, like *pastebin.com*, *github gist*, *github*, *bitbucket*, *gitlab*, etc. Please, **do not use** triple backticks (\`\`\`) as they will only render properly on *new reddit*, not on *old reddit*. Code blocks look like this: public class HelloWorld { public static void main(String[] args) { System.out.println("Hello World!"); } } You do not need to repost unless your post has been removed by a moderator. Just use the *edit function* of reddit to make sure your post complies with the above. If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures. #To potential helpers Please, **do not help** if any of the above points are not met, rather *report* the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/javahelp) if you have any questions or concerns.*


pragmos

The error message is telling you that you are missing the JDBC driver for Microsoft SQL Server database (assuming that's what your Azure service is using under the hood) in the classpath. Solving this will depend on how you build your application. Are you using Gradle or Maven?


SlapmanChapman

This is the first time I've used Azure, or even databases with java & intelliJ, and I don't remember having to setup or choose between Gradle or Maven. Is this a step I have missed, or is there a default selection that I would be using, and if so, how would I check to see which it was?


pragmos

If your project in IntelliJ contains a file named pom.xml - you are most likely using Maven. If your project contains a file named build.gradle - you are most likely using Gradle. If none of the above, you probably have a simple Java project managed directly by IntelliJ.


SlapmanChapman

Just checked, and I had neither so I guess it would be the 3rd option


pragmos

Here's a StackOverflow comment that describes how to add dependencies in form of external jar files: https://stackoverflow.com/a/1051705 You need to search the webs and download the jar file with the driver first. A query of "ms sql server jdbc driver jar" should yield plenty of results.


SlapmanChapman

Hi! Thank you so far for all of your support, but I still seem to have the same issue, even after following those instructions for adding dependancies. I added a JDBC driver I found using your google query, which lead me to the same website u/why_not_cats kindly recommended. However, even after following that website's proof of concept and downloading the d rivers, I still get the same java.sql.SQLException: No suitable driver found Error. I tried running one of the jar files inside the zip from inside my IDE, and it said that it was unable to access the jarfile. Is there something wrong with my filepath? I just had the zip file in the C:\\Users\\ch4pp\\Downloads, so idk if there is some permissions issue, but I don't think there would be. I also don't know if my version is an issue, but I'll send it here just in case: [https://imgur.com/a/uf2kApe](https://imgur.com/a/uf2kApe)


why_not_cats

Your need to add the library (JAR) as a project dependency. This usually is done by a dep management tool like Maven but you can also add one manually in IntelliJ, guide here: https://www.jetbrains.com/help/idea/library.html#define-a-project-library Note this solution is not portable (will need to do it every time you import your project) which is why using dependency management is a better idea.


why_not_cats

The SQL Server JDBC driver download site contains examples of connecting to a SQL Server database using JDBC: https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16#download