oracle建表主键自增_Hibernate为Oracle自动创建表且主键自增 | 学步园

Sql代码

create sequence seq_id_supervision

minvalue 1

start with 1

increment by 1

create sequence seq_id_supervision

minvalue 1

start with 1

increment by 1

注：如果多个表要映射自增长主键，每个表要建一个sequence。

(2)model映射配置：

Xml代码  

<

id

name

=

"id"

>

<

generator

class

=

"sequence"

>

<

param

name

=

"sequence"

>

seq_id_letter

param

>

generator

>

id

>

seq_id_letter

(3)Hibernate映射文件配置：

Xml代码  

<

hibernate-configuration

>

<

session-factory

>

<

property

name

=

"hibernate.connection.driver_class"

>

oracle.jdbc.driver.OracleDriver

property

>

<

property

name

=

"hibernate.connection.url"

>

jdbc:oracle:thin:@localhost:1521:jf

property

>

<

property

name

=

"hibernate.connection.username"

>

jf

property

>

<

property

name

=

"hibernate.connection.password"

>

jf

property

>

<

property

name

=

"hibernate.dialect"

>

org.hibernate.dialect.OracleDialect

property

>

<

property

name

=

"hibernate.show_sql"

>

true

property

>

<

property

name

=

"hibernate.hbm2ddl.auto"

>

update

property

>

<

property

name

=

"hibernate.cache.provider_class"

>

org.hibernate.cache.HashtableCacheProvider

property

>

<

mapping

resource

=

"com/chinasoft/jfb/model/LetterInformation.hbm.xml"

/>

session-factory

>

hibernate-configuration

>

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@localhost:1521:jf

jf

jf

org.hibernate.dialect.OracleDialect

true

update

org.hibernate.cache.HashtableCacheProvider