请问,hibernate 与oracle 11g 链接的配置这样写哪里有问题?

问题描述:

这是我的配置文件:
[code="xml"]

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@LOCALHOST:1521:ORCL

SCOTT
tiger
org.hibernate.dialect.OracleDialect
true
update

    <mapping resource="user.hbm.xml"/>
    <mapping resource="friend.hbm.xml"/>
    <mapping resource="userinfo.hbm.xml"/>
    <mapping resource="offlinemessage.hbm.xml"/>
</session-factory>

[/code]

下面是报错信息:
[code="java"]org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
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.buildSettingsInternal(Configuration.java:2090)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2086)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1311)
at org.fw.utils.HibernateSessionFactory.(HibernateSessionFactory.java:32)
at org.fw.qq.server.QQServer$1.actionPerformed(QQServer.java:46)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6505)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:708)
at java.awt.EventQueue$4.run(EventQueue.java:706)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)[/code]

请教正确的配置方法,google 搜索的很多还是没有解决.

你的hibernate.dialct这个属性没有配置正确。或者有可能是配置正确而没有调用才会导致这个问题。

还有就是可能你的实体映射有问题 你这个好像是练习用的 能发源码吗?

看配置没啥问题,你确认一下是不是hibernate的版本啊 jar包啥的有没有冲突之类的

错误提示应该是Dialect错了
官方上面没有看到11g的支持
但是10g的 Dialect 应该在11里面能用的

org.hibernate.dialect.Oracle10gDialect

LOCALHOST 改成localhost

数据库方言没有精确设置,oracle不同版本的驱动,略有差别。10跟11的都要用org.hibernate.dialect.Oracle10gDialect 来配置。你可以直接看你的驱动包org.hibernate.dialect目录下的类。oralce 9 方言配置则是 org.hibernate.dialect.Oracle9gDialect。更低版本的配置为org.hibernate.dialect.OraclegDialect。更多的方言信息,可参见http://blog.sina.com.cn/s/blog_65f22a050101193p.html。