适用于Oracle的Hibernate方言19 [英] Hibernate Dialect for Oracle 19

问题描述

我们的一个数据库已升级到Oracle 19c，现在我的应用程序无法连接到数据库

One of our database was upgraded to Oracle 19c and now my application is unable to connect to database

我遇到以下错误.

HHH000400: Using dialect: org.hibernate.dialect.Oracle12cDialect
HHH000342: Could not obtain connection to query metadata : Unable to determine Dialect to use [name=Oracle, majorVersion=19]; user must register resolver or explicitly set 'hibernate.dialect'

我搜索了方言中的oracle 19，但是找不到任何方言.

I searched for dialect for oracle 19 but could't find any .

oracle 19是否有方言可用?

Is there is a dialect available for oracle 19 ?

推荐答案

没有比12c更新的方言，可以将其与19c一起使用，但是hibernate-orm中存在一个错误，可以防止自动检测正常工作，请参阅:

There isn't a newer dialect than 12c, and it would be fine to use it with 19c, but there was a bug in hibernate-orm that prevents the auto detection to work, see:

https://hibernate.atlassian.net/browse/HHH-13184

https://hibernate.atlassian.net/browse/HHH-13609

在较新的5.4版本中已经解决了该问题，我为5.3分支打开了PR.

It is already solved in the newer 5.4 releases, and I opened a PR for the 5.3 branch.

目前的解决方法是将方言属性hibernate.dialect手动设置为org.hibernate.dialect.Oracle12cDialect.

A workaround for now is to manually set the dialect property hibernate.dialect to org.hibernate.dialect.Oracle12cDialect.

这篇关于适用于Oracle的Hibernate方言19的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！