由于实体和表名不同,在实体增加注解
通过spring-data-jdbc提供的仓库进行操作时,会将表名、字段名加双引号,例如:
SELECT "user123"."ID" AS "ID", "user123"."SEX" AS "SEX", "user123"."AGE" AS "AGE", "user123"."TENANT_ID" AS "TENANT_ID", "user123"."IS_DELETE" AS "IS_DELETE", "user123"."OWN_USER_ID" AS "OWN_USER_ID", "user123"."CREATED_BY" AS "CREATED_BY", "user123"."CREATED_DATE" AS "CREATED_DATE", "user123"."OWN_ORGAN_CODE" AS "OWN_ORGAN_CODE", "user123"."LAST_MODIFIED_BY" AS "LAST_MODIFIED_BY", "user123"."LAST_MODIFIED_DATE" AS "LAST_MODIFIED_DATE" FROM "user123"
但是有些业务比较复杂,所以采用querydsl进行查询,但是测试的时候发现,querydsl执行时没有对表名进行双引号处理,所以在此情况下,无论我初始化数据库采用大写表名、小写表名,都会有一种情况产生找不到的表的情况。
请问如何在不修改实体表明注解为大写的情况下,能解决如上问题