昨天試了一下把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
-> <UNKNOWN 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]
<UNKNOWN jboss.j2ee:jar=EntityBean.jar,name=PersonServiceBean,service=EJB3> -> ** 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下<jta-data-source>的數據源配置為java:/ztfDS。
2.在persistence.xml下<properties>加入SQL方言<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect"/>
jboss下數據源的配置，分以下幾種情況：
1.選擇的是mysql-ds.xml，此文件相應位置設為 <jndi-name>ztfDS</jndi-name>，那么在persistence.xml中相應設置為<jta-data-source>java:ztfDS</jta-data-source>。
2.選擇的是oracle-ds.xml，此文件相應位置設為<jndi-name>ztfDS</jndi-name>，那么在persistence.xml中相應設置為<jta-data-source>java:/ztfDS</jta-data-source>。
posted @ 2009-03-26 12:43 斷點 閱讀(1001) | 評論 (0)