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.1</version>
<relativePath /> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>DemoTestPj</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>DemoTestPj</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.4</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>sqljdbc</groupId>
<artifactId>sqljdbc42</artifactId>
<version>4.2</version>
<scope>system</scope>
<systemPath>C:\eclipse-workspace2\DemoTestPj\target\BOOT-INF\lib\sqljdbc42.jar</systemPath>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
<resources>
<resource>
<directory>lib</directory>
<targetPath>/BOOT-INF/lib/</targetPath>
<includes>
<include>**/*.jar</include>
</includes>
</resource>
</resources>
</build>
</project>
application.properties
server.port=7000
# ==============================
# MySQL connection config
# ==============================
spring.datasource.url=jdbc:sqlserver://*****; databaseName=HuanYuDB;integratedSecurity=false;
spring.datasource.username=******
spring.datasource.password=******
# spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
#Druid會自動跟url識別驅動類名，如果連接的資料庫非常見資料庫，配置屬性driverClassName
# ==============================
# Druid 資料源專用配置
# ==============================
# 初始化大小，最小，最大
spring.datasource.druid.initial-size=3
spring.datasource.druid.minIdle=5
spring.datasource.druid.maxActive=20
# 配置獲取連接等待超時的時間
spring.datasource.druid.maxWait=30000
# 配置間隔多久才進行一次檢測，檢測需要關閉的空閑連接，單位是毫秒
spring.datasource.druid.timeBetweenEvictionRunsMillis=60000
# 配置一個連接在池中最小生存的時間，單位是毫秒
spring.datasource.druid.minEvictableIdleTimeMillis=300000
spring.datasource.druid.maxEvictableIdleTimeMillis=900000
spring.datasource.druid.validationQuery=SELECT 1 FROM DUAL
spring.datasource.druid.testWhileIdle=true
spring.datasource.druid.testOnBorrow=false
spring.datasource.druid.testOnReturn=false
# 打開PSCache，并且指定每個連接上PSCache的大小
spring.datasource.druid.poolPreparedStatements=true
spring.datasource.druid.maxPoolPreparedStatementPerConnectionSize=20
# 配置監控統計攔截的filters，去掉后監控界面sql無法統計，'wall'用于防火墻
spring.datasource.druid.filters=stat,wall,log4j
# 通過connectProperties屬性來打開mergeSql功能；慢SQL記錄
# 合并多個DruidDataSource的監控資料
#spring.datasource.useGlobalDataSourceStat=true
# 通過connectProperties屬性來打開mergeSql功能；慢SQL記錄
spring.datasource.druid.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=10000
出錯資訊
:: Spring Boot :: (v2.4.1)
2021-01-01 18:33:58.469 INFO 2960 --- [ restartedMain] com.example.demo.DemoTestPjApplication : Starting DemoTestPjApplication using Java 15.0.1 on ZyqdeskTop with PID 2960 (C:\eclipse-workspace2\DemoTestPj\target\classes started by Administrator in C:\eclipse-workspace2\DemoTestPj)
2021-01-01 18:33:58.471 INFO 2960 --- [ restartedMain] com.example.demo.DemoTestPjApplication : No active profile set, falling back to default profiles: default
2021-01-01 18:33:58.518 INFO 2960 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2021-01-01 18:33:58.518 INFO 2960 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2021-01-01 18:33:59.508 INFO 2960 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
2021-01-01 18:33:59.518 INFO 2960 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2021-01-01 18:33:59.518 INFO 2960 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.41]
2021-01-01 18:33:59.605 INFO 2960 --- [ restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2021-01-01 18:33:59.605 INFO 2960 --- [ restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1087 ms
2021-01-01 18:33:59.751 INFO 2960 --- [ restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor'
2021-01-01 18:33:59.877 INFO 2960 --- [ restartedMain] c.a.d.s.b.a.DruidDataSourceAutoConfigure : Init DruidDataSource
2021-01-01 18:33:59.930 WARN 2960 --- [ restartedMain] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/alibaba/druid/spring/boot/autoconfigure/DruidDataSourceAutoConfigure.class]: Invocation of init method failed; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class
2021-01-01 18:33:59.930 INFO 2960 --- [ restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'applicationTaskExecutor'
2021-01-01 18:33:59.932 INFO 2960 --- [ restartedMain] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2021-01-01 18:33:59.975 INFO 2960 --- [ restartedMain] ConditionEvaluationReportLoggingListener :
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2021-01-01 18:34:00.002 ERROR 2960 --- [ restartedMain] o.s.b.d.LoggingFailureAnalysisReporter :
***************************
APPLICATION FAILED TO START
***************************
Description:
Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
Reason: Failed to determine a suitable driver class
Action:
Consider the following:
If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).
uj5u.com熱心網友回復：
把application.properties里面的東西全部洗掉，報錯一模一樣，uj5u.com熱心網友回復：
pom.xml把下面的注釋掉還是一樣錯誤，這樣段是sqljdbc42.jar的dependency，
sqljdbc42.jar在本地C:\eclipse-workspace2\DemoTestPj\target\BOOT-INF\lib，不知道這樣寫對不對
<!-- <dependency>
<groupId>sqljdbc</groupId>
<artifactId>sqljdbc42</artifactId>
<version>4.2</version>
<scope>system</scope>
<systemPath>C:\eclipse-workspace2\DemoTestPj\target\BOOT-INF\lib\sqljdbc42.jar</systemPath>
</dependency> -->
uj5u.com熱心網友回復：
你試試將版本改一下轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/243381.html
標籤：Java EE
下一篇：小白提問