如何设置quarkus spring hibernate和multitenant？

hkmswyz6  于 2021-07-23  发布在  Java
关注(0)|答案(1)|浏览(635)

早上好，我正在尝试用spring、hibernate和multitenant设置quarkus项目。但不在运行查询时更改模式？如何设置配置，以便查询在正确的预期模式上动态运行？
应用程序.yml

  1. quarkus:
  2.  datasource:
  3.    db-kind: postgres
  4.    username: postgres
  5.    password: 1234
  6.    jdbc:
  7.      url: jdbc:postgresql://localhost:5432/postgres
  8.      driver: org.postgresql.Driver
  9.  hibernate-orm:
  10.    multitenant: SCHEMA
  11.    dialect: org.hibernate.dialect.PostgreSQLDialect
  12.    log:
  13.      sql: true

租户解析程序

  1. package br.com.rhino.config;
  3. import java.util.Optional;
  5. import io.quarkus.hibernate.orm.runtime.tenant.TenantResolver;
  6. import io.vertx.ext.web.RoutingContext;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.stereotype.Component;
  10. @Component
  11. public class CustomTenantResolver implements TenantResolver {
  13.     public static String DEFAULT_TENANT = "rhino";
  15.     @Autowired
  16.     RoutingContext context;
  18.     @Override
  19.     public String getDefaultTenantId() {
  20.         return DEFAULT_TENANT;
  21.     }
  23.     @Override
  24.     public String resolveTenantId() {
  25.         return Optional.ofNullable(context.request().getHeader("x-tenantId")).orElse(DEFAULT_TENANT);
  26.     }
  27. }

正确截距
调试映像中的正确租户返回
日志

  1. --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ 
  2.  -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \   
  3. --\___\_\____/_/ |_/_/|_/_/|_|\____/___/   
  4. 2021-03-09 08:02:15,282 INFO  [io.qua.fly.FlywayProcessor] (build-20) Adding application migrations in path '/home/idd_acosta/freelas/rhino/rhino-api/target/classes/db/migration/maripa/' using protocol 'file'
  5. 2021-03-09 08:02:15,669 INFO  [io.qua.arc.pro.BeanProcessor] (build-24) Found unrecommended usage of private members (use package-private instead) in application beans:
  6.     - @Inject field br.com.rhino.user.mapper.UserMapperImpl#roleMapper,
  7.     - @Inject field br.com.rhino.user.mapper.RoleMapperImpl#permissionMapper
  8. 2021-03-09 08:02:16,591 INFO  [org.fly.cor.int.lic.VersionPrinter] (Quarkus Main Thread) Flyway Community Edition 7.5.2 by Redgate
  9. 2021-03-09 08:02:16,670 INFO  [org.fly.cor.int.dat.bas.DatabaseType] (Quarkus Main Thread) Database: jdbc:postgresql://localhost:5432/postgres (PostgreSQL 13.1)
  10. 2021-03-09 08:02:16,686 INFO  [org.fly.cor.int.com.DbClean] (Quarkus Main Thread) Successfully dropped pre-schema database level objects (execution time 00:00.000s)
  11. 2021-03-09 08:02:16,709 INFO  [org.fly.cor.int.com.DbClean] (Quarkus Main Thread) Successfully dropped schema "maripa" (execution time 00:00.021s)
  12. 2021-03-09 08:02:16,710 INFO  [org.fly.cor.int.com.DbClean] (Quarkus Main Thread) Successfully dropped schema " bicas" (execution time 00:00.001s)
  13. 2021-03-09 08:02:16,712 INFO  [org.fly.cor.int.com.DbClean] (Quarkus Main Thread) Successfully dropped schema " rhino" (execution time 00:00.001s)
  14. 2021-03-09 08:02:16,712 INFO  [org.fly.cor.int.com.DbClean] (Quarkus Main Thread) Successfully dropped post-schema database level objects (execution time 00:00.000s)
  15. 2021-03-09 08:02:16,714 INFO  [org.fly.cor.int.lic.VersionPrinter] (Quarkus Main Thread) Flyway Community Edition 7.5.2 by Redgate
  16. 2021-03-09 08:02:16,718 INFO  [org.fly.cor.int.dat.bas.Schema] (Quarkus Main Thread) Creating schema "maripa" ...
  17. 2021-03-09 08:02:16,718 INFO  [org.fly.cor.int.dat.bas.Schema] (Quarkus Main Thread) Creating schema " bicas" ...
  18. 2021-03-09 08:02:16,719 INFO  [org.fly.cor.int.dat.bas.Schema] (Quarkus Main Thread) Creating schema " rhino" ...
  19. 2021-03-09 08:02:16,721 INFO  [org.fly.cor.int.sch.JdbcTableSchemaHistory] (Quarkus Main Thread) Creating Schema History table "maripa"."flyway_schema_history" ...
  20. 2021-03-09 08:02:16,755 INFO  [org.fly.cor.int.com.DbMigrate] (Quarkus Main Thread) Current version of schema "maripa": null
  21. 2021-03-09 08:02:16,762 INFO  [org.fly.cor.int.com.DbMigrate] (Quarkus Main Thread) Migrating schema "maripa" to version "1.0.1 - start structure maripa"
  22. 2021-03-09 08:02:16,813 INFO  [org.fly.cor.int.com.DbMigrate] (Quarkus Main Thread) Successfully applied 1 migration to schema "maripa" (execution time 00:00.066s)
  23. 2021-03-09 08:02:17,120 INFO  [io.qua.sch.run.SimpleScheduler] (Quarkus Main Thread) No scheduled business methods found - Simple scheduler will not be started
  24. 2021-03-09 08:02:17,194 INFO  [io.quarkus] (Quarkus Main Thread) rhino-api 1.0.0-SNAPSHOT on JVM (powered by Quarkus 1.12.1.Final) started in 2.714s. Listening on: http://localhost:8080
  25. 2021-03-09 08:02:17,194 INFO  [io.quarkus] (Quarkus Main Thread) Profile dev activated. Live Coding activated.
  26. 2021-03-09 08:02:17,194 INFO  [io.quarkus] (Quarkus Main Thread) Installed features: [agroal, cdi, config-yaml, flyway, hibernate-orm, hibernate-orm-panache, hibernate-orm-rest-data-panache, jdbc-postgresql, micrometer, mutiny, narayana-jta, resteasy, resteasy-jackson, scheduler, security, smallrye-context-propagation, spring-data-jpa, spring-di, spring-scheduled, spring-security, spring-web]
  28. Hibernate: 
  29.     select
  30.         user0_.id as id1_7_,
  31.         user0_.dt_creation as dt_creat2_7_,
  32.         user0_.email as email3_7_,
  33.         user0_.password as password4_7_,
  34.         user0_.dt_update as dt_updat5_7_,
  35.         user0_.username as username6_7_ 
  36.     from
  37.         user user0_
  38. 2021-03-09 08:09:33,430 WARN  [org.hib.eng.jdb.spi.SqlExceptionHelper] (executor-thread-1) SQL Error: 0, SQLState: 42703
  39. 2021-03-09 08:09:33,430 ERROR [org.hib.eng.jdb.spi.SqlExceptionHelper] (executor-thread-1) ERROR: column user0_.id does not exist
  40.   Posição: 8
  41. 2021-03-09 08:09:33,441 ERROR [io.qua.ver.htt.run.QuarkusErrorHandler] (executor-thread-1) HTTP Request to /user failed, error id: 0866564b-c6ab-43be-b245-ab70add72f26-1: org.jboss.resteasy.spi.UnhandledException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  42.     at org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(ExceptionHandler.java:106)
  43.     at org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler.java:372)
  44.     at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:218)
  45.     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:519)
  46.     at org.jboss.resteasy.core.SynchronousDispatcher.lambda$invoke$4(SynchronousDispatcher.java:261)
  47.     at org.jboss.resteasy.core.SynchronousDispatcher.lambda$preprocess$0(SynchronousDispatcher.java:161)
  48.     at org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext.filter(PreMatchContainerRequestContext.java:364)
  49.     at org.jboss.resteasy.core.SynchronousDispatcher.preprocess(SynchronousDispatcher.java:164)
  50.     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:247)
  51.     at io.quarkus.resteasy.runtime.standalone.RequestDispatcher.service(RequestDispatcher.java:73)
  52.     at io.quarkus.resteasy.runtime.standalone.VertxRequestHandler.dispatch(VertxRequestHandler.java:138)
  53.     at io.quarkus.resteasy.runtime.standalone.VertxRequestHandler.access$000(VertxRequestHandler.java:41)
  54.     at io.quarkus.resteasy.runtime.standalone.VertxRequestHandler$1.run(VertxRequestHandler.java:93)
  55.     at io.quarkus.runtime.CleanableExecutor$CleaningRunnable.run(CleanableExecutor.java:231)
  56.     at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
  57.     at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
  58.     at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2415)
  59.     at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1452)
  60.     at org.jboss.threads.DelegatingRunnable.run(DelegatingRunnable.java:29)
  61.     at org.jboss.threads.ThreadLocalResettingRunnable.run(ThreadLocalResettingRunnable.java:29)
  62.     at java.base/java.lang.Thread.run(Thread.java:834)
  63.     at org.jboss.threads.JBossThread.run(JBossThread.java:501)
  64. Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  65.     at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
  66.     at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1602)
  67.     at org.hibernate.query.Query.getResultList(Query.java:165)
  68.     at io.quarkus.hibernate.orm.panache.common.runtime.CommonPanacheQueryImpl.list(CommonPanacheQueryImpl.java:230)
  69.     at io.quarkus.hibernate.orm.panache.runtime.PanacheQueryImpl.list(PanacheQueryImpl.java:149)
  70.     at br.com.rhino.user.service.UserService.findAllUsers(UserService.java:73)
  71.     at br.com.rhino.user.controller.UserController.findAll(UserController.java:36)
  72.     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  73.     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  74.     at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  75.     at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  76.     at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:170)
  77.     at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:130)
  78.     at org.jboss.resteasy.core.ResourceMethodInvoker.internalInvokeOnTarget(ResourceMethodInvoker.java:643)
  79.     at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTargetAfterFilter(ResourceMethodInvoker.java:507)
  80.     at org.jboss.resteasy.core.ResourceMethodInvoker.lambda$invokeOnTarget$2(ResourceMethodInvoker.java:457)
  81.     at org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext.filter(PreMatchContainerRequestContext.java:364)
  82.     at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:459)
  83.     at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:419)
  84.     at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:393)
  85.     at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:68)
  86.     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:492)
  87.     ... 18 more
  88. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  89.     at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)
  90.     at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  91.     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  92.     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
  93.     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
  94.     at org.hibernate.loader.Loader.getResultSet(Loader.java:2303)
  95.     at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2056)
  96.     at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2018)
  97.     at org.hibernate.loader.Loader.doQuery(Loader.java:948)
  98.     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
  99.     at org.hibernate.loader.Loader.doList(Loader.java:2849)
  100.     at org.hibernate.loader.Loader.doList(Loader.java:2831)
  101.     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2663)
  102.     at org.hibernate.loader.Loader.list(Loader.java:2658)
  103.     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
  104.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
  105.     at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
  106.     at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414)
  107.     at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1625)
  108.     at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593)
  109.     ... 38 more
  110. Caused by: org.postgresql.util.PSQLException: ERROR: column user0_.id does not exist
  111.   Posição: 8
  112.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
  113.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
  114.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
  115.     at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
  116.     at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
  117.     at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
  118.     at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
  119.     at io.agroal.pool.wrapper.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:76)
  120.     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
  121.     ... 53 more

旁白：对不起我的英语！：）

springschemaHibernatequarkusmulti-tenant

1条答案

按热度按时间
nwwlzxa7

nwwlzxa71#

不确定应用程序代码的外观，但您似乎遵循以下文档：https://quarkus.io/guides/hibernate-orm#multitenancy
如果您的实体没有指定显式模式，我建议您使用复制器创建错误报告：https://github.com/quarkusio/quarkus/issues/new?assignees=&labels=kind%2fbug&template=bug_report.md&title=

赞(0）分享  回复(0）举报  2021-07-23
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com