hibernate3.3+oracle11g的连接问题求解各位高手

Question

配置文件如下
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>
<session-factory>
<!-- 配置了一个oracle9i以上版本的信息 -->
<!-- 方言 -->
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9iDialect</property>
<!-- 驱动包 -->
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<!-- 登录账号 -->
<property name="hibernate.connection.username">scott</property>
<!-- 登录密码 -->
<property name="hibernate.connection.password">tiger</property>
<!-- 数据源的url -->
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:kongwf</property>

<!-- 呈现SQL语句 -->
<property name="show_sql">true</property>

<!-- 导入所有的对象映射文件 -->

<mapping resource="cn/edu/jstu/GraduationProjectTopicSystems/beans/Apply_topic.hbm.xml"/>
<mapping resource="cn/edu/jstu/GraduationProjectTopicSystems/beans/Role.hbm.xml"/>
<mapping resource="cn/edu/jstu/GraduationProjectTopicSystems/beans/Selected_topic.hbm.xml"/>
<mapping resource="cn/edu/jstu/GraduationProjectTopicSystems/beans/Stay_topic.hbm.xml"/>
<mapping resource="cn/edu/jstu/GraduationProjectTopicSystems/beans/Student.hbm.xml"/>
<mapping resource="cn/edu/jstu/GraduationProjectTopicSystems/beans/Teacher.hbm.xml"/>
<mapping resource="cn/edu/jstu/GraduationProjectTopicSystems/beans/Topic.hbm.xml"/>
<mapping resource="cn/edu/jstu/GraduationProjectTopicSystems/beans/Admin.hbm.xml"/>
</session-factory>

</hibernate-configuration>
提示的信息如下：
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" org.hibernate.HibernateException: The dialect was not set. Set the property hibernate.dialect.
at org.hibernate.dialect.Dialect.instantiateDialect(Dialect.java:256)
at org.hibernate.dialect.Dialect.getDialect(Dialect.java:234)
at org.hibernate.dialect.Dialect.getDialect(Dialect.java:249)
at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:121)
at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:91)
at com.jstu.test.tools.Export.main(Export.java:17)

Answer 1

方言应该是 org.hibernate.dialect.OracleDialect

Answer 2

你没有设置hibernate的dialect
在session factory中加下面代码
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
            //org.hibernate.dialect.SQLServerDialect
            //这是sqlserver的oracle的不太清楚，你查查
         prop>
</props>
</property>

Answer 3

<property name="hibernate.dialect">org.hibernate.dialect.Oracle9iDialect</property>改为<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>

Answer 4

加上:
<property name="dialect">
org.hibernate.dialect.SQLServerDialect
</property>

Answer 5

我不觉得 是哪里写错了，错误显示是根本没有配置方言~~仔细一看 原来是楼主所有的属性名称全部写错了，都把hibernate去掉就可以了，不知道你在哪里找的例子~~
<property name="dialect">org.hibernate.dialect.Oracle9iDialect</property>
<!-- 驱动包 -->
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<!-- 登录账号 -->
<property name="connection.username">scott</property>
<!-- 登录密码 -->
<property name="connection.password">tiger</property>
<!-- 数据源的url -->
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:kongwf</property>
加油~~~