Hibernate Code Generation with Oracle

[jpremji]

I am using the hibernate code generation with a reverse engineering xml file and would like to generate the sequences for the tables. I am generating EJB3 annotations entity beans. Is there any way of performing this task.

[maxandersen]

i don't understand the question...

[szgrick]

I have some quesstion that i use hibernate code generation with oracle, type of INTEGER in oracle will be changed type of BigDecimal in generate coed.How to slove this quesstion.I want type of BigDecimal is int.

[maxandersen]

that is because the INTEGER type is bigger (or at least reported to be by the driver) than a java int.

Setup your reveng.xml to map the type/column to whatever type you want.

[jpremji]

With regard to the integer, yes that was a problem and i have added the following to the reveng.xml file

<type-mapping>
<sql-type jdbc-type="DECIMAL" scale="0" hibernate-type="java.lang.Long"></sql-type>

</type-mapping>

[jpremji]

The question i am asking is if there is any way to change the reveng.xml file to include the generation of the
@SequenceGenerator(name="TABLE_ID_SEQ",sequenceName="TABLE_ID_SEQ",allocationSize=1) annotation for each table
and the
@GeneratedValue(generator="TABLE_ID_SEQ") annotation
or a template example that i can use to generate these items.

[maxandersen]

you can use reveng.xml to configure the id generator for your tables.

if that is not flexible enough for you then try and implement the logic in a custom revengstrategy impl or simply tweak the hbm.ftl templates.

Note that i'm not sure if the annotation generation does ths correctly; so we might need to fix that.

let me know if you bump into problems there.

[jpremji]

Thanks for the reponse. Is there any example of settting the reveng.xml file to generate the sequence. I am a newbie to java development. Any other pointers to information to help will be greatly appreciated.

[maxandersen]

the docs are a good place to start :)

http://www.hibernate.org/hib_docs/tools/reference/en/html_single/

look for <generator