spring：从Spring Boot服务连接Sql server

Question

server.port=9004
spring.datasource.url=jdbc:sqlserver://localhost/1433;databaseName=test1
spring.datasource.username=sa
spring.datasource.password=*****
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2014Dialect
spring.jpa.hibernate.ddl-auto =ddl-auto

<maven.compiler.source>1.8</maven.compiler.source>
  <maven.compiler.target>1.8</maven.compiler.target>
</properties>

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.3.6.RELEASE</version>
    </parent>
 <dependencies>
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-rest</artifactId>
</dependency>
<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>sqljdbc4</artifactId>
            <version>4.0</version>
        </dependency>
        <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-tomcat</artifactId>
        <scope>provided</scope>
      </dependency>    

        </dependencies>

<build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

当我将其作为java项目运行时，我总是会遇到以下错误：

原因：org.springframework.beans.factory.beanCreationException：无法自动连接字段：private org.springframework.boot.autocigure.web.httpmessageconverters org.springframework.boot.autocigure.web.webmvcautoconfiguration$webmvcautoconfigurationadapter.messageconverters；嵌套异常为

和：

类路径资源[org/SpringFramework/Boot/AutoConfigure/Web/JacksonHttpMessageConvertersConfiguration$MappingJackson2HttpMessageConverterConfiguration.class]中定义的名为“MappingJackson2HttpMessageConverterConfiguration.class]：通过类型[com.fasterxml.Jackson.DataBind.ObjectMapper]的索引为0的构造函数参数表示的不满足的依赖关系：创建类路径资源嵌套异常为org.SpringFramework.Beans.BeanInstantiationException：无法实例化[Com.FasterXml.Jackson.DataBind.ObjectMapper]:工厂方法“Object Mapper”引发异常；嵌套异常为org.springframework.beans.factory.beanCreationException：创建类路径资源[org/springframework/boot/autoconfigure/data/rest/springbootrepositoryrestmvcconfiguration.class]中定义的名为“config”的bean时出错：通过工厂方法实例化bean失败；嵌套异常为org.springframework.beans.beanInstantiationException：无法实例化[org.springframework.data.rest.core.config.RepositoryRestConfiguration]:工厂方法“config”引发异常；嵌套异常为org.springframework.beans.factory.beanCreationException：创建类路径资源[org/springframework/boot/autoconfigure/data/rest/springbootrepositoryrestmvcconfiguration.class]中定义的名为“资源映射”的bean时出错：通过工厂方法实例化bean失败；嵌套异常为

我应该在我的pom或属性文件中更改什么以使我的程序工作？

Answer 1

不推荐使用SQL Server依赖项，请使用以下内容与SQL Server交互

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>6.1.0.jre8</version>
</dependency> 

有关详细信息，请单击链接

配置Microsoft SQL Server的Spring Boot