创建表出错

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
    <class
        name="org.nhweather.data.ZDZHourData"
        dynamic-update="false"
        dynamic-insert="false"
    >

        <id
            name="hourdata_id"
            column="hourdata_id"
            type="java.lang.String"
            length="32"
        >
            <generator class="uuid.hex">
            </generator>
        </id>

        <timestamp
            name="dayMaxTempTime"
            column="daymaxtemptime"
        />
        <timestamp
            name="dayMinTempTime"
            column="daymintemptime"
        />

        <property
            name="wf10DayMax"
            type="int"
            update="true"
            insert="true"
        >
            <column
                name="wf10daymax"
                sql-type="TINYINT"
            />
        </property>

        <property
            name="wf3DayMax"
            type="int"
            update="true"
            insert="true"
        >
            <column
                name="wf3daymax"
                sql-type="TINYINT"
            />
        </property>

        <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-ZDZHourData.xml
            containing the additional properties and place it in your merge dir.
        -->

    </class>

</hibernate-mapping>
<!----------------------------------------------->
hibernate.dialect net.sf.hibernate.dialect.OracleDialect
<!---------------------------------------------->
schemaexport] Unsuccessful: ORA-00902: 无效数据类型
我用的是oracle,哪里的问题?

ddl中有非法的数据类型。

sql-type 里BIT,TINYINT,BIGINT,SMALLINT,VARCHAR,NUMERIC等等怎么用,难道要NUMBER(1,0),NUMBER(3,0),NUMBER(19,0),VARCHAR2($l),NUMBER(19, $l)等来代替?

sql-type里当然只能用你的数据库支持的数据类型了。

Dialect有什么用,它不会自动转换的吗?

Dialect还没这么聪明，也许以后会: )

那不是每个数据库都要重新写一次hbm.xml?

如果你要指定某种数据库特有的类型的话，那就要

* An SQL dialect for Oracle 9 (uses ANSI-style syntax where possible).
* @author Gavin King, David Channon

public class Oracle9Dialect extends Dialect {

private final Map aggregateFunctions = new HashMap();

public Oracle9Dialect() {
super();
register( Types.BIT, "NUMBER(1,0)" );
        register( Types.TINYINT, "NUMBER(3,0)" );
<------------------------------->
register()有什么用,还有怎么用BIT,TINYINT这些类型