have a problem with using the generator:

in my mapping file. I am connecting to an Oracle 9i database through a JNDI-based OC4J container-managed JDBC connection pool. The error i get in my log file is

The error makes some sense as i do not have these attributes in the database, which leads to my question. How do you configure, and what do you need to configure, to get an auto-generated ID for a newly created object when you are saving the newly created object?

i did some digging and figured it out. thanks anyways :-)

You simply need to create the correct sequence(s) in Oracle for generating your Ids.

If you tell the Hibernate configuration that the sequence is called "hi_value" (as in the example) then you need to create a sequence in Oracle with that name:



or something like:



etc. (I'm doing this by memory - so check your Oracle docs for syntax).

that's really all there is to it, other than providing Hibernate the configuration as in your example.

james

thanks, this was exactly the issue. i had to make a sequence and i used the standard oracle syntax:



After adding the sequence the insert worked fine.

Use hbxmltoddl tool to generate the ddl statement.