使用Hibernate JPA for Oracle创建表引发错误

Question

我尝试通过将hibernate.hbm2ddl.auto设置为“create”来使用JPA自动创建Oracle表。其中一个实体字段是布尔类型的，在Java中如下所示：

private boolean activateCustomer;

但是，当我们运行它时，会抛出一个错误，当我看到错误时，生成的sql类型是布尔型的，而不是数字型的（1）。我使用Hibernate 4.1.9和Oracle XE（文件:oraclexe112_win32.zip)。

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.0" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="persistenceUnit" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
        <!-- value="create" to build a new database on each run; value="update" to modify an existing database; value="create-drop" means the same as "create" but also drops tables when Hibernate closes; value="validate" makes no changes to the database -->
        <property name="hibernate.hbm2ddl.auto" value="create"/>
        <property name="hibernate.ejb.naming_strategy" value="org.hibernate.cfg.ImprovedNamingStrategy"/>
        <property name="hibernate.connection.charSet" value="UTF-8"/>
        <!-- Uncomment the following two properties for JBoss only -->
        <!-- property name="hibernate.validator.apply_to_ddl" value="false" /-->
        <!-- property name="hibernate.validator.autoregister_listeners" value="false" /-->
    </properties>
</persistence-unit>

Answer 1

看来您使用的是11g，因此您的方言应该是org.hibernate.dialt.Oracle10gDialce而不是只适用于Oracle8的org.hibernate.dialt.OracleDialce。