ORACL 自动生成hid----------->xml配置

1.建立序列

   

2.测试序列是否创建成功

select SHB.testgrid.nextval from dual

       查询表空间下的序列

3.配置****.hbm.xml

<id name="hid" type="java.lang.Long" column="hid"><generator class="sequence"><param name="sequence">SHB.TESTGRID</param></generator></id>

4.插入值

INSERT INTO "SHB"."STATIS_JFJL_COPY"VALUES(testgrid.nextval,1,1,1,'1','1');

5.oracl插入日期

INSERT INTO "SHB"."GRID_DEMO"VALUES(griddemo.nextval,'a',2,to_date('2011-04-01 00:11;11','yyyy-mm-dd hh24:mi:ss'));