J
J
Johnny_key2017-01-07 22:41:44
Java
Johnny_key, 2017-01-07 22:41:44

Hibernate, DB connection error, what's the problem?

Hi, please tell me why this error is
coming out: 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:982
) )
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729 )
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

<?xml  version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans [url]http://www.springframework.org/schema/beans/spring-beans.xsd[/url] [url]http://www.springframework.org/schema/context[/url] [url]http://www.springframework.org/schema/context/spring-context.xsd[/url] [url]http://www.springframework.org/schema/mvc[/url] [url]http://www.springframework.org/schema/mvc/spring-mvc.xsd[/url] [url]http://www.springframework.org/schema/tx[/url] http://www.springframework.org/schema/tx/spring-tx.xsd">
 
 
    <context:component-scan base-package="com.project.controller"/>
    <bean id="ViewResolver"  class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/" />
        <property name="suffix" value=".jsp" />
    </bean>
 
    <!-- Database Information -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
          destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url"
                  value="jdbc:mysql://localhost:3306/course"/>
        <property name="username" value="admin"/>
        <property name="password" value="1234"/>
    </bean>
 
    <!-- Hibernate 4 SessionFactory Bean definition -->
    <bean id="hibernate4AnnotatedSessionFactory"
          class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="annotatedClasses">
            <list>
                <value>com.project.model.User</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect
                </prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>
 
    <!--BookDao and BookService beans-->
    <bean id="userDao" class="com.project.dao.UserDaoImpl">
        <property name="sessionFactory" ref="hibernate4AnnotatedSessionFactory"/>
    </bean>
 
    <bean id="userService" class="com.project.service.UserServiceImpl">
        <property name="userDao" ref="userDao"/>
    </bean>
 
    <context:component-scan base-package="com.project"/>
 
    <tx:annotation-driven transaction-manager="transactionManager"/>
 
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="hibernate4AnnotatedSessionFactory"/>
    </bean>
 
    <mvc:default-servlet-handler/>
    <mvc:annotation-driven/>
</beans>

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
aol-nnov, 2017-01-07
@aol-nnov

What's not clear? how to translate or how to diagnose?
1) open googletranslate
2) you take any manager for mysql, and you find out that the server is not running or the user does not have an admin password of 1234 or there is no user at all, or ...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question