先整合了Spring和Hibernate编写了一个测试类Junit,但是不知道为什么测试类运行就出错,请大家帮我看看十分感谢困扰我好几天了。
错误信息如下:
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed;
nested exception is org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.MySQLDialect;
Caused by: org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.MySQLDialect;
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:104)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:65)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:460)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:155)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 30 more
Application.xml如下:
错误信息如下:
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed;
nested exception is org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.MySQLDialect;
Caused by: org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.MySQLDialect;
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:104)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:65)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:460)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:155)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 30 more
Application.xml如下:
解决方案 »
- 用过ibatis和mybatis的朋友请进
- 请教大家一个HQL的问题
- 请教高手关于开发jsp编码问题。
- 我在用hbm2java的时候生成的错误,我的cp值也对照了啊?怎么回事情啊
- Weblogic 10 部署 AXIS2 1.6.2
- 向各位dx求一个软件,在线等,解决马上给分,急!急!急!急!急!急!急!急!急!
- 我的一个很麻烦的问题,请高手指点,谢谢
- 没办法了,救命! 究竟怎么在JSP中调用EJB???
- jdbc更新错误的问题
- 大量数据列转横,循环处理率问题
- Unknown column '????????????' in 'field list'
- 100分求struts2 map传值问题!!这个很杯具啊。。。
loginTest如下:JAR包如下:
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="jdbcUrl">
<value>jdbc:mysql://localhost:3306/bd_website?useUnicode=true&characterEncoding=UTF-8
</value>
</property>
<property name="user">
<value>root</value>
</property>
<property name="password">
<value>111</value>
</property>
</bean><bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mappingResources">
<list>
<value>cn/login/bean/Login.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=org.hibernate.dialect.MySQLDialect;
hibernate.hdm2ddl.auto=update;
hibernate.show_sql=false;
</value>
</property>
</bean> <bean id="LoginDao" class="cn.login.daoimpl.LoginDaoImpl">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean></beans>
Test类:
在这个包里是否有MYSQLDialect.jar,正常的话应该是有的。
对应这句话来,改改你的配置文件
hibernate.hdm2ddl.auto=update;
hibernate.show_sql=false;这一段配置,把后面的;号去掉
hibernate.dialect=org.hibernate.dialect.MySQLDialect;
hibernate.hdm2ddl.auto=update;
hibernate.show_sql=false;
</value>
楼主,这个好像没有这样的写法吧,记得是<props>
<prop name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"></props>你试一下啊
<property name="name" type="java.lang.String">
好像不是这样配置吧,那个type直接= string(小写的s) 就行了吧?
<value>
hibernate.dialect=org.hibernate.dialect.MySQLDialect;
hibernate.hdm2ddl.auto=update;
hibernate.show_sql=false;
</value>
</property>
能这么写么?setHibernateProperties(Properties prop)参数传错了吧?你可以先试试jdbc,测试一下你的dataSource是不是能连接成功。基本上方言上的问题都是没有获得连接引起的
正确:
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="show_sql">true</prop>
我写成了:<prop key="dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>错误2,这个非常容易弄错:
正确:
<value>jdbc:mysql://localhost:3306/bd_website?useUnicode=true&characterEncoding=UTF-8</value>我写成了:<value>jdbc:mysql://localhost:3306/bd_website?useUnicode=true&characterEncoding=UTF-8
</value>