hibernate.default_schema配置

Hibernate配置详解
本文详细介绍了Hibernate框架中的关键配置项,包括数据库方言设置、SQL显示、缓存策略等,并特别强调了默认模式设置对HQL语句的影响。
部署运行你感兴趣的模型镜像
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.connection.driver_class">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.jdbc.fetch_size">50</prop>
<prop key="hibernate.jdbc.batch_size">30</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>
<prop key="hibernate.cache.use_second_level_cache">false</prop>
<prop key="hibernate.hbm2ddl.auto">false</prop>
<prop key="hibernate.default_schema">SCOTT</prop>
</props>
</property>

此处hibernate.default_schema 是默认的数据库,会在hibernate发送hql语句的时候在表名称之前加上,如果不对,hql语句报错,表或者视图不存在

您可能感兴趣的与本文相关的镜像

Stable-Diffusion-3.5

Stable-Diffusion-3.5

图片生成
Stable-Diffusion

Stable Diffusion 3.5 (SD 3.5) 是由 Stability AI 推出的新一代文本到图像生成模型,相比 3.0 版本,它提升了图像质量、运行速度和硬件效率

这个是我的配置信息有没有需要修改的 spring: redis: host: 10.224.206.16 port: 6379 password: Siq2025redisZS datasource: type: com.zaxxer.hikari.HikariDataSource kafka: bootstrap-servers: 10.224.206.16:9092 listener: type: batch producer: acks: 1 batch-size: 16384 retries: 0 buffer-memory: 33554432 key-serializer: org.apache.kafka.common.serialization.StringSerializer value-serializer: org.apache.kafka.common.serialization.StringSerializer consumer: group-id: myGroup enable-auto-commit: true auto-commit-interval: 100 key-deserializer: org.apache.kafka.common.serialization.StringDeserializer value-deserializer: org.apache.kafka.common.serialization.StringDeserializer shardingsphere: mode: type: Memory repository: type: JDBC overwrite: false datasource: names: enterprise-info,tag,app enterprise-info: type: com.zaxxer.hikari.HikariDataSource driver-class-name: dm.jdbc.driver.DmDriver jdbc-url: jdbc:dm://10.224.206.78:5236/DAMENG?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true username: SYSDBA password: Dm123456 minimum-idle: 5 idle-timeout: 180000 maximum-pool-size: 300 max-lifetime: 0 connection-timeout: 30000 connection-test-query: select 1 connection-init-sql: SET SCHEMA ENTERPRISE_INFO tag: type: com.zaxxer.hikari.HikariDataSource driver-class-name: dm.jdbc.driver.DmDriver jdbc-url: jdbc:dm://10.224.206.78:5236/DAMENG?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true username: SYSDBA password: Dm123456 minimum-idle: 5 idle-timeout: 180000 maximum-pool-size: 300 max-lifetime: 0 connection-timeout: 30000 connection-test-query: select 1 connection-init-sql: SET SCHEMA TAG app: type: com.zaxxer.hikari.HikariDataSource driver-class-name: dm.jdbc.driver.DmDriver jdbc-url: jdbc:dm://10.224.206.78:5236/DAMENG?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true username: SYSDBA password: Dm123456 minimum-idle: 5 idle-timeout: 180000 maximum-pool-size: 300 max-lifetime: 0 connection-timeout: 30000 connection-test-query: select 1 connection-init-sql: SET SCHEMA APP rules: - type: SHARDING tables: enterprise_factdata_daily: actualDataNodes: enterprise-info.enterprise_factdata_daily$->{0..31} tableStrategy: standard: shardingColumn: social_creditcode shardingAlgorithmName: table-sharding-algorithm shardingAlgorithms: table-sharding-algorithm: type: CLASS_BASED props: strategy: standard algorithmClassName: com.tencent.egb.job.configuration.TableShardingAlgorithm props: # 关键配置:禁用数据库元数据检查 check-database-metadata-enabled: false check-table-metadata-enabled: false sql-show: false query-with-cipher-column: true check-duplicate-table-enabled: false proxy-frontend-flush-threshold: 128 sql-comment-parse-enabled: false jpa: database-platform: org.hibernate.dialect.DmDialect show-sql: true hibernate: ddl-auto: validate naming: physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl properties: hibernate: default_schema: ENTERPRISE_INFO dialect: org.hibernate.dialect.DmDialect hibernate.dialect.storage_engine: dm globally_quoted_identifiers: true globally_quoted_identifiers_skip_column_definitions: true jdbc.batch_size: 50 jdbc.fetch_size: 100 jdbc.time_zone: Asia/Shanghai temp.use_jdbc_metadata_defaults: false hibernate.length_force_inline: true hibernate.varchar.maxlength: 8188 format_sql: true use_sql_comments: true
最新发布
08-28
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值