unknown oracle major version [0],Caused by: org.hibernate.HibernateException: unknown Oracle major v...

昨天試了一下把mysql的數據源配置mysql-ds.xml放在jboss下面跑，成功了；后來我想那oracle數據源配置oracle-ds.xml也可以在jboss下面跑了。我就試了一下， 在啟動Eclipse時報以下錯誤：

11:04:48,078 INFO  [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 9.2.0.1.0

11:04:48,125 ERROR [AbstractKernelController] Error installing to Start: name=persistence.unit:unitName=#ztf state=Create

javax.persistence.PersistenceException: [PersistenceUnit: ztf] Unable to build EntityManagerFactory

at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)

at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:132)

at org.jboss.jpa.deployment.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:311)

Caused by: org.hibernate.HibernateException: unknown Oracle major version [0] at org.hibernate.dialect.DialectFactory$1.getDialectClass(DialectFactory.java:173)

at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:88)

at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:62)

11:04:48,265 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS

FOR DETAILS):

*** CONTEXTS MISSING DEPENDENCIES: Name -> Dependency{Required State:Actual State}

jboss.j2ee:jar=EntityBean.jar,name=PersonServiceBean,service=EJB3

-> {Described:** UNRESOLVED Demands

'persistence.unit:unitName=#ztf' **}

*** CONTEXTS IN ERROR: Name -> Error

persistence.unit:unitName=#ztf -> org.hibernate.HibernateException: unknown Oracle major version [0]

-> ** UNRESOLVED Demands

'persistence.unit:unitName=#ztf' **

11:04:48,453 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8090

出現這個問題，接着在網上google了一下，在http://forum.hibernate.org/viewtopic.php?p=2373597下找到了答案。

我出現的問題已解決，如下：1.persistence.xml下的數據源配置為java:/ztfDS。

2.在persistence.xml下加入SQL方言

jboss下數據源的配置，分以下幾種情況：

1.選擇的是mysql-ds.xml，此文件相應位置設為 ztfDS，那么在persistence.xml中相應設置為java:ztfDS。

2.選擇的是oracle-ds.xml，此文件相應位置設為ztfDS，那么在persistence.xml中相應設置為java:/ztfDS。