无法将hibernate项目与mysql数据库连接

fnatzsnv  于 2021-06-17  发布在  Mysql
关注(0)|答案(0)|浏览(190)

关于数据库的详细信息我对hibernate不熟悉。我创建了一个hibernate项目。但是它无法连接到mysql数据库。我使用sql workbench作为数据库,使用xampp服务器作为sql服务器。请帮助我通过hibernate项目将数据传递到mysql数据库。
错误消息:
请求处理失败;嵌套异常为org.springframework.transaction.cannotcreatetransactionexception:无法打开事务的hibernate会话;嵌套异常为org.hibernate.exception.genericjdbception:无法打开连接
错误描述:
服务器遇到内部错误,无法完成此请求。
例外情况:

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

dispatcher-servlet.xml文件

<context:component-scan base-package="com.candidjava.springmvc.controller" />

<context:property-placeholder location="classpath:database.properties" />

<mvc:annotation-driven />

<bean id="dataSource111" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="${database.driver}" />
    <property name="url" value="${database.url}" />
    <property name="username" value="${database.user}" />
    <property name="password" value="${database.password}" />
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">

    <property name="dataSource" ref="dataSource111" />

    <property name="annotatedClasses">
        <list>
            <value>com.candidjava.springmvc.entity.Employee</value>

        </list>
    </property>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">${hibernate.dialect}</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
        </props>
    </property>
</bean>

<tx:annotation-driven/> 

<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory" />
</bean>

<bean id="persistenceExceptionTranslationPostProcessor" class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor"/>

<bean id="jspViewResolver"  class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="viewClass"  value="org.springframework.web.servlet.view.JstlView" />
    <property name="prefix" value="/WEB-INF/pages/" />
    <property name="suffix" value=".jsp" />
</bean>

<bean id="employeeDao" class="com.candidjava.springmvc.dao.impl.EmployeeDAOImpl" />

<bean id="employeeService" class="com.candidjava.springmvc.service.impl.EmployeeServiceImpl" />

数据库.properties

database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost:3306/test
database.user=root
database.password=root
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=true
hibernate.hbm2ddl.auto=update

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题