[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-514) getDatabaseMajorVersion unsupported by some Oracle drivers

[Rene Gielen (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-514?page=comments#action_25221 ] 

Rene Gielen commented on HHH-514:
---------------------------------

I would  recommend to switch to current Oracle JDBC driver instead. We had the same problem here, switching to 10.2.0.2 driver solved the problem immediately, without any configuration change requirements.
Download link: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html

Remember that Oracle recommends you to use 10 series drivers even if you are connecting to a 8 or 9 series database server!


> getDatabaseMajorVersion unsupported by some Oracle drivers
> ----------------------------------------------------------
>
>          Key: HHH-514
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-514
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0.4
>  Environment: WLS 8.1 SP2, Hibernate 3.0.4, Oracle9i Enterprise Edition Release 9.2.0.4.0, Oracle JDBC driver 9.2.0.3.0
>     Reporter: Mathias Bogaert
>     Priority: Critical

>
>
> Put an extra try catch around databaseMajorVersion = meta.getDatabaseMajorVersion(); in SettingsFactory (change occured in version 1.31) and handle 0 value in  DialectFactory.buildDialect.
> WARN - Could not obtain connection metadata
> java.sql.SQLException: Kenmerk wordt niet ondersteund.
>         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
>         at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:690)
>         at oracle.jdbc.OracleDatabaseMetaData.getDatabaseMajorVersion(OracleDatabaseMetaData.java:4451)
>         at weblogic.jdbc.wrapper.DatabaseMetaData_oracle_jdbc_driver_OracleDatabaseMetaData.getDatabaseMajorVersion(Unknown Source
> )
>         at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:75)
>         at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
>         at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira