Home  >  Q&A  >  body text

java - spring mvc integrates hibernate5 access error Could not locate cfg.xml resource

Spring MVC integrates the Hibernate5 framework—the database connection and other information has been configured in the dispatcher-servlet.xml file. I wrote a simple function to create a new data table (just a few files). No error is reported when running, but HTTP Status 500 error is reported when accessing. org.hibernate.internal.util.config.ConfigurationException: Could not locate cfg.xml resource [hibernate.cfg.xml], but it is strange that the data table was successfully created but no data was written.
What I am very confused about is that after hibernate4, sessionFactoryBean is not used to replace the hibernate.cfg.xml file. I did not create the hibernate.cfg.xml file. Some specific files and error screenshots are as follows

dispatcher-servlet.xml file

<?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:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">

    <!-- 扫描使用注解的类所在包 -->
    <context:component-scan base-package="com.hiber.*"/>

    <!-- 配置数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/hiber?useUnicode=yes&amp;characterEncoding=UTF-8" />
        <property name="username" value="root" />
        <property name="password" value="3443"/>
    </bean>

    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <!-- 注入数据源 -->
        <property name="dataSource" ref="dataSource"/>
        <!-- 找到实体包(pojo) -->
        <property name="packagesToScan" value="com.hiber.*" />
        <property name="hibernateProperties">
            <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQL57Dialect</prop>
            <prop key="hibernate.hbm2ddl.auto">create</prop>
            <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>

    <bean id="entityManagerFactoryBean" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 找到实体包(pojo) -->
        <property name="packagesToScan" value="com.hiber.*" />
        <!--指定jpa适配器-->
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" />
        </property>
        <!--<!&ndash;指定jpa属性&ndash;>-->
        <!--<property name="jpaProperties">-->
            <!--<props>-->
                <!--<prop key="hibernate.dialect">org.hibernate.dialect.MySQL57Dialect</prop>-->
                <!--<prop key="hibernate.hbm2ddl.auto">create</prop>-->
                <!--<prop key="hibernate.show_sql">true</prop>-->
            <!--</props>-->
        <!--</property>-->
    </bean>

    <!-- 配置hibernate事务管理器 -->
    <bean id="hibernateTransactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
    <tx:annotation-driven />
</beans>

Message.java file

package com.hiber.entity;

import javax.persistence.*;

@Entity
public class Message{
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    int id;
    @Column(nullable = false)
    String text;

    public Message(String text) {
        setText(text);
    }
    public Message(){}

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getText() {
        return text;
    }

    public void setText(String text) {
        this.text = text;
    }
}

IndexController.java file

package com.hiber.controllers;

import com.hiber.entity.Message;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.MetadataSources;
import org.hibernate.boot.registry.StandardServiceRegistry;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;


@Controller
public class IndexController {
    @RequestMapping(value = "/persist")
    public String saveMessage(){
        Message message = new Message("Hello, world");
        StandardServiceRegistry registry = new StandardServiceRegistryBuilder()
                .configure()
                .build();
        SessionFactory sessionFactory =  new MetadataSources(registry).buildMetadata().buildSessionFactory();
        Session session = sessionFactory.openSession();
        Transaction tx = session.beginTransaction();
        session.persist(message);
        tx.commit();
        return "数据添加成功!";
    }
}

Browser error screenshot

Screenshot of successful data table creation

Project structure

Please help to find out what went wrong, Thanks in advance!

为情所困为情所困2713 days ago2077

reply all(2)I'll reply

  • 黄舟

    黄舟2017-05-17 10:05:38

    Hibernate version 5.2 or above is written like this:

    Message message = new Message("Hello,world!");
            Configuration configuration = new Configuration();
            StandardServiceRegistry registry = new StandardServiceRegistryBuilder().applySettings(configuration.getProperties()).build();
            SessionFactory sessionFactory = new MetadataSources(registry).buildMetadata().buildSessionFactory();
            Session session = sessionFactory.openSession();
            Transaction tx = session.beginTransaction();
            session.persist(message);
            tx.commit();
            return "数据添加成功!";

    org.hibernate.internal.util.config.ConfigurationException: Could not locate cfg.xml resource [hibernate.cfg.xml] The problem was solved, but org.hibernate.service.spi.ServiceException: Unable to create requested appeared again service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment], also help!

    reply
    0
  • PHPz

    PHPz2017-05-17 10:05:38

    View the web.xml configuration, as follows:

    <!-- 加载Spring -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    
    <!-- spring默认的配置文件名称是:applicationContext.xml,如果是默认则不需要配置 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/applicationContext.xml,
            /WEB-INF/daoContext.xml</param-value>
    </context-param>

    The data source, sessionFactory, transaction manager, and transactions are configured in daoContext.xml;
    Do you add these? See if there are any errors

    reply
    0
  • Cancelreply