java - Spring/Hibernate/Oracle: ORA-02289 Sequence Does Not Exist? -
getting java.sql.sqlsyntaxerrorexception: ora-02289: sequence not exist when trying insert new object oracle table. table have sequence automatically increments upon each entry. i've been stuck on few hours , after following similar answers question , other articles, i'm still stuck. my class: import java.sql.timestamp; import javax.persistence.column; import javax.persistence.entity; import javax.persistence.generatedvalue; import javax.persistence.generationtype; import javax.persistence.id; import javax.persistence.sequencegenerator; import javax.persistence.table; import org.springframework.stereotype.component; @entity @table(name = "my_schema.my_table") @component public class someclass { @id @sequencegenerator(name = "my_seq", sequencename = "my_seq", allocationsize = 1) @generatedvalue(strategy = generationtype.sequence, generator = "my_seq") @column(name = "my_id") private integer myid;