Hibernate 3.3.0与Oracle 12c的兼容性 [英] Hibernate 3.3.0 compatibility with Oracle 12c

问题描述

此帖子类似于链接
但我找不到答案.我正在从Oracle 11g迁移到Oracle 12c.我可以使用与休眠3.3.0 org.hibernate.dialect.OracleDialect.
相同的方言吗? 我也使用的是ojdbc14.jar，它是JDBC驱动程序版本10.2.0.3.0.根据Oracle，我需要使用至少ojdbc6.jar或最低JDBC驱动程序版本11.1.0.x.如果我使用ojdbc6.jar，则需要解决java.sql.date和Timestamp SQL类型的冲突.将Long类型更改为LOB类型.如果我错了，请更正，并让我知道其他我可能会错过的事情.

This post is similar to link
But I do not find answer. I am migrating from Oracle 11g to Oracle 12c. Can I use the same dialect available with hibernate 3.3.0 org.hibernate.dialect.OracleDialect.
Also I am using ojdbc14.jar which is JDBC driver version 10.2.0.3.0. And as per Oracle I need to use atleast ojdbc6.jar or minimum JDBC driver version 11.1.0.x. If I use ojdbc6.jar then I need to resolve conflicts of java.sql.date and Timestamp SQL type; change Long types to LOB types. Please correct if I am wrong and let me know other things as well which I may be missing.

推荐答案

查看此链接

see this link Differences between classes12.jar, ojdbc14.jar, ojdbc5.jar and ojdbc6.jar. The name of the driver file has noting to do with the datbase driver version. It just matches compliance with the version of JDBC standard.

因此ojdbc6.jar的驱动程序版本为10g，11g或12c.它甚至可以是Oracle支持提供的驱动程序，其中仅包含一个针对您的特定修补程序.

So ojdbc6.jar can have driver version 10g, 11g or 12c. It can even be a driver provided by Oracle support containing one specific fix just for you.

由于某些版本(1.5)的Oracle JDBC驱动程序是可执行的.您只需执行它们即可获得确切的版本:

Since some version (1.5) Oracle JDBC drivers are executable. You can simply execute them to get exact version:

java -jar ojdbc5.jar
Oracle 11.2.0.3.0 JDBC 3.0 compiled with JDK5 on Tue_Aug_23_13:32:03_PDT_2011
#Default Connection Properties Resource
#Wed Apr 06 12:37:06 CEST 2016

除非您仍在使用Java 1.4，否则不应使用ojdbc14.jar.

You should not use ojdbc14.jar, unless you're still on Java 1.4.

Oracle保证与主要版本号相差一的客户端兼容.在某些情况下，可以通过设置来绕过 sqlnet.ora文件中的 SQLNET.ALLOWED_LOGON_VERSION 在数据库服务器端.

Oracle guarantees compatibility with clients having difference of one in major version number. In some cases this can by bypassed by setting SQLNET.ALLOWED_LOGON_VERSION in sqlnet.ora file on db server side.

这篇关于Hibernate 3.3.0与Oracle 12c的兼容性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！