首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >Spring数据JDBC -无法安全地识别存储库候选库的存储分配。

Spring数据JDBC -无法安全地识别存储库候选库的存储分配。
EN

Stack Overflow用户
提问于 2022-07-10 23:51:54
回答 1查看 3K关注 0票数 1

我对提交做了一些更改,突然之间,我的spring程序似乎无法初始化实体并将它们链接到存储库。当我开始春天,我得到这个作为我的日志:

代码语言:javascript
运行
复制
2022-07-10 16:39:17.137  INFO 18040 --- [  restartedMain] com.vendify.BackendDbApplication         : Starting BackendDbApplication using Java 17.0.2 on DESKTOP-HSDNP64 with PID 18040 (applicaiton started by (my name) in directory)
2022-07-10 16:39:17.140  INFO 18040 --- [  restartedMain] com.vendify.BackendDbApplication         : No active profile set, falling back to default profiles: default
2022-07-10 16:39:17.186  INFO 18040 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2022-07-10 16:39:17.187  INFO 18040 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2022-07-10 16:39:18.193  INFO 18040 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2022-07-10 16:39:18.194  INFO 18040 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JDBC repositories in DEFAULT mode.
2022-07-10 16:39:18.240  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.Auth0TokensCacheRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.
2022-07-10 16:39:18.242  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.ItemIndexRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.
2022-07-10 16:39:18.244  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.ItemsRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.
2022-07-10 16:39:18.246  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.LoggingRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.
2022-07-10 16:39:18.248  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.SerialsRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.
2022-07-10 16:39:18.251  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.TransactionsRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.
2022-07-10 16:39:18.253  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.ValidUsersRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.
2022-07-10 16:39:18.255  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.VendorsRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.
2022-07-10 16:39:18.256  INFO 18040 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 58 ms. Found 0 JDBC repository interfaces.
2022-07-10 16:39:18.266  INFO 18040 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2022-07-10 16:39:18.267  INFO 18040 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2022-07-10 16:39:18.329  INFO 18040 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 51 ms. Found 8 JPA repository interfaces.
2022-07-10 16:39:19.172  INFO 18040 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8081 (http)
2022-07-10 16:39:19.184  INFO 18040 --- [  restartedMain] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2022-07-10 16:39:19.184  INFO 18040 --- [  restartedMain] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.52]
2022-07-10 16:39:19.275  INFO 18040 --- [  restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2022-07-10 16:39:19.276  INFO 18040 --- [  restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2089 ms
2022-07-10 16:39:19.754  INFO 18040 --- [  restartedMain] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 7.7.3 by Redgate
2022-07-10 16:39:19.760  INFO 18040 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2022-07-10 16:39:20.192  INFO 18040 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2022-07-10 16:39:20.240  INFO 18040 --- [  restartedMain] o.f.c.i.database.base.DatabaseType       : Database: jdbc:mysql://localhost:3306/vendify (MySQL 8.0)
2022-07-10 16:39:20.276  INFO 18040 --- [  restartedMain] o.f.core.internal.command.DbValidate     : Successfully validated 1 migration (execution time 00:00.015s)
2022-07-10 16:39:20.284  INFO 18040 --- [  restartedMain] o.f.core.internal.command.DbMigrate      : Current version of schema `vendify`: 1
2022-07-10 16:39:20.285  INFO 18040 --- [  restartedMain] o.f.core.internal.command.DbMigrate      : Schema `vendify` is up to date. No migration necessary.
2022-07-10 16:39:20.502  INFO 18040 --- [  restartedMain] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2022-07-10 16:39:20.564  INFO 18040 --- [  restartedMain] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.4.32.Final
2022-07-10 16:39:20.705  INFO 18040 --- [  restartedMain] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
2022-07-10 16:39:20.866  INFO 18040 --- [  restartedMain] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.MySQL8Dialect
2022-07-10 16:39:21.555  INFO 18040 --- [  restartedMain] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2022-07-10 16:39:21.563  INFO 18040 --- [  restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2022-07-10 16:39:22.307  WARN 18040 --- [  restartedMain] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2022-07-10 16:39:22.779  INFO 18040 --- [  restartedMain] o.s.s.web.DefaultSecurityFilterChain     : Will secure any request with [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@6c38469b, org.springframework.security.web.context.SecurityContextPersistenceFilter@52d983cb, org.springframework.security.web.header.HeaderWriterFilter@67a31d2b, org.springframework.security.web.authentication.logout.LogoutFilter@2c8dea82, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@631bab6, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@1f96917a, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@64458fc6, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@46d290b3, org.springframework.security.web.session.SessionManagementFilter@1312d3d0, org.springframework.security.web.access.ExceptionTranslationFilter@37e85798, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@2cc95e93]
2022-07-10 16:39:23.986  INFO 18040 --- [  restartedMain] o.s.b.d.a.OptionalLiveReloadServer       : LiveReload server is running on port 35729
2022-07-10 16:39:23.995  INFO 18040 --- [  restartedMain] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 14 endpoint(s) beneath base path '/****{hidden for security}'
2022-07-10 16:39:24.057  INFO 18040 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8081 (http) with context path ''
2022-07-10 16:39:24.073  INFO 18040 --- [  restartedMain] com.vendify.BackendDbApplication         : Started BackendDbApplication in 7.398 seconds (JVM running for 7.938)

我关心的主要错误是日志中的这样的错误:

代码语言:javascript
运行
复制
2022-07-10 16:39:18.240  INFO 18040 --- [  restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data JDBC - Could not safely identify store assignment for repository candidate interface com.vendify.Repositories.Auth0TokensCacheRepository. If you want this repository to be a JDBC repository, consider annotating your entities with one of these annotations: org.springframework.data.relational.core.mapping.Table.

这是我如何编码实体类的一个例子(所有这些类都是这样的,我已经很久没有接触它们了)。他们似乎以前曾工作过。)

代码语言:javascript
运行
复制
package com.vendify.Entities;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import org.springframework.lang.NonNull;

import lombok.Getter;
import lombok.Setter;

@Entity
@Table(name = "Logging")
@Getter
@Setter
public class LoggingEntity {

//specific code removed for security

}

使用类似的存储库类,如下所示:

代码语言:javascript
运行
复制
package com.vendify.Repositories;

import java.util.Date;
import java.util.List;

import org.springframework.data.repository.CrudRepository;
import org.springframework.data.rest.core.annotation.RepositoryRestResource;

import com.vendify.Entities.Auth0TokensCacheEntity;

@RepositoryRestResource(exported = false)
public interface Auth0TokensCacheRepository extends CrudRepository<Auth0TokensCacheEntity, String> {

}

作为证明,我的MySQL数据库结构表看起来有点像这样:

Spring似乎能够连接到数据库,而且在很长一段时间内,它没有任何问题.我添加了几个包,它还处理了一些其他的东西,似乎是在它崩溃的时候,所以对于某些上下文,下面是我的程序的一般布局:

我们将非常感谢您的帮助!非常感谢你,祝你的项目伙伴们好运!

更新:我尝试了用CRUDRepository代替JPARepository的解决方案,以及Dhana建议的其他注释(谢谢:),spring找到了所有这些存储库。但是,我的所有API端点现在都没有响应,甚至执行器端点也是如此。另外,当添加@ComponentScan(basePackageClasses = {my控制器类})时,我得到一个应用程序错误,spring找不到服务类。请注意,到目前为止,当我调用端点时,函数仍然正常运行(它可以正确地system.out.print结果,但由于某些原因,不能将其正确地返回到要显示的when服务器。

代码语言:javascript
运行
复制
Description:

Field auth0TokensCacheService in com.vendify.Controllers.{ControllerClass} required a bean of type 'com.vendify.Services.{ControllerClass}' that could not be found.

The injection point has the following annotations:
    - @org.springframework.beans.factory.annotation.Autowired(required=true)


Action:

Consider defining a bean of type 'com.vendify.Services.{ControllerClass}' in your configuration.

我的服务类如下所示:

代码语言:javascript
运行
复制
    @Service
public class HiddenService {
    @Autowired
    HiddenRepository hiddenRepository;
//methods in here
}

我的主计长是这样的:

代码语言:javascript
运行
复制
@RestController
public class HiddenController {

@GetMapping("/endpointURL")
//method here

} 

谢谢!

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2022-07-11 12:57:16

让我解释一下,根据我的理解,当一个项目中有多个Spring数据模块与Spring同时存在时,如果您试图通过从公共模块扩展接口来为特定实体创建一个接口,而该实体没有使用特定的持久性注释进行注释。这肯定不起作用,因为spring基本上不知道实体与哪个数据存储相关联。因此,尝试将其扩展到特定的存储库,例如,如果您正在使用MySQL,请选择JpaRepository而不是CrudRepository,无论如何,在层次结构的某个点,它们将相互链接,但仍然建议将实体与特定的存储库相关联。

最后,确保将这些添加到各自的文件中:

  1. @Repository在您的自定义回购

将此添加到application.properties中的

spring.data.jdbc.repositories.enabled=false

希望它对你有帮助!)

票数 3
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/72932610

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档