67,513
社区成员
发帖
与我相关
我的任务
分享
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into t_node (name, level, pid, isLeaf, id) values (?, ?, ?, ?, ?)
SQL> select hibernate_sequence.nextval from dual;
NEXTVAL
----------
2
<property name="hibernate.connection.username">scott</property>
<property name="hibernate.connection.password">tiger</property>
select table_name from user_tables;
<hibernate-mapping package="com.cfd.node">
<class name="Node" table="t_node" >
<id name="id">
<generator class="native"></generator>
</id>
<property name="name"/>
<property name="level"/>
<many-to-one name="parent" class="Node" column="pid"></many-to-one>
<property name="isLeaf"/>
<set name="children">
<key column="pid"></key>
<one-to-many class="Node"/>
</set>
</class>
</hibernate-mapping>
drop table t_node cascade constraints
drop sequence hibernate_sequence
create table t_node (id number(10,0) not null, name varchar2(255), level number(10,0), pid number(10,0), isLeaf number(1,0), primary key (id))
alter table t_node add constraint FKCB608EEDC4A604FF foreign key (pid) references t_node
create sequence hibernate_sequence
<hibernate-configuration>
<session-factory >
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:cfd</property>
<property name="hibernate.connection.username">scott</property>
<property name="hibernate.connection.password">tiger</property>
<property name="show_sql">true</property>
<mapping resource="com/cfd/Node/Node.hbm.xml"/>
</session-factory>
</hibernate-configuration>