3 Replies Latest reply: Dec 16, 2009 11:13 AM by Jayan Kandathil RSS

    Oracle Connection error in Hibernate

    tgoodmannz_bss Community Member

      Hi,

       

      We've just installed ES2 on a WebSphere Cluster (on Linux) with an Oracle 10g database

       

      Everything appears to be running fine, but we've noticed a lot of errors in the log like this:

       

      [14/12/09 12:26:00:149 EST] 0000003b ErrorLogger   E org.quartz.core.ErrorLogger schedulerError Job (QUARTZ_JOBGROUP_IDP.DIRSYNC_FINISHER_JOB threw an exception.
                                       org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: com.ibm.ejs.container.UnknownLocalException: nested exception is: org.hibernate.HibernateException: unknown Oracle major version [0]]
          at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
          at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
      Caused by: com.ibm.ejs.container.UnknownLocalException: nested exception is: org.hibernate.HibernateException: unknown Oracle major version [0]
          at org.hibernate.dialect.DialectFactory$1.getDialectClass(DialectFactory.java:150)
          at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:65)
          at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
          at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
          at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
          at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
          at com.adobe.idp.um.businesslogic.dao.hibernate.HibernateUtils.getSessionFactory(HibernateUt ils.java:57)
          at com.adobe.idp.um.businesslogic.dao.hibernate.HibernateUtils.getSession(HibernateUtils.jav a:75)
          at com.adobe.idp.um.businesslogic.synch.hibernate.HibernateSynchronizationDao.getSession(Hib ernateSynchronizationDao.java:81)
          at com.adobe.idp.um.businesslogic.synch.hibernate.HibernateSynchronizationDao.acquireCluster Lock(HibernateSynchronizationDao.java:1081)
          at com.adobe.idp.um.businesslogic.synch.dao.EJSLocalStatelessHibernateSynchronizationDao_b06 e7930.acquireClusterLock(Unknown Source)
          at com.adobe.idp.um.scheduler.AbstractClusterJob.execute(AbstractClusterJob.java:76)
          at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
          ... 1 more
      Caused by: org.hibernate.HibernateException: unknown Oracle major version [0]
          ... 15 more

       

      This link appears to show some that this can occur with hibernate:

       

      This link appears to describe similar issues:  https://forum.hibernate.org/viewtopic.php?p=2373597

       

      Any thoughts on whether we should apply specific patches?

       

      Thanks