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
prepared statement get: select hi_value.nextval from dual
DEBUG [RMICallHandler-5] (SessionFactoryImpl.java:557) - preparing statement
DEBUG [RMICallHandler-5] (JDBCExceptionReporter.java:34) - SQL Exception
java.sql.SQLException: ORA-02289: sequence does not exist
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?