1 Reply Latest reply on Aug 10, 2007 12:27 PM by Elias Ross

    Using Oracle sequence with JBOSS

    . . Newbie

      Hi,

      I'm trying to use JBOSS IDE for Eclipse but I'm having trouble using an automatic generated id populated from a Oracle sequence previously created in the database. I guess there is some aditional configuration that I need to do in my application but I don't know what it is.

      In the persistence XML I have:

      <?xml version="1.0" encoding="UTF-8"?>
      <persistence>
       <persistence-unit name="shoestringPU">>
       <jta-data-source>java:/OracleDS</jta-data-source>
       <properties>
       <property name="hibernate.dialect"
       value="org.hibernate.dialect.OracleDialect"/>
       </properties>
       </persistence-unit>
      </persistence>
      


      At the entity bean I have:

       @Id
       @GeneratedValue(strategy=GenerationType.AUTO)
       public int getId() {
       return id;
       }
      


      I'm getting the error "java.sql.SQLException: ORA-02289: sequence does not exist".

      Thank you.

      Nei