glassfish服务器上hibernate.cfg.xml中的sqlite路径

Question

我正在尝试使用hibernate来使用sqlite。然而，我在配置sqlite数据库路径时遇到了困难。目前，我的hibernate.cfg.xml是这样的：

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="connection.url">jdbc:sqlite:test.db</property>
        <property name="connection.driver_class">org.sqlite.JDBC</property>
        <property name="hibernate.dialect">org.hibernate.dialect.SQLiteDialect</property>
        <property name="current_session_context_class">thread</property>
        <mapping class="com.test.entity.Category"/>
        <!-- DB schema will be updated if needed -->
        <!-- <property name="hbm2ddl.auto">update</property> -->
    </session-factory>
</hibernate-configuration>

我正在使用IntelliJ。我在resources&在工件中，我可以在classes包中看到它。然而，每次我得到这个错误：

org.hibernate.hql.internal.ast.QuerySyntaxException: Category is not mapped [select id from Category]

类别.java

@Entity
@Table(name = "category", schema = "", catalog = "")
public class Category {
    private String id;
    private String name;
    private String imageUrl;
    @Id
    @Column(name = "id")
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    @Basic
    @Column(name = "name")
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    @Basic
    @Column(name = "imageUrl")
    public String getImageUrl() {
        return imageUrl;
    }
}

Hibernate Util.java

public class HibernateUtil {
    private static SessionFactory sessionFactory;
    private static SessionFactory buildSessionFactory() {
        try {
            Configuration configuration = new Configuration();
            configuration.configure("hibernate.cfg.xml");
            ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().applySettings(
                    configuration.getProperties()).build();
            return configuration.buildSessionFactory(serviceRegistry);
        } catch (Throwable ex) {
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }
    public static SessionFactory getSessionFactory() {
        if(sessionFactory == null){
            sessionFactory = buildSessionFactory();
        }
        return sessionFactory;
    }
    public static void shutdown() {
        getSessionFactory().close();
    }
}

我使用的是Hibernate 5.1.0版

我已经检查了sessionFactory.getAllClassMetadata()——它显示没有映射类。如有任何帮助，我们将不胜感激。

Answer 1

您使用了不正确的Hibernate 5配置方式。

Configuration configuration = new Configuration();
configuration.configure("hibernate.cfg.xml");
ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().applySettings(
        configuration.getProperties()).build();
return configuration.buildSessionFactory(serviceRegistry);

在Hibernate 5中，当您执行configuration.configure("hibernate.cfg.xml")时，一切都配置正确。但当您执行configuration.buildSessionFactory(serviceRegistry)时，所有配置都将丢失。

只做

return new Configuration().configure().buildSessionFactory();

参考

Hibernate 5:-org.Hibernate.MappingException：未知实体