So I have a Spring boot application that runs on port 8080 on my localhost. It connects to an Azure sqlserver database and pulls or inserts item from that database. Locally everything is working fine. Now I'm trying to dockerize the application. My Dockerfile looks like this:
FROM maven:3.5-jdk-8 AS build
COPY src /usr/src/app/src
COPY pom.xml /usr/src/app
COPY mssql-jdbc-9.2.1.jre15.jar .
RUN mvn -f /usr/src/app/pom.xml clean package
FROM gcr.io/distroless/java
COPY --from=build /usr/src/app/target/ProfileService-0.0.1-SNAPSHOT.jar /usr/app/ProfileService-0.0.1-SNAPSHOT.jar
EXPOSE 8080
ENTRYPOINT ["java","-jar","/usr/app/ProfileService-0.0.1-SNAPSHOT.jar"]
The Dockerfile is located in the root folder, the same folder as the pom.xml and the mssql-jdbc-9.2.1.jre15.jar file. This jar is downloaded from the official Microsoft source. My pom includes multiple dependencies, one of them is the mssql-jdbc dependency.
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>9.2.1.jre15</version>
</dependency>
To connect to the database, I use the following code:
private final String connectionUrl = "jdbc:sqlserver://x.database.windows.net:1433;DatabaseName=profile;user=x@xr;password=x;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;";
With the following method as an example to get data:
public GetProfileReturnModel getProfile(String profile_name) {
GetProfileReturnModel returnModel = new GetProfileReturnModel();
try (Connection connection = DriverManager.getConnection(connectionUrl)) {
try {
CallableStatement cstmnt = connection.prepareCall("{CALL getProfile(?)}");
cstmnt.setString(1, profile_name);
cstmnt.execute();
ResultSet rs = cstmnt.getResultSet();
if (rs.next()) {
returnModel.setUser_id(rs.getInt("user_id"));
returnModel.setBio(rs.getString("bio"));
returnModel.setLocation(rs.getString("location"));
returnModel.setProfile_name(rs.getString("profile_name"));
returnModel.setPicture(rs.getString("picture"));
returnModel.setWebsite(rs.getString("website"));
}
returnModel.setSuccess(true);
} catch (SQLException e) {
returnModel.setSuccess(false);
returnModel.setErrorMessage(e.toString());
}
} catch (SQLException e) {
returnModel.setErrorMessage(e.getMessage());
returnModel.setSuccess(false);
}
return returnModel;
}
This works fine locally. But when I run my build image in Docker and I call the same request I get the following error:
No suitable driver found for jdbc:sqlserver://x.database.windows.net:1433;DatabaseName=profile;user=x@xr;password=x;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
There is also this weird behavior that when I run the packaged .jar file using the cmd it runs perfectly, but if I start it by double clicking the jar I get the same error as mentioned above
My complete pom.xml:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.4.3</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.kwetter.profileservice</groupId>
<artifactId>ProfileService</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<name>ProfileService</name>
<description>Demo project for Spring Boot</description>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
<distributionManagement>
<repository>
<id>ProfileServiceBuild</id>
<url>https://pkgs.dev.azure.com/382763/Kwetter/_packaging/ProfileServiceBuild/maven/v1</url>
</repository>
</distributionManagement>
<repositories>
<repository>
<id>ProfileServiceBuild</id>
<url>https://pkgs.dev.azure.com/382763/Kwetter/_packaging/ProfileServiceBuild/maven/v1</url>
<releases>
<enabled>true</enabled>
</releases>
<snapshots>
<enabled>true</enabled>
</snapshots>
</repository>
</repositories>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>2.4.3</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.amqp/spring-rabbit -->
<dependency>
<groupId>org.springframework.amqp</groupId>
<artifactId>spring-rabbit</artifactId>
<version>2.3.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.amqp/spring-amqp -->
<dependency>
<groupId>org.springframework.amqp</groupId>
<artifactId>spring-amqp</artifactId>
<version>2.3.6</version>
</dependency>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>9.2.1.jre15</version>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>org.jboss.spec.javax.ws.rs</groupId>
<artifactId>jboss-jaxrs-api_2.1_spec</artifactId>
<version>2.0.1.Final</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.11.3</version>
</dependency>
</dependencies>
</project>
spring-boot-maven-plugin? – Michał Krzywański